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.

 All Forums
 SQL Server 2000 Forums
 SQL Server Development (2000)
 DataType

Author  Topic 

sqlfresher2k7
Aged Yak Warrior

623 Posts

Posted - 2009-02-02 : 14:45:04
Can i create long data type for ID column in the sqlserver 2000.

webfred
Master Smack Fu Yak Hacker

8781 Posts

Posted - 2009-02-02 : 15:22:48
Do you mean NUMERIC long datatype or just something like text, image and so on?


No, you're never too old to Yak'n'Roll if you're too young to die.
Go to Top of Page

AvanthaSiriwardana
Yak Posting Veteran

78 Posts

Posted - 2009-02-02 : 22:52:38
yes u can use varchar, text, nchar etc

Avantha Siriwardana
Beware of bugs in the above code; I have only proved it correct, not tried it.
(Donald Knuth)
Go to Top of Page

Lumbago
Norsk Yak Master

3271 Posts

Posted - 2009-02-03 : 04:00:11
The IDENTITY property is valid for INT and BIGINT only.

- Lumbago
Go to Top of Page
   

- Advertisement -