"Thai_CI_AS“和"SQL_Latin1_General_CP1_CI_AS”之间的SQL查询冲突

Question

嗨，我能知道这个查询是怎么回事吗？

SELECT [no]
--  into #mytemp
  FROM [pcb_comp]
  where no in (SELECT [no] FROM [Data_Query].[dbo].[query]
  where [no] NOT IN (select no from [IPTS2].[dbo].[abc]))
  and location = 'PCB'
  order by no 

Answer 1

如果在排序规则中出现问题，请使用以下位置列：

SELECT [no]
--  into #mytemp
  FROM [pcb_comp]
  where no in (SELECT [no] FROM [Data_Query].[dbo].[query]
  where [no] NOT IN (select no from [IPTS2].[dbo].[abc]))
  and location COLLATE DATABASE_DEFAULT = 'PCB' COLLATE DATABASE_DEFAULT
  order by no

同样适用于您的'in‘过滤器，如果上面没有工作。