Skip to content
New issue

Have a question about this project? # for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “#”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? # to your account

Support SQLCMD commands #11

Open
SqlQuantumLeap opened this issue Dec 14, 2015 · 0 comments
Open

Support SQLCMD commands #11

SqlQuantumLeap opened this issue Dec 14, 2015 · 0 comments
Assignees

Comments

@SqlQuantumLeap
Copy link
Owner

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
# for free to join this conversation on GitHub. Already have an account? # to comment
Projects
None yet
Development

No branches or pull requests

1 participant