Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 Query tool

Author  Topic 

ilimax
Posting Yak Master

164 Posts

Posted - 2006-02-28 : 07:15:37
I heard there is sql command in SQL Server which you can use for pulling faster query. Actually I heard command works on this way: it is pulling just first about 100 records or some, and show them to user, and other recrods continue with pulling later. This give to user filling that look faster, but query still pulling records while user review first 100 or some.

Does anybody know for this commmand???

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2006-02-28 : 07:58:26
If you meant Pagination, refer this
http://weblogs.sqlteam.com/jeffs/archive/2003/12/22/672.aspx

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
   

- Advertisement -