We help IT Professionals succeed at work.

Asynchronous cursor handling - SQL Server

Hi,

Can you please let me know with simple code example on:

How to handle cursors asynchronously in SQL Server ?

Thanks
Comment
Watch Question

Guy Hengel [angelIII / a3]Billing Engineer
CERTIFIED EXPERT
Most Valuable Expert 2014
Top Expert 2009

Commented:
can you please clarify the context in which you think you need
1) cursors in general
2) async cursors in general
3) async cursors as workaround to a problem to be solved differently anyhow

Author

Commented:
Async cursors in general.

Thanks
CERTIFIED EXPERT
Top Expert 2011

Commented:
still looking for some background from you on the circumstance , that you think needs an asynch cursor approach....

Author

Commented:
I am working on simple example to learn how it works.

Thanks
Billing Engineer
CERTIFIED EXPERT
Most Valuable Expert 2014
Top Expert 2009
Commented:
ok, let's start here:
http://msdn.microsoft.com/en-us/library/ms188667%28v=sql.90%29.aspx

so, basically, depending on how you declare your cursor, it "might" be filled/fetched async, but you don't need to code anything differently, excep in regards to the @@CURSOR_ROWS variable if you needed that one.

hope this helps

Author

Commented:
Partially true.