Auto increment Number in SQL Server 2000?
Hello,
I have one query and it's out put is like this.
My database in SQL Server -2000 .
Select Name from table_name
Out Put
========
Name
======
Test1
Test2
Test3
Test4
But I want this types of out put.
Out Put
========
ID Name
=========
1 Test1
2 Test2
3 Test3
4 Test4