CODEWITHSUNDEEP
sql-serversqlcmd
Tres
Tres

Reputation: 195

How to execute other file from script body in sqlcmd?

How I can execute other file in ms sql script for sqlcmd?

In sqlplus I can write something as:

@@DBS\other_scr1.sql
@@DBS\other_scr2.sql

promt OK

Upvotes: 0

Views: 151

Answers (1)

Rajesh Ranjan
Rajesh Ranjan

Reputation: 537

To run the script file

Open a command prompt window. In the Command Prompt window, type:

        sqlcmd -S myServer\instanceName -i C:\myScript.sql

Press ENTER. A list of Adventure Works employee names and addresses is written to the command prompt window.

To save this output to a text file Open a command prompt window. In the Command Prompt window, type:

    sqlcmd -S myServer\instanceName -i C:\myScript.sql -o C:\EmpAdds.txt

Press ENTER.

If you want to execute that through SQL Script.

Use xp_cmdshell which will ultimetly SQLCMD. Thanks

Upvotes: 1

Related Questions