error NewID()='x' to NewID()='x' to get rows

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.

All Forums

SQL Server 2000 Forums

Transact-SQL (2000)

error NewID()='x' to NewID()='x' to get rows

Author

Topic

u2p_inst
Yak Posting Veteran

78 Posts

Posted - 2002-07-10 : 21:54:33

Dear all
can you tell me how can i show limited rows, because ID in the mytable can be deleted so i can't use between and i has missing ID

oh

robvolk
Most Valuable Yak

15732 Posts

Posted - 2002-07-10 : 22:20:54

Take a look at this article:

http://www.sqlteam.com/item.asp?ItemID=566

Also search for "row number" in the SQL Team forums. You can do a forum search using this link.

These may also be of help:

http://www.sqlteam.com/redir.asp?ItemID=2753
http://www.sqlteam.com/redir.asp?ItemID=3078

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources