Statement execution constants are used to direct the behavior of the ExecuteImmediate method, altering execution behavior or interpretation of the statement submitted for execution.
| Constant | Value | Description |
|---|---|---|
| SQLDMOExec_ContinueOnError | 2 | Batch execution continues on any error that doesn't 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. |
| ExecuteImmediate Method (Database, SQLServer) | SET PARSEONLY |
| SET NOEXEC | SET QUOTED_IDENTIFIER |