关联两个库时要指定排序规序
如:
use db
go
select
*
from
t a
where exists(select 1 from db1.dbo.t where Name=a.Name collate Chinese_Taiwan_Strock_90_AX)
如:
use db
go
select
*
from
t a
where exists(select 1 from db1.dbo.t where Name=a.Name collate Chinese_Taiwan_Strock_90_AX)
如楼上风写的,
collate Chinese_Taiwan_Strock_90_AX
指定为当前库的排序规则
SELECT 1 FROM Inserted a INNER JOIN dba..Card_Card b ON a.Number=b.PersonnelID COLLATE database_default AND b.Status='0'