Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2002-05-22 : 10:33:03
|
| srivatchsan writes "Hi Guys Please help me out in implememting RowVersion Datatype in SQL2000 since i need to check certain rows in a table frequently based on the updations . Help me !!Thanks in Advance" |
|
|
MichaelP
Jedi Yak
2489 Posts |
Posted - 2002-05-22 : 10:38:52
|
| Are you trying to keep a historical record of changes to any row, and need to be able to roll back to any point in time for that roq?Michael |
 |
|
|
AjarnMark
SQL Slashing Gunting Master
3246 Posts |
Posted - 2002-05-22 : 19:20:40
|
What are you trying to accomplish? Have you read BOL yet on this topic? You assign RowVersion as the datatype when you create the table, and the SQL will update it automatically upon Inserts and Updates.For those who haven't read BOL, RowVersion is a synonym for timestamp in SQL 2000 because timestamp may be altered in a future version to be a datetime. Here's the reference in BOL 2000:quote:
The Transact-SQL timestamp data type is not the same as the timestamp data type defined in the SQL-92 standard. The SQL-92 timestamp data type is equivalent to the Transact-SQL datetime data type. A future release of Microsoft® SQL Server™ may modify the behavior of the Transact-SQL timestamp data type to align it with the behavior defined in the standard. At that time, the current timestamp data type will be replaced with a rowversion data type.Microsoft® SQL Server™ 2000 introduces a rowversion synonym for the timestamp data type. Use rowversion instead of timestamp wherever possible in DDL statements. rowversion is subject to the behaviors of data type synonyms. For more information, see Data Type Synonyms.
Edited by - AjarnMark on 05/22/2002 19:21:32 |
|
|
|
|
|
|
RowVersion in SQL 2000