• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1864
  • Last Modified:

ROWID pseudo column for SQL Server?

Is there any kind of ROWID (as is the case with Oracle) pseduo column that can be used for SQL Server?
0
jbaird123
Asked:
jbaird123
  • 2
  • 2
  • 2
  • +2
1 Solution
 
sventhanCommented:
Not that I know of. But you could generate rowids using a row_number() function.
0
 
sventhanCommented:
0
Get quick recovery of individual SharePoint items

Free tool – Veeam Explorer for Microsoft SharePoint, enables fast, easy restores of SharePoint sites, documents, libraries and lists — all with no agents to manage and no additional licenses to buy.

 
jbaird123Author Commented:
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?
0
 
SharathData EngineerCommented:
There is nothing like that. You need to generate the ROWID using ROW_NUMBER and use it as stated by sventhan
0
 
8080_DiverCommented:
Also,  since you didn't specify a version, ROW_NUMBER is not available in SQL Server 2000.
0
 
SharathData EngineerCommented:
>> 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.
0
 
8080_DiverCommented:
Sorry, cross-wired the question I was looking at.  :-/
0
 
jbaird123Author Commented:
Thank you.
0

Featured Post

Visualize your virtual and backup environments

Create well-organized and polished visualizations of your virtual and backup environments when planning VMware vSphere, Microsoft Hyper-V or Veeam deployments. It helps you to gain better visibility and valuable business insights.

  • 2
  • 2
  • 2
  • +2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now