InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comWed, 22 May 2013 11:36:00 GMT20http://www.sqlservercentral.com/Forums/Topic548943-1042-1.aspxIf you are using SQL Server 2005 or 2008 you can take advantage of the Row_number function. If you are in 2000, you can use an identity columnMon, 18 Aug 2008 08:06:45 GMTErich Brinkerhttp://www.sqlservercentral.com/Forums/Topic548943-1042-1.aspxROWIDs represent the physical location of a record/row. And most important part is ROWID can change if the row is moved as in index organized or partitioned tables.Mon, 11 Aug 2008 22:21:26 GMTupalsenhttp://www.sqlservercentral.com/Forums/Topic548943-1042-1.aspx[quote]... like Oracle's inbuilt primary key ROWID [/quote]Oracle's ROWID is not a PK. ROWID is a unique row identifier, nothing else, nothing more.Fri, 08 Aug 2008 09:41:11 GMTPaulB-TheOneAndOnlyhttp://www.sqlservercentral.com/Forums/Topic548943-1042-1.aspx[quote][b]ajaymistry_07 (8/8/2008)[/b][hr]Hi, Is anybody know that do we have anything like Oracle's inbuilt primary key ROWID which is also accessible to database developer.I searched for it but could not get the satisfactory answer.Thanks,:)[/quote]There isn't one that you can access from T-SQL. You should set up a PK yourself. If you run into a situation where there isn't one on a table, you may still be able to access individual items on SQL Server 2005 and 2008 (just search the forums for removing duplicate rows)Regards, AndrasFri, 08 Aug 2008 02:57:23 GMTAndras Belokosztolszkihttp://www.sqlservercentral.com/Forums/Topic548943-1042-1.aspxHi, Is anybody know that do we have anything like Oracle's inbuilt primary key ROWID which is also accessible to database developer.I searched for it but could not get the satisfactory answer.Thanks,:)Fri, 08 Aug 2008 02:50:37 GMTAJ07