Enum SqlCmdMode

Namespace

ItTiger.TigerQuery

Assembly

ItTiger.TigerQuery.dll

Selects which sqlcmd language features the parser recognizes.

public enum SqlCmdMode

Fields

Normal = 0

Parses SQL batches without interpreting sqlcmd directives or expanding variables.

SqlCmd = 1

Enables :setvar, :ON ERROR, and $(name) expansion; variables supplied programmatically seed the variable table and may be replaced by script assignments.

SqlCmdEx = 2

Enables sqlcmd features for applications and automation while preventing :setvar from replacing variables supplied through Variables. Script-local variables can still be created and updated when their names do not conflict with protected programmatic variables. Names are matched case-insensitively.

Remarks

All modes recognize GO batch separators and literal repeat counts. Sqlcmd directives and variable expansion are enabled only in SqlCmd and SqlCmdEx.