moving up to SQL from A2k -- sql server new users

JohnE
3/27/2005 8:03:01 PM

I am a NEWBIE at this as I am stepping up from A2k. In A2k the autonumber
used as the primary key allows formatting in which text can be used. Does MS
SQL Server 2000 allow it as well? If so how does one go about it? Several
A2k databases are also being considered for upsizing and they have the text
in the autonumber thru the formatting.
Thanks to anyone responding.
*** John

Tom Moreau
3/28/2005 6:04:06 AM

Check out IDENTITY in the BOL.

--
Tom

----------------------------------------------------
Thomas A. Moreau, BSc, PhD, MCSE, MCDBA
SQL Server MVP
Columnist, SQL Server Professional
Toronto, ON Canada
www.pinnaclepublishing.com
..
[quoted text, click to view]
I am a NEWBIE at this as I am stepping up from A2k. In A2k the autonumber
used as the primary key allows formatting in which text can be used. Does
MS
SQL Server 2000 allow it as well? If so how does one go about it? Several
A2k databases are also being considered for upsizing and they have the text
in the autonumber thru the formatting.
Thanks to anyone responding.
*** John

sql server new users : moving up to SQL from A2k