Statement Execution Constants (SQLDMO_EXEC_TYPE)
This feature will be removed in a future version of Microsoft SQL Server. Avoid using this feature in new development work, and plan to modify applications that currently use this feature.
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 does not break the connection. |
SQLDMOExec_Default |
0 |
No statement execution options are set. |
SQLDMOExec_/NoCommandTerm |
1 |
Ignores the command terminator in the script. The commands run as a single batch. |
SQLDMOExec_NoExec |
4 |
Executes SET NOEXEC ON prior to batch execution. SET NOEXEC OFF is executed after batch execution. |
SQLDMOExec_QI_ON |
16 |
Executes SET QUOTED_IDENTIFIER ON prior to batch execution. SET QUOTED_IDENTIFIER OFF is executed after batch execution. |
SQLDMOExec_ParseOnly |
8 |
Executes SET PARSEONLY ON prior to batch execution. SET PARSEONLY OFF is executed after batch execution. |