Posts

Showing posts with the label helpfull stored procedure

Hidden Stored Procedure in SqlServer

List of hidden Stored procedure in Sqlserver.. Name Function sp_cursor Update a cursor sp_cursorclose close a cursor sp_cursorexecute Open a prepared cursor sp_cursorfetch Fetch rows sp_cursoropen Open a cursor sp_cursoroption Set cursor options sp_cursorprepare Prepare a cursor statement sp_cursorprepexec Prepare a cursor statement and open sp_cursorunprepare Free a prepared cursor statement sp_execute Execute a prepared statement sp_prepare Prepare an SQL statement sp_prepexec Prepare and execute an SQL statement sp_unprepare Free a prepared statement Sp_cursoropen Defines the attributes of an API server cursor, such as its scrolling behavior and the statement used to build the result set on which the cursor operates, then populates the cursor. The statement can contain embedded parameters. Syntax sp_cursoropen [ @cursor = ] cursor_handle OUTPUT, [ @stmt = ] ' stmt ' [, [ @scrollopt = ] scroll_options OUTPUT] [, [ @ccopt = ] concurrency_options OU