how to execute .sql files with parameter

Question

Hello is it possible to run .sql file with parameter

like

:R c:\scripts\<scrips1>.sql,<param>
:R c:\scripts\<scrips2>.sql,<param>

Where are you trying to "execute" these from? .SQL files open in SQL Server Management Studio where you can execute them there; they don't execute outside of that. — rory.ap
– rory.ap, Commented May 13, 2014 at 11:45
Possible duplicate of this... stackoverflow.com/questions/9010359/… — Naveed Butt
– Naveed Butt, Commented May 13, 2014 at 11:46

Rahul Tripathi · Accepted Answer · 2014-05-13 11:47:16Z

3

Try this:

sqlcmd -E -S <Server name> -v test="Some value" -i YourSqlFile.sql

answered May 13, 2014 at 11:47

Rahul Tripathi

173k33 gold badges292 silver badges341 bronze badges

Sign up to request clarification or add additional context in comments.

1 Answer 1