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 displayed" on their web > page. I was thinking of using Top (200) in my SQL query, but now i > cannot because they want to see total records. and returning all > records and then displaying only 200 is not a good idea for > performance. > the dataacessframework that they are using does not support out > parameters. > > any ideas on hw to achieve this. > > Thanks > > > > > --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "DotNetDevelopment, VB.NET, C# .NET, ADO.NET, ASP.NET, XML, XML Web Services,.NET Remoting" group. To post to this group, send email to DotNetDevelopment@googlegroups.com To unsubscribe from this group, send email to [EMAIL PROTECTED] For more options, visit this group at http://cm.megasolutions.net/forums/default.aspx -~----------~----~----~----~------~----~------~--~---
