SQL Server Performance Forum – Threads Archive

RowId

On SqlServer, has something like the Rowid(The record’s number) from Oracle ??

---

You asked this question last week and a response was made. Please follow-up your previous thread and tell us if the suggestions were not helpful. Your previous post is at:
http://www.sql-server-performance.com/forum/topic.asp?TOPIC_ID=822] NHO

---

Oracle ROWID is a hash of the physical address of the data. SQL does not have an equivalent type, however, if you merely want a column to be guaranteed unique, either use an INT IDENTITY (autoincrement), or in rare cases a GUID is more suitable.

---

]]>