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));