May 22, 2010 at 11:54 am
Hi all,
I've studied plenty of posts and articles regarding the deprecated TIMESTAMP and the synonym, ROWVERSION. As much as I've read, much of it from authoritative sources, I've found nothing which clearly states what one ought to do, other than to use the word "ROWVERSION" in all T-SQL where one might previously have used the word "TIMESTAMP".
In SQL Server 2005:
I note that type ROWVERSION is not available in the Data Type combobox. However, TIMESTAMP is.
Out of curiosity I created a table by script, including in it a column of type ROWVERSION. Opening the newly created table in design view, I note that the ROWVERSION column I scripted is displayed as type TIMESTAMP. If I script this new table as CREATE, I note that the script would create this same column as type TIMESTAMP.
That leaves me a bit confused.
1. When I script a column of type ROWVERSION, what type is the column actually stored as?
2. When I generate a CREATE script should I edit it, replacing the word TIMESTAMP with the word ROWVERSION?
3. Does it even matter whether I create concurrency columns as type TIMESTAMP or ROWVERSION, as long as I used the new synonym in queries, etc?
Even Bill Vaughn, in "Hitchhiker's Guide to Visual Studio and SQL Server", never goes beyond stating that "Microsoft wants us to use the new synonym", after which he proceeds to create tables with TIMESTAMP columns. I really don't understand why things which are, most likely, so simple to state - aren't stated simply by authoritative sources. It'd sure save a lot of time lost reading and posting.
May 24, 2010 at 6:14 am
see this link http://msdn.microsoft.com/en-us/library/ms182776(SQL.90).aspx
Some lines fron above link
rowversion is the synonym for the timestamp data type and is subject to the behavior of data type synonyms. In DDL statements, use rowversion instead of timestamp wherever possible.
-------Bhuvnesh----------
I work only to learn Sql Server...though my company pays me for getting their stuff done;-)
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply