Cannot resolve the collation conflict between "SQL_Latin1_General_CP1_CI_AS" and "Chinese_PRC_CI
有时sql语句查询会包这个错误,加上下面红色部分就好了。
update t1 set Status=2
from t1 a inner join t2 b on (a.BoxID=b.Box_Id collate Chinese_PRC_CI_AS)
inner join t3 c on(b.Serial_No=c.Serial_No and b.MO=c.MO and c.Id=34)
update table1
set table1.name=’abc’
from table1
inner join table2
on table1.id = table2.id
where table2.number = '123'
delete from table1
from table1
inner join table2
on table1.id = table2.id
注意蓝色部分,这样就可以省掉复杂的中间表了^_^