Click here to Skip to main content
12,064,633 members (25,496 online)
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 22-Mar-13 1:04am
Comments
   
Why IDENTITY column does not work for you?
Rate this: bad
 
good
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[^]
  Permalink  
Comments
Prasad_Kulkarni 22-Mar-13 6:55am
   
Exactly, A 5!
wonder-FOOL 27-Mar-13 3:50am
   
THanks.
Rate this: bad
 
good
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..
  Permalink  
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)

  Print Answers RSS
Top Experts
Last 24hrsThis month


Advertise | Privacy | Mobile
Web01 | 2.8.160204.4 | Last Updated 23 Mar 2013
Copyright © CodeProject, 1999-2016
All Rights Reserved. Terms of Service
Layout: fixed | fluid

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