Diesel Posted August 31, 2004 Posted August 31, 2004 How do I make a field AutoIncrementing in MS SQL Server 2000? Quote
Moderators Robby Posted August 31, 2004 Moderators Posted August 31, 2004 Through scripting? If so... [myColumn] [int] IDENTITY (1, 1) NOT NULL Quote Visit...Bassic Software
ost Posted September 5, 2004 Posted September 5, 2004 You can use the Design view in the Enterprise manager too. Identity: Yes Identity Seed: Where you want autoincrement to begin Identity Increment: How much you want the field to increment Quote
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.