O'Reilly logo

Microsoft® SQL Server™ 2000 Programming by Example by Carlos Eduardo Rojas, Fernando G. Guerrero

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

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 ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required