sql-util-cli v0.1.2

SQL CLI

A set of command line utilities for MS SQL Server

Install

npm install sql-util-cli -g

Usage (Examples)

sql-util-cli -s \"SELECT 2 AS Age\" -t \"SELECT 2 AS Age\" -sv ServerName -db dbName
sql-util-cli -s \"EXEC dbo.GetClient 17\" -t \"EXEC dbo.GetClient 17 -sv ServerName -db dbName

Env File (Optional)

Optionally add an env file to specify server name and database name with the following structure:

SQL_CLI_SERVER=YourServerName
SQL_CLI_DATABASE=YourDatabaseName