<div>
sql server 2000 doesn't support rowID.<br />

</div>


<div>
Have a look here for the identity column implementation:<br />
<a href="http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=3385" rel="ugc">http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=3385</a><br />
<br />

</div>


Have a look here for the identity column implementation:
http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=3385 [http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=3385]



<div>
I agree that the identity method is usually the easiest way. &nbsp;If you don't already have an identity column on your table, you can always insert into &nbsp;a temp table and return the results. &nbsp;If you do already have an identity column on your table and you can't have a gap between the numbers, you could also create a UDF that joins back to your original table and sequence the records that way.<br />
<br />
Brett
</div>


I agree that the identity method is usually the easiest way.  If you don't already have an identity column on your table, you can always insert into  a temp table and return the results.  If you do already have an identity column on your table and you can't have a gap between the numbers, you could also create a UDF that joins back to your original table and sequence the records that way.

Brett

<div>
<div class="content wysiwyg-content">
How can i get the &quot;RowId&quot; of a table in Sql Server?
</div>
</div>


How can i get the "RowId" of a table in Sql Server?

RowId In SQL Server

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.