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 |
|
Prestidigitator
Starting Member
16 Posts |
 Posted - 2007-05-29 : 13:46:37
|
In other SQL programs I have seen the use of Limit to tell it how many rows to return.Is there an equivalent in MS-SQL that will let me do a quick Select clause and tell it how many rows to return.In other words if I just wanted to see the first 10 rows what would I add to Select * from tableA Thanks! |
|
|
jsmith8858
Dr. Cross Join
7423 Posts |
|
|
AndyB13
Aged Yak Warrior
583 Posts |
Posted - 2007-05-29 : 14:46:40
|
OrSET ROWCOUNT 10Select * from tableASET ROWCOUNT 0 --Reset back to ALLAndyBeauty is in the eyes of the beerholder  |
 |
|
|
|
|
|
How do you limit the number of results in Select?