How to run a SQL query using command prompt without SQL SSMS

Spread the love

Introduction

How to run a SQL query using command prompt without SQL SSMS
Open CMD from Run and run the below command (CMD) to connect with Database engine.

Then you can run type your SQL query. Once you are done with all your statement then put an enter. Then type Go and put enter. Shown in the below screen shot.

SQLCMD
SQLCMD

Spread the love
Soyeluddin Biswas, SQL Server DBA. Mostly involved in Data center migration. He has rich experience in SQL server design and database migration.

Leave a Reply

Your email address will not be published. Required fields are marked *