Click here to Skip to main content
14,665,327 members
Rate this:
Please Sign up or sign in to vote.
Hello CPers,

I would like to know is it possible to make a column auto-increment without changing it to IDENTITY in SQL Server 2000. As far as I know it is not supported in SQL2000 but is there someone who might implemented this?

For those who might suggest me to use
MAX(column_name) + 1
for that situation it is not possible.

Thanks in advance.
Posted
Comments
José Amílcar Casimiro 22-Mar-13 6:30am
   
Why IDENTITY column does not work for you?

Rate this:
Please Sign up or sign in to vote.

Solution 1

IDENTITY is supported in SQL Server 2000. Please check below link
http://msdn.microsoft.com/en-us/library/aa933196(v=sql.80).aspx[^]
   
Comments
Prasad_Kulkarni 22-Mar-13 6:55am
   
Exactly, A 5!
wonder-FOOL 27-Mar-13 3:50am
   
THanks.
Rate this:
Please Sign up or sign in to vote.

Solution 2

Hey,
You can use COUNT function.
select count(*) from your_table

Get the count of the record in the table and add 1 to it.
But, this will work fine only if you are not deleting the records physically from the table otherwise it will work in any condition.

Hope this helps you.

Regards,
Lok..
   
Comments
wonder-FOOL 27-Mar-13 3:51am
   
Thanks.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)




CodeProject, 503-250 Ferrand Drive Toronto Ontario, M3C 3G8 Canada +1 416-849-8900 x 100