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.
| Author |
Topic |
|
mobasha
Starting Member
45 Posts |
 Posted - 2007-05-22 : 02:35:09
|
| i need to get the row number to use it in the where cluase,most off us has used Oracle rowid and sql2005 row_number()but in sql 2000 there is nothing like this >i have done it this way :create table id_test(mynewid uniqueidentifier not null default newid(),......,coln)goselect mynewid from id_test-----------------------------------------------------------do u have a seconed OpinionMobashA |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2007-05-22 : 02:37:32
|
| Why uniqueidentifier? Why not simple Identity column?Harsh AthalyeIndia."The IMPOSSIBLE is often UNTRIED" |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2007-05-22 : 02:43:43
|
| Also, why is row number important to you?If you want to present them in front end application, you can easily do numbering thereor Give us more informations on what you are trying to do with rowidMadhivananFailing to plan is Planning to fail |
|
|
|
mobasha
Starting Member
45 Posts |
Posted - 2007-05-23 : 02:23:48
|
| the rowid represnt the recored number in the database so i can used it to update and delete the recored using this field only,i cant use Identity column cos i wont the column to be unique not just on the data base level.and i want to ues it internaly.MobashA |
|
|
|
|
|
|
row id