我正在尝试对2个表之间的数据进行比较，在这里我需要将多个列作为组合键来获得唯一的标识符。我正在使用CTE，我拥有的代码是：
WITH SuburbDataTest AS (
SELECT *
, CAST(Address AS NVARCHAR(100))+' ' +CAST(LivingAddress AS NVARCHAR(2))
+ ' ' + CAST(StartDate AS NVARCHAR(11))+ ' ' +CAST(AddressTypeId AS NVARCHAR(1))
+ ' ' +CAST(SuburbId AS NVARCHAR(1))AS SuburbDataTestColumn
FROM [mig].[ConsumerAddressMigration]
WHERE SuburbId is NOT NULL
)
SELECT *
FROM SuburbDataTest staging
WHERE SuburbDataTestColumn IN (
SELECT Address+' ' +CAST(LivingAddress AS NVARCHAR(2))+ ' '+CAST(StartDate AS NVARCHAR(11))
+ ' ' +CAST(AddressTypeId AS NVARCHAR(1))+ ' ' +CAST(SuburbId AS NVARCHAR(1)) AS SuburbDataTestColumn
FROM [dbo].[tblConsumerAddress]
)
不幸的是我越来越
将表达式转换为数据类型nvarchar的算术溢出错误。
有任何想法吗？
当您将数字转换为字符串时，会发生这种情况-并且字符串不够大。我猜这是问题所在：
CAST(SuburbId AS NVARCHAR(1))
如果SuburbId数字大于9，则将产生错误。或者，就此而言，如果值是负数，您也会收到相同的错误。
本文收集自互联网，转载请注明来源。
如有侵权，请联系[email protected] 删除。
我来说两句