<div>
You should be able to use the ROW_NUMBER function:<br />
<br />
<a href="http://msdn.microsoft.com/en-us/library/ms186734.aspx" rel="ugc nofollow">http://msdn.microsoft.com/en-us/library/ms186734.aspx</a><br />

</div>


You should be able to use the ROW_NUMBER function:

http://msdn.microsoft.com/en-us/library/ms186734.aspx [http://msdn.microsoft.com/en-us/library/ms186734.aspx]


<div>
row_number is not supported in sql server 2000
</div>


row_number is not supported in sql server 2000

<div>
perfect answer for two reason. i saw how we count rows in sql server 2000 and since we are qoing to upgrade to sql sever 2008 soon i learned how i can use the row_counter() function there.. thanks very much
</div>


perfect answer for two reason. i saw how we count rows in sql server 2000 and since we are qoing to upgrade to sql sever 2008 soon i learned how i can use the row_counter() function there.. thanks very much

<div>
<div class="content wysiwyg-content">
i am using sql server 2000. every time i am executing a select statement (f.e) select fielda, fieldb from table_a results come as follwing<br />
&nbsp;<br />
a1 a2<br />
b1 b2<br />
c1 c2<br />
d1 d2<br />
.. &nbsp;...<br />
<br />
how can i create a column which will contains a increment by 1 counter. the select in this case should return<br />
<br />
1 &nbsp;a1 a2<br />
2 &nbsp;b1 b2<br />
3 &nbsp;c1 c2<br />
4 &nbsp;d1 d2<br />
.......<br />
........<br />
.........<br />

</div>
</div>


i am using sql server 2000. every time i am executing a select statement (f.e) select fielda, fieldb from table_a results come as follwing
 
a1 a2
b1 b2
c1 c2
d1 d2
..  ...

how can i create a column which will contains a increment by 1 counter. the select in this case should return

1  a1 a2
2  b1 b2
3  c1 c2
4  d1 d2
.......
........
.........


sql select statement counting the results

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.