Jitendra Patel

Jitendra Patel

  • NA
  • 149
  • 0

Auto increment Number in SQL Server 2000?

Sep 3 2011 1:17 PM

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


Answers (6)