开发者

What is the SQL Server timestamp equivalent in sqlce?

开发者 https://www.devze.com 2022-12-18 13:50 出处:网络
I have some data with a timestamp in SQL Server, I would like to store that value in sqlce with out getting fancy to compare the two values.

I have some data with a timestamp in SQL Server, I would like to store that value in sqlce with out getting fancy to compare the two values.

What is t开发者_JAVA百科he SQL Server timestamp equivalent in sqlce?


Timestamp is from MS Docs

timestamp is a data type that exposes automatically generated binary numbers, which are guaranteed to be unique within a database. timestamp is used typically as a mechanism for version-stamping table rows. The storage size is 8 bytes.

This value makes no sense outside the database it was created in. Thus I don't see how it can be converted.

In a non Sybase/ SQL Server database I would use a version number or last updated column


AS of Sql Compact 3.5, there is support for timestamps, per MSDN:

SQL Server Compact implements the timestamp (rowversion) data type. The rowversion is a data type that exposes automatically generated binary numbers, which are guaranteed to be unique in a database. It is used typically as a mechanism for version-stamping table rows.


Ok the timestamp is a varbinary that auto generates. So to copy a time stamp you need a varbinary field.

0

精彩评论

暂无评论...
验证码 换一张
取 消