Sql 语句
select s.* from dbo.ServerInfo as s
inner join dbo.Branch as b on s.ServerIP=b.BranchAddress
错误提示:
消息 468,级别 16,状态 9,第 1 行
无法解决 equal to 操作中 "Chinese_PRC_CI_AS" 和 "Chinese_PRC_CI_AI" 之间的排序规则冲突。
解决方法:
select s.* from dbo.ServerInfo as s
inner join dbo.Branch as b on s.ServerIP=b.BranchAddress collate Chinese_PRC_CI_AI