好得很程序员自学网

<tfoot draggable='sEl'></tfoot>

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

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这条记录在数据库是存在的。急啊。 求解。

查看更多关于SQLSERVER2008根据timestamp类型更新,返回影响行为0的问题的详细内容...

  阅读:41次