【 以下文字转载自 Quant 讨论区 】
发信人: pipinu (pipinu), 信区: Quant
标 题: 哪位大狭帮我看下这个SQL 出什么问题啊? 谢谢
发信站: BBS 未名空间站 (Tue May 25 14:55:43 2010, 美东)
1)是可以运行,2)就出错
Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS"
and "SQL_Latin1_General_CP850_BIN" in the equal to operation
怎么回事情?头大了 :(:(
1)
select * from xf.dbo.security A1
join MGStrategy.dbo.MODEL6_UNIVERSE Univ1
on(Univ1.ENTRY_DATE='24-May-2010' and Univ1.BLOOMBERG_TICKER='C'+' US' and
A1.tic='C');
2)
select * from xf.dbo.security A