Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL Server 2005 Timestamp
Message
 
 
To
05/02/2007 15:41:17
Scott Sherman
Puyallup Tribal Health Authority
Tacoma, Washington, United States
General information
Forum:
Visual FoxPro
Category:
Client/server
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01192539
Message ID:
01192585
Views:
14
Yes, the timestamp data type is misnamed in MS SQL Server. The datetime data type is an equivalent to the SQL-92 timestamp data type. BTW, you could find all this info in the SQL Server Books Online.

>
>I found a description at http://www.informit.com/guides/content.asp?g=sqlserver&seqNum=54&rl=1 "timestamp - A database-wide unique number that gets updated every time a row gets updated". Pretty silly of me to assume a field called row_timestamp that is timestamp datatype would be similar to DB2 timestamps. It looks like someone could use it with a mirror table to find out which rows have been updated since the mirror table was refreshed. I used CAST(... AS INT) in my pass through SQL Query and at least pulled back something readable.
--sb--
Previous
Reply
Map
View

Click here to load this message in the networking platform