SimpleSqlExec icon indicating copy to clipboard operation
SimpleSqlExec copied to clipboard

Support SQLCMD commands

Open SqlQuantumLeap opened this issue 8 years ago • 0 comments

Add support for SQLCMD commands, such as:

  • :r
  • :Setvar
  • [:] RESET
  • [:] !!
  • [:] QUIT
  • [:] EXIT
  • :List
  • :Listvar
  • :Error
  • :Out
  • :Connect
  • :On Error

Optionally:

  • [:] ED
  • :Perftrace
  • :Help
  • :XML [ON | OFF]

Do not do these:

  • :Serverlist

These commands are described on the following MSDN page:

sqlcmd Utility

Start with :r and :setvar as they are the most commonly used, especially if using SSDT.

NOTES:

  • SQLCMD processes commands and variable substitution per each batch!
  • SQLCMD command names are handled as case-insensitive
  • SQLCMD commands inside of block comments and string literals are not processed.
  • need to also handle -X[1]:
    • Disables ED and !! commands
    • default behavior is to display a warning only
    • if the 1 is also specified, error and exit

SqlQuantumLeap avatar Dec 14 '15 20:12 SqlQuantumLeap