search

microsoft / go-sqlcmd

The new sqlcmd, CLI for SQL Server and Azure SQL (winget install sqlcmd / sqlcmd create mssql / sqlcmd open ads)
https://learn.microsoft.com/sql/tools/sqlcmd/go-sqlcmd-utility
MIT License
334 stars 58 forks source link

Add --database flag to `sqlcmd query` #287

Closed stuartpa closed 1 year ago

stuartpa commented 1 year ago

Allow user to specify the database they want to connect to when doing sqlcmd query

C:\src\go-sqlcmd\cmd\modern>sqlcmd query "SELECT DB_NAME()"
--------------------------------------------------------------------------------------------------------------------------------
AdventureWorksLT
(1 row affected)

C:\src\go-sqlcmd\cmd\modern>sqlcmd query "SELECT DB_NAME()" -d master
--------------------------------------------------------------------------------------------------------------------------------
master
(1 row affected)