Tuesday, September 7, 2010

How to get top 3 records without using TOP clause in sqlserver 2005?

set rowcount 3
SELECT * FROM dept
Execute the two statements in a single process. But it sets all the values are set to 3 in this process, if you want to change set rowcount 0

No comments:

Post a Comment