| Author |
Where is rowversion data type
|
|
| dbuchanan52@hotmail.com 2005-03-31, 7:01 am |
| 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.
| |
| Uri Dimant 2005-03-31, 7:01 am |
| Hi
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.
>
| |
| David Portas 2005-03-31, 7:01 am |
| Another 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
--
|
|
|
|