Prev: Missing information_schema.tables
Next: Basic advice required
From: redbull on 25 Jun 2010 10:21
Hi guys, im playing with sql server managemnent studio.
I cannot find rowversion type, but if I'm not wrong, yesterday it was in the
list :S
Is it possible?
How can I resume this type? Thanks


From: Erland Sommarskog on 25 Jun 2010 10:54
redbull (redbull(a)libero.it) writes:
> Hi guys, im playing with sql server managemnent studio.
> I cannot find rowversion type, but if I'm not wrong, yesterday it was in
> the list :S
> Is it possible?
> How can I resume this type? Thanks

I don't know why you would need it to appear in a list. If you need
to use the type, just use it. (But don't use the Table Designer if
that is what you are doing, but learn the syntax for CREATE TABLE.)

Else you could use timestamp which is a different name for the same
type. Microsoft has deprecated this name, but they have not even themselves
obeyed the deprecation.




--
Erland Sommarskog, SQL Server MVP, esquel(a)sommarskog.se

Links for SQL Server Books Online:
SQL 2008: http://msdn.microsoft.com/en-us/sqlserver/cc514207.aspx
SQL 2005: http://msdn.microsoft.com/en-us/sqlserver/bb895970.aspx
SQL 2000: http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

 | 
Pages: 1
Prev: Missing information_schema.tables
Next: Basic advice required