当前位置:Gxlcms > mysql > SQLSERVER2008根据timestamp类型更新,返回影响行为0的问题

SQLSERVER2008根据timestamp类型更新,返回影响行为0的问题

时间:2021-07-01 10:21:17 帮助过:44人阅读

eg: 1、UPDATE [hz2].[dbo].[book] SET [NAME]='TEST' where [version] = CAST('0x0000000000000FA2' as binary(8)) 2、UPDATE [hz2].[dbo].[book] SET [NAME]='TEST' where [version] = CAST('0x0000000000000FA2' as timestamp) ps: 0x0000000000000FA2这

eg:

1、UPDATE [hz2].[dbo].[book] SET [NAME]='TEST' where [version] = CAST('0x0000000000000FA2' as binary(8))
2、UPDATE [hz2].[dbo].[book] SET [NAME]='TEST' where [version] = CAST('0x0000000000000FA2' as timestamp)

ps: 0x0000000000000FA2这条记录在数据库是存在的。急啊。 求解。

人气教程排行