|
database
newsgroups
|
|||||||||||||||||||||||
|
|||||||||||||||||||||||
How to utilize the rowId in sql serverI know that each record in a table has an id internally. Can
someoneshow me how to utilize it? thanks ken Hi,
Take a look into this article:- http://www.databasejournal.com/features/mssql/article.php/3572301 Thanks Hari SQL Server MVP Show quote "SQL Ken" <SQL***@gmail.com> wrote in message news:1158280390.114497.49610@p79g2000cwp.googlegroups.com... >I know that each record in a table has an id internally. Can > someoneshow me how to utilize it? > > thanks > > ken > What version of SQL Server are you using?
What are you actually trying to accomplish (aside from "utilize the row id")? Show quote "SQL Ken" <SQL***@gmail.com> wrote in message news:1158280390.114497.49610@p79g2000cwp.googlegroups.com... >I know that each record in a table has an id internally. Can > someoneshow me how to utilize it? > > thanks > > ken > Aaron,
you can do alot with it: see the last record number; do a loop, etc. It helps with coding process. Hari, Thank you for pointing out the article. ken SQL Ken wrote:
> you can do alot with it: Spoken like a true non-SQL programmer!> see the last record number; > do a loop, etc. It helps with coding process. "Chris Lim" <blackca***@hotmail.com> wrote in message Do you have the stones to post this in an Oracle ng? ~:Pnews:1158303565.576773.47960@i3g2000cwc.googlegroups.com... > SQL Ken wrote: > > you can do alot with it: > > see the last record number; > > do a loop, etc. It helps with coding process. > > Spoken like a true non-SQL programmer! the very best, http://racster.blogspot.com > you can do alot with it: Okay, but I was asking, what are you trying to accomplish specifically?> see the last record number; > do a loop, etc. It helps with coding process. The concept of RowID doesn't exist in SQL Server. This is why we ask what it is you try to achieve.
-- Show quoteTibor Karaszi, SQL Server MVP http://www.karaszi.com/sqlserver/default.asp http://www.solidqualitylearning.com/ "SQL Ken" <SQL***@gmail.com> wrote in message news:1158303158.269992.282460@i42g2000cwa.googlegroups.com... > Aaron, > you can do alot with it: > see the last record number; > do a loop, etc. It helps with coding process. > > > > Hari, > Thank you for pointing out the article. > > > > ken >  
Other interesting topics
|
|||||||||||||||||||||||
