RE: FN-FORUM: Autonumber in sql server

date posted 21st January 2007 15:44

I'ts;

Create table (ColumnIwantToAutoIncrement int identity(startingvalue,
incrementvalue)

E.g.,

Create table (uid int identity(50, 5)=20

will count up in 5's starting at 50.

HTH cheers
Andy

-----Original Message-----
From: [EMAIL REMOVED] [EMAIL REMOVED] On Behalf Of Ata
Karim
Sent: 21 January 2007 16:08
To: Andy Macnaughton-Jones
Subject: RE: FN-FORUM: Autonumber in sql server



If you have SQL Server Management Studio Express, in there when you set
an Identity column and there is an option to specify a seed and an
increment underneath. Apologies for a vague answer!!!

----Original Message Follows----

I'm using SQL Server Express Edition and was wondering if anyone here
knew how to create an autonumber start at a set number as opposed to the
default 0, for example start counting from 1000 instead of 0?

This is probably quite easy to do but i havent used SQL Server much
before!

Thanks

James

--
Freelancers, contractors earn more with Prosperity4 Call 0870 870 4414
or visit www.prosperity4.com and benefit from Inland Revenue approved
expenses today.

To advertise here: http://www.freelancers.net/advertising.html


--
Freelancers, contractors earn more with Prosperity4 Call 0870 870 4414
or visit www.prosperity4.com and benefit from Inland Revenue approved
expenses today.

To advertise here: http://www.freelancers.net/advertising.html