Auto_Increment Column in SQL Server 2000

Question

0.00/5 (No votes)

See more:

SQL-server-2000

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

SQL

MAX(column_name) + 1

for that situation it is not possible.

Thanks in advance.

Posted 22-Mar-13 0:04am

wonder-FOOL

Add a Solution

Comments

José Amílcar Casimiro 22-Mar-13 6:30am

Why IDENTITY column does not work for you?

2 solutions

Add a Solution

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

snehal harawande · Accepted Answer · 2013-03-22T00:09:00

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[^]

Posted 22-Mar-13 0:09am

snehal harawande

Comments

Prasad_Kulkarni 22-Mar-13 6:55am

Exactly, A 5!

wonder-FOOL 27-Mar-13 3:50am

THanks.

Lokesh Zende · Accepted Answer · 2013-03-23T00:34:00

Solution 2

Hey,
You can use COUNT function.

SQL

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..

Posted 23-Mar-13 0:34am

Lokesh Zende

Comments

wonder-FOOL 27-Mar-13 3:51am

Thanks.

Auto_Increment Column in SQL Server 2000

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Auto_Increment Column in SQL Server 2000

2 solutions

Solution 1

Solution 2

Add your solution here

Preview 0

Existing Members

...or Join us