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 |
|
ag_ss
Starting Member
48 Posts |
 Posted - 2006-03-31 : 06:32:13
|
| do we have any equivalent of rownum and rowid in MS SQL |
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2006-03-31 : 06:44:23
|
sql2000 no.sql2005 yes with OVER clause.Go with the flow & have fun! Else fight the flow  Blog thingie: [URL="http://weblogs.sqlteam.com/mladenp"] |
 |
|
|
ag_ss
Starting Member
48 Posts |
Posted - 2006-03-31 : 06:56:13
|
| can you give me any example |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2006-03-31 : 07:01:35
|
| http://www.sqljunkies.com/Article/4E65FA2D-F1FE-4C29-BF4F-543AB384AFBB.scukGo with the flow & have fun! Else fight the flow Blog thingie: [URL="http://weblogs.sqlteam.com/mladenp"] |
|
|
|
ag_ss
Starting Member
48 Posts |
Posted - 2006-03-31 : 07:35:06
|
| i need to use SQL2003 so it wont help |
|
|
|
spirit1
Cybernetic Yak Master
11752 Posts |
Posted - 2006-03-31 : 07:48:19
|
| sql 2003??you mean sql 2000?Go with the flow & have fun! Else fight the flow Blog thingie: [URL="http://weblogs.sqlteam.com/mladenp"] |
|
|
|
ag_ss
Starting Member
48 Posts |
Posted - 2006-03-31 : 07:58:47
|
| Database Microsoft SQLServer 2003 |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-03-31 : 08:09:36
|
| >>Database Microsoft SQLServer 2003??select @@versionand see what it returnsAlso,Select data from tableNumber them in your Front End applicationMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
rownum and rowid equivalent in MS SQL