如何修复组合的错误不兼容数据类型 [SQL 状态 = 42562，数据库错误代码 =-5562]

Question

我重写代码..并得到此错误：

组合的不兼容数据类型 [SQL 状态 = 42562，数据库错误代码 =-5562]

MERGE INTO tj USING (VALUES (?) )
AS vals (created_date) 
ON vals.created_date  = tj.created_date
WHEN MATCHED THEN UPDATE SET tj.created_date= vals.created_date
WHEN NOT MATCHED THEN INSERT VALUES  vals.created_date

如何修复该代码？

Answer 1

您需要将参数强制转换为 tj 的created_date列的类型。类型可以是日期或时间戳。

MERGE INTO tj USING (VALUES (CAST(? AS DATE)) )
AS vals (created_date) 
ON vals.created_date  = tj.created_date
WHEN MATCHED THEN UPDATE SET tj.created_date= vals.created_date
WHEN NOT MATCHED THEN INSERT VALUES  vals.created_date