Application Cursors

When a client application requests information from SQL Server using the default settings in ADO, OLE DB, ODBC, or DB-Library, SQL Server must follow this process:

  1. The client application sends a request to SQL Server in a network package. This request can be any Transact-SQL statement or a batch containing multiple statements.

  2. SQL Server interprets the request and creates a query plan to solve the request. The query plan is compiled and executed.

  3. SQL Server packages the results in the minimum number of network packets and sends them to the user.

  4. The clients start receiving network packets, and these packets are waiting in the network buffer for the application to request them.

  5. The client application receives the information contained ...

Get Microsoft® SQL Server™ 2000 Programming by Example now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.

Start your free trial