Limit recordset results in M$ SQL Server 2000

Quaky · 02-19-02, 03:45 PM

I was wondering how I can limit my results of my SQL statement in SQL Server 2k. I know MySQL has a standard statement for it but it doesn't work in SQL2k. I can't change DB servers so SQL 2K has to do it.

Can someone point this out to me plz?

Krieger · 02-21-02, 10:54 AM

I believe it's "SELECT TOP number FROM recordset WHERE cause". I'll look through some of my books and double check to make sure.

02-19-02, 03:45 PM	Thread Starter #1
Quaky Member Join Date: Jul 2001	Limit recordset results in M$ SQL Server 2000 I was wondering how I can limit my results of my SQL statement in SQL Server 2k. I know MySQL has a standard statement for it but it doesn't work in SQL2k. I can't change DB servers so SQL 2K has to do it. Can someone point this out to me plz?
	QUOTE Thanks

02-21-02, 10:54 AM	#2
Krieger Member Join Date: Jan 2002 Location: North of Boston, MA	I believe it's "SELECT TOP number FROM recordset WHERE cause". I'll look through some of my books and double check to make sure.
	QUOTE Thanks

Thread Tools	Search this Thread
Show Printable Version Email this Page	Search this Thread: Advanced Search

Limit recordset results in M$ SQL Server 2000

Internet Services

Website Development

Tech Hardware