校对泡
校对泡
提问于 2021-12-22 21:28:49
尝试使用IN子句执行查询，但有以下错误：
Mensagem 468、Nível 16、Estado 9、Linha 7 N o foi possível解析器o conflito de agrupamento entre "SQL_Latin1_General_CP1_CI_AS“e "SQL_Latin1_General_CP850_CI_AS”na opera o等于。 我的翻译:不可能解决校对冲突。
两个数据库具有相同的排序规则，并且位于同一个sql server中。
以下是查询：
declare
@inventario int
set
@inventario='3'
insert into [MarmovidroAUX].[dbo].[Snap_Banco_Chapa]
select
@inventario,
a.ItemCode as CodItem,
a.SysNumber as SYSNR_Lote,
a.DistNumber as CodLote,
a.Status,
a.AbsEntry as ABS_Lote,
b.ItemName as NomeItem,
a.U_Comp_A as Comprimento,
a.U_Larg_A as Largura,
a.U_Comp_B as Comprimento_B,
a.U_Larg_B as Largura_B,
a.U_Num_Bloco as Codigo_Bloco_Fabricante,
d.Name as Nome_Bloco_Fabricante,
a.U_Tipo_Mapa_Chapas as Tipo_de_Mapa,
a.U_Tipo_Chapa_Mapa as Posição_Chapa_no_Mapa,
a.U_Num_Chapa_Bloco as ID_Chapa_Bloco_Fabricante,
a.U_Lote_Pai as Lote_Pai,
a.U_Local_Chapa,
a.U_Chapa_L as Chapa_L,
c.WhsCode as Cod_Deposito,
e.AbsEntry as ABS_Posição,
e.BinCode as Cod_posição_deposito,
c.OnHandQty as Qtd_na_Posição
from
SBOMarmovidro.dbo.OBTN a
left join SBOMarmovidro.dbo.OITM b on a.ItemCode=b.ItemCode
left join SBOMarmovidro.dbo.OBBQ c on a.AbsEntry=c.SnBMDAbs
left join SBOMarmovidro.[dbo].[@TAB_BLOCOS_CHAPAS] d on a.U_Num_Bloco=d.Code
left join SBOMarmovidro.dbo.OBIN e on c.BinAbs=e.AbsEntry
where
b.QryGroup1='Y'
and b.frozenFor='N'
--and c.WhsCode=06
and a.ItemCode in (select f.ItemCode from Tab_Filtros_Inventarios f where f.Inventario=@inventario)你能帮我解决这个问题吗？
回答 1
Stack Overflow用户
回答已采纳
发布于 2021-12-23 03:35:14
您可以找到表中涉及的列的排序规则名称，并查看排序规则是否不匹配。
例如，下面的查询提供了查询中涉及的表的列级排序规则信息。
SELECT name, collation_name
FROM sys.columns
WHERE OBJECT_ID IN (SELECT OBJECT_ID
FROM sys.objects
WHERE type = 'U'
AND name in ('OBTN','OITM','OBBQ','OBIN'))除非特别提到，否则表变量列将使用当前数据库的排序规则。
页面原文内容由Stack Overflow提供。腾讯云小微IT领域专用引擎提供翻译支持
原文链接：
https://stackoverflow.com/questions/70455302
复制相关文章
相似问题
腾讯云开发者
