RE: FN-FORUM: SQL Server Query Problem

date posted 15th January 2004 16:58

Or you can use one of the SET commands to specify how many records get
returned - it's subtly different to using TOP because it does it after
all of the query has been run.=20


Andy
IWD2 LLP
[EMAIL REMOVED]
=20
-----Original Message-----
From: Andy Macnaughton-Jones=20
Sent: 15 January 2004 17:35
To: Andy Macnaughton-Jones
Subject: RE: FN-FORUM: SQL Server Query Problem


You can do SELECT TOP 100 field1, field2 to return the top 100

You can use the paged recordset to set the size of the pages and allow
you to specify the page that you want to view.=20


Andy
IWD2 LLP
[EMAIL REMOVED]
=20
-----Original Message-----
From: John Kyle [EMAIL REMOVED]
Sent: 15 January 2004 17:07
To: Andy Macnaughton-Jones
Subject: Re: FN-FORUM: SQL Server Query Problem


Hello

Is there a tSQL command like the LIMIT syntax found in MySQL for
returning only part of a recordset? In ASP.NET/c# I have a result set of
about 1250 and would like to return a number at a time, has anybody got
an elegant solution for this issue?

Best Regards

John Kyle



--
** Get all the Freelance Work you Can Handle * The Web Design Business
Kit will show you proven tactics and strategies for marketing your
business, winning bids, managing projects and pricing your work. Free
Shipping Worldwide.
Read more & get free chapters at:
http://www.sitepoint.com/launch/b7c91e/3/4

To advertise here: http://www.freelancers.net/advertising.html


--=20
** Get all the Freelance Work you Can Handle *
The Web Design Business Kit will show you proven tactics
and strategies for marketing your business, winning bids,
managing projects and pricing your work. Free Shipping Worldwide.
Read more & get free chapters at:
http://www.sitepoint.com/launch/b7c91e/3/4

To advertise here: http://www.freelancers.net/advertising.html