select D.departmentid,D.departmentname,E.DepNo,E.DepName from dbo.departmenta as D inner join
srv_lnk.testhr.dbo.employee_dep as E on D.departmentid=E.DepNo
由于主键关联,报了:无法解决 equal to 操作中 "Chinese_Taiwan_Stroke_CI_AS" 和 "Chinese_PRC_CI_AS" 之间的排序规则冲突
解决方法:
select D.departmentid,D.departmentname,E.DepNo,E.DepName from dbo.departmenta as D inner join
srv_lnk.testhr.dbo.employee_dep as E on D.departmentid=E.DepNo COLLATE Chinese_Taiwan_Stroke_CI_AS