<div>
Adjusted points to 70<br />

</div>


<div>
There are two ways ODBC driver can 'request' data from SQL server can send data to your application - either by executing straight select and sending all the data at once -in this case you will see 'SELECT....' statement. <br />
In the secon case it builds cursor on the server side and uses sp_cursorfetch to fetch data in chunks. <br />

</div>


There are two ways ODBC driver can 'request' data from SQL server can send data to your application - either by executing straight select and sending all the data at once -in this case you will see 'SELECT....' statement.
In the secon case it builds cursor on the server side and uses sp_cursorfetch to fetch data in chunks.


<div>
What would be the reason to use this method? Also, what <br />
are the parameters being used, such as 952266979 ?<br />

</div>


What would be the reason to use this method? Also, what
are the parameters being used, such as 952266979 ?


<div>
<div class="content wysiwyg-content">
While using SQL Trace on an application, I noticed the following code:<br />
sp_cursorfetch 95226679,2,0,1<br />
<br />
sp_cursorfetch is defined as follows:<br />
exec sp_addextendedproc 'sp_cursorfetch','(server internal)'<br />
<br />
Could someone explain what is happening here?
</div>
</div>


While using SQL Trace on an application, I noticed the following code:
sp_cursorfetch 95226679,2,0,1

sp_cursorfetch is defined as follows:
exec sp_addextendedproc 'sp_cursorfetch','(server internal)'

Could someone explain what is happening here?

sp_addextendedproc usage

Microsoft SQL Server is a suite of relational database management system (RDBMS) products providing multi-user database access functionality.SQL Server is available in multiple versions, typically identified by release year, and versions are subdivided into editions to distinguish between product functionality. Component services include integration (SSIS), reporting (SSRS), analysis (SSAS), data quality, master data, T-SQL and performance tuning.