Very Computer

by **Mike** » Tue, 13 Oct 1998 04:00:00

How do you return the first 500 records from a select query?

I am using SQL Server 6.5.

Thank you.

by **Don Harri** » Tue, 13 Oct 1998 04:00:00

Issue a "SET ROWCOUNT 500" command on the connection.

Don

>How do you return the first 500 records from a select query?

>I am using SQL Server 6.5.

>Thank you.

by **Paul S. Vorontso** » Wed, 14 Oct 1998 04:00:00

SET ROWCOUNT 500
SELECT ...
SET ROWCOUNT 0
Mike D??? ???Y?? ...

Quote:>How do you return the first 500 records from a select query?

>I am using SQL Server 6.5.

>Thank you.

Returning first 500 records