SQLserver from command prompt

sqlserver-from-command-prompt.bat

-- to use sqlCmd ( command line sql tool)

-- open command prompt and execute the "sqlcmd.exe" probably located at
-- "C:\Program Files\Microsoft SQL Server\100\Tools\Binn"

> sqlcmd.exe -U username -P password -S .\sqlServer

This will open sql server in cmd

1> select DB_Name()
2> Go

this will select the master DB

1> Use AdventureWorks
2> Go
Will change current Db to Adventureworks