<div>
Not that I know of. But you could generate rowids using a row_number() function.
</div>


Not that I know of. But you could generate rowids using a row_number() function.

<div>
here is a sample<br />
<br />
<a href="http://support.microsoft.com/default.aspx?scid=kb;EN-US;q186133" rel="ugc">http://support.microsoft.com/default.aspx?scid=kb;EN-US;q186133</a>
</div>


here is a sample

http://support.microsoft.com/default.aspx?scid=kb;EN-US;q186133 [http://support.microsoft.com/default.aspx?scid=kb;EN-US;q186133]

<div>
<a href="http://vyaskn.tripod.com/programming_faq.htm#q17" rel="ugc">http://vyaskn.tripod.com/p<wbr />rogramming<wbr />_faq.htm#q<wbr />17</a>
</div>


http://vyaskn.tripod.com/programming_faq.htm#q17 [http://vyaskn.tripod.com/programming_faq.htm#q17]

<div>
sventhan:<br />
<br />
It looks like your example shows how to generate a sequence - similar to the Oracle ROWNUM feature. &nbsp;I'm looking for something similar to the ROWID feature that can be used in the where clause of a SQL query like this:<br />
&nbsp;<br />
update tablename<br />
set fieldname='asdfadsfasdf'<br />
where rowid = &lt;&lt;some value&gt;&gt;<br />
<br />
Is there anything like that at all?
</div>


sventhan:

It looks like your example shows how to generate a sequence - similar to the Oracle ROWNUM feature.  I'm looking for something similar to the ROWID feature that can be used in the where clause of a SQL query like this:
 
update tablename
set fieldname='asdfadsfasdf'
where rowid = <<some value>>

Is there anything like that at all?

<div>
Also, &nbsp;since you didn't specify a version, <b>ROW_NUMBER</b> is not available in SQL Server 2000. 
</div>


Also,  since you didn't specify a version, ROW_NUMBER is not available in SQL Server 2000.

<div>
&gt;&gt; Also, &nbsp;since you didn't specify a version, ROW_NUMBER is not available in SQL Server 2000.<br />
<br />
8080_Diver - &nbsp;The question is in SQL Server 2008 zone.
</div>


>> Also,  since you didn't specify a version, ROW_NUMBER is not available in SQL Server 2000.

8080_Diver -  The question is in SQL Server 2008 zone.

<div>
Sorry, cross-wired the question I was looking at. &nbsp;:-/
</div>


Sorry, cross-wired the question I was looking at.  :-/

<div>
<div class="content wysiwyg-content">
Is there any kind of ROWID (as is the case with Oracle) pseduo column that can be used for SQL Server? 
</div>
</div>


Is there any kind of ROWID (as is the case with Oracle) pseduo column that can be used for SQL Server? 

ROWID pseudo column for SQL Server?

Microsoft SQL Server 2008 is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning. Major improvements include the  Always On technologies and support for unstructured data types.