How to connect to SQL Server using Command Prompt (CMD)
----How to connect SQL Server using CMD----------
--How to connect SQL Server with Windows Authentication using CMD
SQLCMD -S SOLVEDPAGES\NODE1 -E
--How to connect SQL Server with SQL Authentication using CMD
SQLCMD -S SOLVEDPAGES\NODE1 -U SA -P Sql@123
--How to connect SQL Server To specific Database
SQLCMD -S SOLVEDPAGES\NODE1 -d demo -E
--How to connect SQL Server using DAC(Dedicated Administrators Account)
SQLCMD -S SOLVEDPAGES\NODE1 -A -E
--How to connect SQL Server and run a query
SQLCMD -S SOLVEDPAGES\NODE1 -E -Q "SELECT @@VERSION"
--How to connect SQL Server and run a query from file
SQLCMD -S SOLVEDPAGES\NODE1 -E -i "D:\SIMPLEQUERY.SQL"
--How to connect SQL Server run a query and get results in output file