database not from your web page. This is the
> >> best
> >> I guess for both of you. If this is not important you select count(id) as
> >> Jamie suggest.
>
> >> Thank You
> >> MGZ
>
> >> -Original Message-
> >> From: DotNetDevelopm
gt; -Original Message-
>> From: DotNetDevelopment@googlegroups.com
>>
>> [mailto:[EMAIL PROTECTED] On Behalf Of Jamie Fraser
>> Sent: Tuesday, September 09, 2008 11:10 AM
>> To: DotNetDevelopment@googlegroups.com
>> Subject: [DotNetDevelopment] Re: show To
From: DotNetDevelopment@googlegroups.com
>
> [mailto:[EMAIL PROTECTED] On Behalf Of Jamie Fraser
> Sent: Tuesday, September 09, 2008 11:10 AM
> To: DotNetDevelopment@googlegroups.com
> Subject: [DotNetDevelopment] Re: show Total number of records in SQL query
>
> SET ROWCO
pment@googlegroups.com
Subject: [DotNetDevelopment] Re: show Total number of records in SQL query
SET ROWCOUNT
SELECT COUNT(Id)
On Mon, Sep 8, 2008 at 10:58 PM, tirath <[EMAIL PROTECTED]> wrote:
>
> hi,
> Due to large number of records in database, my client has asked to
> limi
why can't you use paging. there show only some records. when he click next
page, show him the next records.
or you can implement this paging in sql also by writing a query like fetch
the records from 50 to 75 etc by using row_number() function.
On 9/9/08, tirath <[EMAIL PROTECTED]> wrote:
>
>
> h
usual this would be done by a pager in your grid footer. Like google
does ;) individual pager items will request the limited records from
your database.
hope this helps.
On 8 Sep., 23:58, tirath <[EMAIL PROTECTED]> wrote:
> hi,
> Due to large number of records in database, my client has asked to
DECLARE @RecCount INT
SELECT @RecCount = COUNT(*) FROM [TableName]
SELECT TOP 200 @RecCount, [FieldName1], ... [FieldNameN] FROM
[TableName]
On Sep 9, 12:58 am, tirath <[EMAIL PROTECTED]> wrote:
> hi,
> Due to large number of records in database, my client has asked to
> limit the search results
SET ROWCOUNT
SELECT COUNT(Id)
On Mon, Sep 8, 2008 at 10:58 PM, tirath <[EMAIL PROTECTED]> wrote:
>
> hi,
> Due to large number of records in database, my client has asked to
> limit the search results to 200. but they also want information like
> "1000 records found, but only 200 are being displ
