风舞残阳 2008-4-2 17:54
一些在SQL帮助中找不到的系统存储过程－System stored
[size=3][/size]引用自http://jtds.sourceforge.net/apiCursors.html
Systemstoredprocedures
ThisdocumentcontainsinformationonundocumentedstoredproceduresinMicrosoft[wiki]SQL[/wiki]Server.
NameFunction
sp_cursorUpdateacursor
sp_cursorclosecloseacursor
sp_cursorexecuteOpenapreparedcursor
sp_cursorfetchFetchrows
sp_cursoropenOpenacursor
sp_cursoroptionSetcursoroptions
sp_cursorpreparePrepareacursorstatement
sp_cursorprepexecPrepareacursorstatementandopen
sp_cursorunprepareFreeapreparedcursorstatement
sp_executeExecuteapreparedstatement
sp_preparePrepareanSQLstatement
sp_prepexecPrepareandexecuteanSQLstatement
sp_unprepareFreeapreparedstatement
sp_cursoropen
DefinestheattributesofanAPIservercursor,suchasitsscrollingbehaviorandthestatementusedtobuildtheresultsetonwhichthecursoroperates,thenpopulatesthecursor.Thestatementcancontainembeddedparameters.
Syntax
sp_cursoropen[@cursor=]cursor_handleOUTPUT,
[@stmt=]'stmt'
[,[@scrollopt=]scroll_optionsOUTPUT]
[,[@ccopt=]concurrency_optionsOUTPUT]
[,[@rowcount=]rowcountOUTPUT]
[
{,[@paramdef=]N'parameter_namedata_type[,...n]'}
{,[@param1=]value1[,...n]}
]
Arguments
[@cursor=]cursor_handleOUTPUT
Isthenameofadeclaredintegervariabletoreceivethecursorhandle.cursor_handleisint,withnodefault.
[@stmt=]'stmt'
IsastringcontainingasingleSELECTstatementorasinglestoredprocedurecall.Thesizeofthestringislimitedonlybyavailabledatabaseservermemory.stmtcancontainparametershavingthesameformasavariablename,forexample:
'SELECT*FROMEmployeesWHEREEmployeeID=@IDParameter'
Eachparameterincludedinstmtmusthaveacorrespondingentryinboththe@paramdefparameterdefinitionlistandtheparametervalueslist.
[@scrollopt=]scroll_optionsOUTPUT
Isthecursorscrolltype.scroll_optionsisintwithadefaultof1(keyset-driven),andcanbeacombinationofthesevalues(exactlyoneofthefirst5mustbespecified).
ValueDescription
0x0001Keyset-drivencursor.
0x0002Dynamiccursor.
0x0004Forward-onlycursor.
0x0008Staticcursor.
0x0010Fastforward-onlycursor.
0x1000Parameterizedquery.
0x2000Autofetch.
0x4000Autoclose.
0x8000Checkacceptabletypes.
0x10000Keyset-drivenacceptable.
0x20000Dynamicacceptable.
0x40000Forward-onlyacceptable.
0x80000Staticacceptable.
0x100000Fastforward-onlyacceptable.
Onreturn,@scrolloptcontainsthetypeofcursoractuallycreated,whichmaynotmatchwhatwasrequested.
[@ccopt=]concurrency_optionsOUTPUT
Isthecursorconcurrency.concurrency_optionsisint,withadefaultof4(optimistic)andcanbeacombinationofthesevalues(exactlyoneofthefirst4mustbespecified).
ValueDescription
0x0001Read-only.
0x0002Scrolllocks.
0x0004Optimistic.Checkstimestampsand,whennotavailable,values.
0x0008Optimistic.Checksvalues(non-text,non-image).
0x2000OpenonanySQL.
0x4000Updatekeysetinplace.
0x10000Read-onlyacceptable.
0x20000Locksacceptable.
0x40000Optimisticacceptable.
Onreturn,@ccoptcontainsthetypeofcursoractuallycreated,whichmaynotmatchwhatwasrequested.
[@rowcount=]rowcountOUTPUT
Isthenameofadeclaredintegervariabletoreceivethenumberofaffectedrows.rowcountisintwithnodefaultvalue.
[@paramdef=]N'parameter_namedata_type[,...n]'
Isonestringthatcontainsthedefinitionsofallparametersthathavebeenembeddedinstmt.Eachparameterdefinitionconsistsofaparameternameandadatatype.nisaplaceholderindicatingadditionalparameterdefinitions.Everyparameterspecifiedinstmtmustbedefinedin@paramdef.IftheTransact-SQLstatementinstmtdoesnotcontainparameters,@paramdefisnotneeded.ThedefaultvalueforthisparameterisNULL.
[@param1=]value1
Isavalueforthefirstparameterdefinedintheparameterstring.Thevaluecanbeaconstantoravariable.Theremustbeaparametervaluesuppliedforeveryparameterincludedinstmt.ThevaluesarenotneedediftheTransact-SQLstatementinstmthasnoparameters.
n
Isaplaceholderforthevaluesofadditionalparameters.Valuescanbeonlyconstantsorvariables.Valuescannotbemorecomplexexpressionssuchasfunctions,orexpressionsbuiltusingoperators.
ReturnCodeValues
0(success)or1(failure).
ResultSets
Returnstheresultsetgeneratedbystmt,butcontainingnorows.
Remarks
sp_cursoropenisamorepowerful(andprogrammatic)wayofcreatingserver-sidecursorsonSQLServer.
Permissions
Executepermissionsdefaulttothepublicrole.
Examples
A.CreateacursorforasimpleSELECTstatement
Thissimpleexamplecreatesadynamicread-onlycursorforaSELECTstatementwithnoparameters.
USEpubs
--Createadynamcread-onlycursor
DECLARE@cursorINT
EXECsp_cursoropen@cursorOUTPUT,N'SELECT*FROMmyTable',2,8193
--Closethecursor
EXECsp_cursorclose@cursor
B.CreateacursorforaparameterizedSELECTstatement
Thisexamplecreatesadynamicread-onlycursorforaSELECTstatementwith2parameters.
USEpubs
--Createadynamcread-onlycursor
DECLARE@cursorINT
EXECsp_cursoropen@cursorOUTPUT,N'SELECT*FROMmyTableWHERE[email=col1=@P1]col1=@P1[/email]ANDcol2LIKE@P2',2,8193,[email=N]N'@P1[/email]INT,@P2VARCHAR(255)',10,'%x%'
--Closethecursor
EXECsp_cursorclose@cursor
C.Createacursorforastoredprocedurecall
Thisexamplecreatesadynamicread-onlycursorforastoredprocedurewith2parameters(theproceduremustreturnonlyoneresultsetorthecursorcreationwillfail).Notethatoutputparameterscanalsobeusedandreturnvaluesretrievedviaoutputparameters.
USEpubs
--Createadynamcread-onlycursor
DECLARE@cursorINT
DECLARE@retvalINT
EXECsp_cursoropen@cursorOUTPUT,'EXEC@P1=myProc@P2',2,8193,[email=N]N'@P1[/email]INTOUTPUT,@P2INT',@retval,1
--Closethecursor
EXECsp_cursorclose@cursor
sp_cursorfetch
FetchesaroworblockofrowsfromanAPIservercursor.
Syntax
sp_cursorfetch[@cursor=]cursor_handle
[,[@fetchtype=]fetchtype]
[,[@rownum=]rownumOUTPUT]
[,[@nrows=]nrowsOUTPUT]
Arguments
[@cursor=]cursor_handle
Isthecursorhandle.cursor_handleisint,withnodefault.
[@fetchtype=]fetchtype
Isthefetchtype.fetchtypeisint,withadefaultof2andcanhaveoneofthesevalues.
ValueDescription
0x0001Firstrow.
0x0002Nextrow.
0x0004Previousrow.
0x0008Lastrow.
0x0010Absoluterowindex.
0x0020Relativerowindex.
0x0040Byvalue(???).
0x0080Refresh.
0x0100Resultsetinfo.
0x0200Previousnoadjust(?).
0x0400Skipupdateconcurrency(???).
[@rownum=]rownumOUTPUT
Istherownumber.rownumisint,withadefaultofNULL.
[@nrows=]nrowsOUTPUT
Isthenumberofrowstofetch.nrowsisint,withadefaultofNULL(fetchallrows).
ReturnCodeValues
0(success)or1(failure).
ResultSets
Returnstherequestedroworgroupofrowsfromthecursor.
Remarks
Inadditiontofetchingrows,the'resultsetinfo'fetchtypecanbeusedtoretrieveinformationaboutthecursor(currentrowin@rownumandtotalnumberofrowsin@nrows).
Permissions
Executepermissionsdefaulttothepublicrole.
Example
USEpubs
--Createadynamcread-onlycursor
DECLARE@cursorINT
EXECsp_cursoropen@cursorOUTPUT,'SELECT*FROMmyTable',2,8193
--Fetchthenext3lines
EXECsp_cursorfetch@cursor,2,0,3
--Closethecursor
EXECsp_cursorclose@cursor
sp_cursorclose
ClosesandedeallocatesanAPIservercursor.
Syntax
sp_cursorclose[@cursor=]cursor_handle
Arguments
[@cursor=]cursor_handle
Isacursorhandleobtainedbycallingsp_cursorcreate.cursor_handleisint,withnodefault.
ReturnCodeValues
0(success)or1(failure).
ResultSets
None.
Permissions
Executepermissionsdefaulttothepublicrole.
Example
USEpubs
--Createadynamicread-onlycursor
DECLARE@cursorINT
EXECsp_cursoropen@cursorOUTPUT,'SELECT*FROMmyTable',2,8193
--Closethecursor
EXECsp_cursorclose@cursor
sp_cursoroption
SetsvariousoptionsforAPIservercursors.
Syntax
sp_cursoroption[@cursor=]cursor_handle,
[@code=]code,
{[@value=]value
│[@cursorname=]cursorname}
Arguments
[@cursor=]cursor_handle
Isacursorhandleobtainedbycallingsp_cursorcreate.cursor_handleisint,withnodefault.
[@code=]code
Istheoptioncode.codeisint,withnodefaultandcanbeoneofthesevalues.
ValueDescription
1OnlyreturntheTEXTPTRoftheLOBcolumnspecifiedbyvalue
2Setcursorname.
[@value=]value
Isthevalueoftheselectedoption(foroption1it'stheindexoftheLOBcolumn).valueisint,withnodefault.
[@cursorname=]cursorname
Isthenameforthecursor.cursornameissysname,withnodefault.
ReturnCodeValues
0(success)or1(failure).
ResultSets
None.
Permissions
Executepermissionsdefaulttothepublicrole.
Example
USEpubs
--Createadynamccursor
DECLARE@cursorINT
EXECsp_cursoropen@cursorOUTPUT,'SELECT*FROMmyTable',2,8193
--Namethecursor
EXECsp_cursoroption@cursor,2,'myCursor'
--Useacursorvariabletoaccessthecursor
DECLARE@xCURSOR
EXECsp_describe_cursor@xout,N'global','myCursor'
FETCHNEXTFROM@x
--Usethecursordirectlybyname
FETCHNEXTFROMmyCursor
--Closethecursor
EXECsp_cursorclose@cursor
sp_cursor
CanbeusedtorequestinsertsandpositionedupdatesordeletesonAPIservercursors.
Syntax
sp_cursor[@cursor=]cursor_handle,
[@optype=]optype,
[@rownum=]rownum,
[@table=]'table'
{,[@param1=]value1[,...n]}
Arguments
[@cursor=]cursor_handle
Isacursorhandleobtainedbycallingsp_cursorcreate.cursor_handleisint,withnodefault.
[@optype=]optype
Isatheoperationtoperform.optypeisint,withnodefaultandcanbeoneofthesevalues.
ValueDescription
1Updaterow(?).
4Insertrow.
33Updaterow.
34Deleterow.
[@rownum=]rownum
Isthenumberoftherowtoupdateinthefetchcache.rownumisint,withnodefault.
[@table=]'table'
Isthenameofthetabletoupdate(anemptycharacterstringseemstobeok).tableissysname,withnodefault.
ReturnCodeValues
0(success)or1(failure).
ResultSets
None.
Permissions
Executepermissionsdefaulttothepublicrole.
Example
USEpubs
--Createadynamccursor
DECLARE@cursorINT
EXECsp_cursoropen@cursorOUTPUT,'SELECT*FROMmyTable',2,8193
--Fetchthenext2lines;thisputslines1and2inthefetchbuffer
EXECsp_cursorfetch@cursor,2,0,2
--Updatethesecondlineinthefetchbuffer
EXECsp_cursor@cursor,33,2,'',@intCol=5,@charCol='x'
--Closethecursor
EXECsp_cursorclose@cursor
sp_cursorprepare
Usedtoprepareaparameterizedcursorstatement.
Syntax
sp_cursorprepare[@cursor=]statement_handleOUTPUT,
[@paramdef=]N'parameter_namedata_type[,...n]',
[@stmt=]N'stmt',
[@options=]options,
[,[@scrollopt=]scroll_optionsOUTPUT]
[,[@ccopt=]concurrency_optionsOUTPUT]
Arguments
[@cursor=]statement_handle
Isthenameofadeclaredintegervariabletoreceivethestatementhandle.statement_handleisint,withnodefault.
[@paramdef=]N'parameter_namedata_type[,...n]'
Isonestringthatcontainsthedefinitionsofallparametersthathavebeenembeddedinstmt.Eachparameterdefinitionconsistsofaparameternameandadatatype.nisaplaceholderindicatingadditionalparameterdefinitions.Everyparameterspecifiedinstmtmustbedefinedin@paramdef.
[@stmt=]'stmt'
IsastringcontainingasingleSELECTstatementorasinglestoredprocedurecall.Thesizeofthestringislimitedonlybyavailabledatabaseservermemory.stmtcancontainparametershavingthesameformasavariablename,forexample:
'SELECT*FROMEmployeesWHEREEmployeeID=@IDParameter'
Eachparameterincludedinstmtmusthaveacorrespondingentryinboththe@paramdefparameterdefinitionlist.
[@options=]options
Anintegervalue.Theexactfunctionofthisparameterisunknown.optionsisint,withavalueof1.
[@scrollopt=]scroll_optionsOUTPUT
Isthecursorscrolltype.scroll_optionsisintwithadefaultof1(keyset-driven).Seesp_cursoropenformoreinformation.
Onreturn,@scrolloptcontainsthetypeofcursoractuallycreated,whichmaynotmatchwhatwasrequested.
[@ccopt=]concurrency_optionsOUTPUT
Isthecursorconcurrency.concurrency_optionsisint,withadefaultof4(optimistic).Seesp_cursoropenformoreinformation.
Onreturn,@ccoptcontainsthetypeofcursoractuallycreated,whichmaynotmatchwhatwasrequested.
ReturnCodeValues
0(success)or1(failure).
ResultSets
None.
Permissions
Executepermissionsdefaulttothepublicrole.
Example
sp_cursorprepexec
Usedtoprepareandopenaparameterizedcursorstatement.Thiscommandcombinesthefunctionsofthesp_cursorprepareandsp_cursorexecuteproceduresandisavailablefromSQL2000onwards.
Syntax
sp_cursorprepexec[@handle=]statement_handleOUTPUT,
[@cursor=]cursor_handleOUTPUT,
[@paramdef=]N'parameter_namedata_type,[,...n]'
[@stmt=]N'stmt',
[,[@scrollopt=]scroll_optionsOUTPUT]
[,[@ccopt=]concurrency_optionsOUTPUT]
[,[@rowcount=]rowcountOUTPUT]
Arguments
[@handle=]statement_handle
Isthenameofadeclaredintegervariabletoreceivethestatementhandle.statement_handleisint,withnodefault.
[@cursor=]cursor_handleOUTPUT
Isthenameofadeclaredintegervariabletoreceivethecursorhandle.cursor_handleisint,withnodefault.
[@paramdef=]N'parameter_namedata_type[,...n]'
Isonestringthatcontainsthedefinitionsofallparametersthathavebeenembeddedinstmt.Eachparameterdefinitionconsistsofaparameternameandadatatype.nisaplaceholderindicatingadditionalparameterdefinitions.Everyparameterspecifiedinstmtmustbedefinedin@paramdef.
[@stmt=]'stmt'
IsastringcontainingasingleSELECTstatementorasinglestoredprocedurecall.Thesizeofthestringislimitedonlybyavailabledatabaseservermemory.stmtcancontainparametershavingthesameformasavariablename,forexample:
'SELECT*FROMEmployeesWHEREEmployeeID=@IDParameter'
Eachparameterincludedinstmtmusthaveacorrespondingentryinboththe@paramdefparameterdefinitionlist.
[@scrollopt=]scroll_optionsOUTPUT
Isthecursorscrolltype.scroll_optionsisintwithadefaultof1(keyset-driven).Seesp_cursoropenformoreinformation.
Onreturn,@scrolloptcontainsthetypeofcursoractuallycreated,whichmaynotmatchwhatwasrequested.
[@ccopt=]concurrency_optionsOUTPUT
Isthecursorconcurrency.concurrency_optionsisint,withadefaultof4(optimistic).Seesp_cursoropenformoreinformation.
Onreturn,@ccoptcontainsthetypeofcursoractuallycreated,whichmaynotmatchwhatwasrequested.
[@rowcount=]rowcountOUTPUT
Isthenameofadeclaredintegervariabletoreceivethenumberofaffectedrows.rowcountisintwithnodefaultvalue.
ReturnCodeValues
0(success)or1(failure).
ResultSets
Returnstheresultsetgeneratedbystmt,butcontainingnorows.
Permissions
Executepermissionsdefaulttothepublicrole.
Example
sp_cursorexecute
Usedtoexecute(open)apreparedcursorstatement.
Syntax
sp_cursorexecute[@handle=]statement_handle,
[@cursor=]cursor_handleOUTPUT,
[,[@scrollopt=]scroll_optionsOUTPUT]
[,[@ccopt=]concurrency_optionsOUTPUT]
[,[@rowcount=]rowcountOUTPUT]
{,[@param1=]value1[,...n]}
Arguments
[@handle=]statement_handle
Istheintegervalueofthestatementhandle.statement_handleisint,withnodefault.
[@cursor=]cursor_handleOUTPUT
Isthenameofadeclaredintegervariabletoreceivethecursorhandle.cursor_handleisint,withnodefault.
[@scrollopt=]scroll_optionsOUTPUT
Isthecursorscrolltype.scroll_optionsisintwithadefaultof1(keyset-driven).Seesp_cursoropenformoreinformation.
Onreturn,@scrolloptcontainsthetypeofcursoractuallycreated,whichmaynotmatchwhatwasrequested.
[@ccopt=]concurrency_optionsOUTPUT
Isthecursorconcurrency.concurrency_optionsisint,withadefaultof4(optimistic).Seesp_cursoropenformoreinformation.
Onreturn,@ccoptcontainsthetypeofcursoractuallycreated,whichmaynotmatchwhatwasrequested.
[@rowcount=]rowcountOUTPUT
Isthenameofadeclaredintegervariabletoreceivethenumberofaffectedrows.rowcountisintwithnodefaultvalue.
[@param1=]value1
Isavalueforthefirstparameterdefinedintheparameterstring.Thevaluecanbeaconstantoravariable.Theremustbeaparametervaluesuppliedforeveryparameterincludedinstmt.ThevaluesarenotneedediftheTransact-SQLstatementinstmthasnoparameters.
n
Isaplaceholderforthevaluesofadditionalparameters.Valuescanbeonlyconstantsorvariables.Valuescannotbemorecomplexexpressionssuchasfunctions,orexpressionsbuiltusingoperators.
ReturnCodeValues
0(success)or1(failure).
ResultSets
Returnstheresultsetgeneratedbythepreparedstatementhandle,butcontainingnorows.
Permissions
Executepermissionsdefaulttothepublicrole.
Example
sp_cursorunprepare
Usedtofreeapreparedcursorstatement.
Syntax
sp_cursorunprepare[@handle=]statement_handle
Arguments
[@handle=]statement_handle
Istheintegervalueofthestatementhandle.statement_handleisint,withnodefault.
ReturnCodeValues
0(success)or1(failure).
ResultSets
None.
Permissions
Executepermissionsdefaulttothepublicrole.
Example
sp_prepare
UsedtoprepareaparameterizedSQLstatement.
Syntax
sp_prepare[@handle=]statement_handleOUTPUT,
[@paramdef=]N'parameter_namedata_type[,...n]',
[@stmt=]N'stmt',
[@flag=]flag,
Arguments
[@handle=]statement_handle
Isthenameofadeclaredintegervariabletoreceivethestatementhandle.statement_handleisint,withnodefault.
[@paramdef=]N'parameter_namedata_type[,...n]'
Isonestringthatcontainsthedefinitionsofallparametersthathavebeenembeddedinstmt.Eachparameterdefinitionconsistsofaparameternameandadatatype.nisaplaceholderindicatingadditionalparameterdefinitions.Everyparameterspecifiedinstmtmustbedefinedin@paramdef.
[@stmt=]'stmt'
IsastringcontainingasingleSELECTstatementorasinglestoredprocedurecall.Thesizeofthestringislimitedonlybyavailabledatabaseservermemory.stmtcancontainparametershavingthesameformasavariablename,forexample:
'SELECT*FROMEmployeesWHEREEmployeeID=@IDParameter'
Eachparameterincludedinstmtmusthaveacorrespondingentryinboththe@paramdefparameterdefinitionlist.
[@flag=]flag
Anintegervalue.Theexactfunctionofthisflagisunknown.flagisint,withvalueof1.
ReturnCodeValues
0(success)or1(failure).
ResultSets
None.
Permissions
Executepermissionsdefaulttothepublicrole.
Example
sp_execute
UsedtoexecuteapreparedSQLstatement.
Syntax
sp_execute[@handle=]statement_handle
{,[@param1=]value1[,...n]}
Arguments
[@handle=]statement_handle
Istheintegervalueofthestatementhandle.statement_handleisint,withnodefault.
[@param1=]value1
Isavalueforthefirstparameterdefinedintheparameterstring.Thevaluecanbeaconstantoravariable.Theremustbeaparametervaluesuppliedforeveryparameterincludedinpreparedstatementhandle.ThevaluesarenotneedediftheTransact-SQLstatementinstmthasnoparameters.
n
Isaplaceholderforthevaluesofadditionalparameters.Valuescanbeonlyconstantsorvariables.Valuescannotbemorecomplexexpressionssuchasfunctions,orexpressionsbuiltusingoperators.
ReturnCodeValues
0(success)or1(failure).
ResultSets
Returnsaresultsetifspecifiedbythepreparedstatement.
Permissions
Executepermissionsdefaulttothepublicrole.
Example
sp_unprepare
UsedtofreeapreparedSQLstatement.
Syntax
sp_unprepare[@handle=]statement_handle
Arguments
[@handle=]statement_handle
Istheintegervalueofthestatementhandle.statement_handleisint,withnodefault.
ReturnCodeValues
0(success)or1(failure).
ResultSets
None.
Permissions
Executepermissionsdefaulttothepublicrole.
Example
sp_prepexec
UsedtoprepareandexecuteaparameterizedSQLstatement.Thiscommandcombinesthefunctionsofthesp_prepareandsp_executeproceduresandisavailablefromSQL2000onwards.
Syntax
sp_prepexec[@handle=]statement_handleOUTPUT,
[@paramdef=]N'parameter_namedata_type,[,...n]'
[@stmt=]N'stmt',
{,[@param1=]value1[,...n]}
Arguments
[@handle=]statement_handle
Isthenameofadeclaredintegervariabletoreceivethestatementhandle.statement_handleisint,withnodefault.
[@paramdef=]N'parameter_namedata_type[,...n]'
Isonestringthatcontainsthedefinitionsofallparametersthathavebeenembeddedinstmt.Eachparameterdefinitionconsistsofaparameternameandadatatype.nisaplaceholderindicatingadditionalparameterdefinitions.Everyparameterspecifiedinstmtmustbedefinedin@paramdef.
[@stmt=]'stmt'
IsastringcontainingavalidSQLstatement.Thesizeofthestringislimitedonlybyavailabledatabaseservermemory.stmtcancontainparametershavingthesameformasavariablename,forexample:
'SELECT*FROMEmployeesWHEREEmployeeID=@IDParameter'
Eachparameterincludedinstmtmusthaveacorrespondingentryinboththe@paramdefparameterdefinitionlist.
[@param1=]value1
Isavalueforthefirstparameterdefinedintheparameterstring.Thevaluecanbeaconstantoravariable.Theremustbeaparametervaluesuppliedforeveryparameterincludedinstmt.ThevaluesarenotneedediftheTransact-SQLstatementinstmthasnoparameters.
n
Isaplaceholderforthevaluesofadditionalparameters.Valuescanbeonlyconstantsorvariables.Valuescannotbemorecomplexexpressionssuchasfunctions,orexpressionsbuiltusingoperators.
ReturnCodeValues
0(success)or1(failure).
ResultSets
Returnsaresultsetifspecifiedbythepreparedstatement.
Permissions
Executepermissionsdefaulttothepublicrole.
Example
