Drop Table
Support Forum for database administrators and web based access to important newsgroups related to databases
Where is rowversion data typeBooks on SQL Server 2000 tell me to use the 'rowversion' datatype instead of the 'timestamp' datatype. 'Rowversion' is not available in the table designer and it tells me I must pick from the list if I enter 'rowversion' in by hand. Can someone shed some light on this for me.
Post Follow-up to this message
Re: Where is rowversion data typeHi It is confusing lots of people here. Actually ,timestamp is a 'rowversion' which is binary datatype and has nothing to do with date and times. <dbuchanan52@hotmail.com> wrote in message news:1112239406.825378.257850@l41g2000cwc.googlegroups.com... > Books on SQL Server 2000 tell me to use the 'rowversion' datatype > instead of the 'timestamp' datatype. 'Rowversion' is not available in > the table designer and it tells me I must pick from the list if I enter > 'rowversion' in by hand. Can someone shed some light on this for me. >
Post Follow-up to this message Re: Where is rowversion data typeAnother reason not to use the table designer then. There's no problem specifying the ROWVERSION type using TSQL in Query Analyzer. -- David Portas SQL Server MVP --
Post Follow-up to this message
Sponsored Links
Show a Printable Version
Email This Page to Someone!
Receive updates to this thread
