Yes title is correct, you can execute queries on CMD for SQL Server. See below syntax showing how to connect with CMD and enter in SQL Prompt to execute queries.
Step 1 - Open CMD
Step 2 - Connect
C:\Users\*****>SQLCMD -S IP_Address\Instance_Name -U sa -P SQL_Server_Password
1>
2> select * from master.test
3> Go
Step 1 - Open CMD
Step 2 - Connect
C:\Users\*****>SQLCMD -S IP_Address\Instance_Name -U sa -P SQL_Server_Password
1>
2> select * from master.test
3> Go
No comments:
Post a Comment