sys.sp_cursorprepare

Description

Compiles the cursor statement or batch into an execution plan, but doesn’t create the cursor. The compiled statement can later be used by. This procedure, coupled with , but is split into two phases. in a tabular data stream (TDS) packet. A SQL Server-generated prepared procedure in order to open a cursor. Once a handle is created, it exists until you sign out, or until you explicitly remove it through a

Syntax

sp_cursorprepare prepared_handle
OUTPUT
, params , stmt , options
[ , scrollopt [ , ccopt ] ]
[ ; ]