SimpleSqlExec
SimpleSqlExec copied to clipboard
Lightweight command-line utility to execute queries on SQL Server in place of SQLCMD
I wanted to start a discussion on the viability of a .NET Core version. Earlier this week I posted a draft PR (https://github.com/SqlQuantumLeap/SimpleSqlExec/pull/16) and from the looks of it its...
Script to reproduce: ```sql /* Instructions to use this stored procedure: exec stored_procedure arg1, arg2 go */ create procedure stored_procedure -- etc ``` Sometimes there may be a go within...
What license is this released under ? The MIT License (MIT)? Example: https://raw.githubusercontent.com/adamralph/stylecop-msbuild/master/license.txt
Add support for SQLCMD commands, such as: - `:r` - `:Setvar` - `[:] RESET` - `[:] !!` - `[:] QUIT` - `[:] EXIT` - `:List` - `:Listvar` - `:Error` -...
Allow substitution of `$(var_name)` variable. This also requires handling: - `-v` command-line switch - `:setvar` SQLCMD command - checking all 3 levels of environment variables - `-x` ignore scripting variables...
Batch parsing should be able to handle the following cases: 1. single, single-line block comment: ``` /* comment */ GO ``` 2. single, multiple-line block comment: ``` /* comment line...
By default in SQLCMD and SSMS, errors do not abort the current batch or cancel any remaining batches. The following, run in either of those, will return all four result...