MSDN上找到的信息是说当前数据库的COLLATION: You cannot specify a collation for character variables and parameters; they are always created with the default collation of the database. http://msdn.microsoft.com/en-us/library/aa174903(v=sql.80).aspx
value int);
之后再设置一个表变量,declare @t3 table
(name varchar(20) ,
value int)
之后select * from #t1 A inner join @t3 C on A.name=c.name
会报错:Msg 468, Level 16, State 9, Line 6
Cannot resolve the collation conflict between "Chinese_PRC_CI_AS" and "Albanian_CI_AI_WS" in the equal to operation.