Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 Row Identifier

Author  Topic 

gercr
Yak Posting Veteran

53 Posts

Posted - 2004-01-16 : 19:01:28
hi all, someone can tell me if on SQL server is an equivalent for the ROWID of Oracle?

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2004-01-16 : 19:05:11
http://dbforums.com/arch/7/2002/8/448496

Tara
Go to Top of Page

eyechart
Master Smack Fu Yak Hacker

3575 Posts

Posted - 2004-01-16 : 22:25:25
there is no equivalent to rownum either.


-ec
Go to Top of Page

AjarnMark
SQL Slashing Gunting Master

3246 Posts

Posted - 2004-01-18 : 18:39:19
Well, if no one else is going to ask, I will.... Why do you need the ROWID? Typically when i see people using that in Oracle they are usually either trying to handle duplicates or paging/TOP functionality. If that's the case, then you will want to read some of our articles on these subjects.

http://www.sqlteam.com/searchresults.asp?SearchTerms=top
http://www.sqlteam.com/item.asp?ItemID=3331

--------------------------------------------------------------
Find more words of wisdom at [url]http://weblogs.sqlteam.com/markc[/url]
Go to Top of Page
   

- Advertisement -