Execute Long Sql Script in MS Sql Using Command Prompt

sqlcmd -S server-name -d database-name -i script.sql

• Open cmd.exe as Administrator.
• Create Documents directory.
• Put your SQL Script file(script.sql) in the documents folder.
• Type query with sqlcmd, server-name, database-name and script-file-name as like above highlighted query or below command line screen.

Change Directory :

FROM C TO D

C:/Users>d:

D:\>cd Books

D:\Books>