The ExecuteImmediate method submits a Transact-SQL command batch on a connection, and directs execution or batch interpretation as specified by the application.
Database Object | SQLServer Object |
object.ExecuteImmediate( Command , [ ExecutionType ]
, [ Length ] )
Part | Description |
---|---|
object | Expression that evaluates to an object in the Applies To list. |
Command | String specifying a Transact-SQL command batch. |
ExecutionType | Optional. Long integer controlling statement batch execution as described in Settings. |
Length | Optional. Long integer indicating the statement batch length. |
Set the ExecutionType argument by using these values.
Constant | Value | Description |
---|---|---|
SQLDMOExec_ContinueOnError | 2 | Batch execution continues on any error that does not break the connection. |
SQLDMOExec_Default | 0 | No statement execution options set. |
SQLDMOExec_NoCommandTerm | 1 | Ignore the command terminator in the script. Execute as a single batch. |
SQLDMOExec_NoExec | 4 | Execute SET NOEXEC ON prior to batch execution. Execute SET NOEXEC OFF after batch execution. |
SQLDMOExec_ParseOnly | 8 | Execute SET PARSEONLY ON prior to batch execution. Execute SET PARSEONLY OFF after batch execution. |
SQLDMOExec_QI_ON | 16 | Execute SET QUOTED_IDENTIFIER ON prior to batch execution. Execute SET QUOTED_IDENTIFIER OFF after batch execution. |
HRESULT ExecuteImmediate(
SQLDMO_LPCSTR Command,
SQLDMO_EXEC_TYPE ExecType = SQLDMOExec_Default,
long lLength CPPDEFAULT(= 0));