running multiple scripts in MSSQL

1. Create the script
:setvar workpath "c:\scripts\"
:setvar FileToexecute "test3.sql"
--:r $(workpath)$(FileToexecute)
:r $(workpath)test1.sql
:r $(workpath)test2.sql
2. enable SQLCMD mode
3. Run the above query

http://beyondrelational.com/blogs/nakul/archive/2011/05/12/sqlcmd-mode-in-ssms-final-part-in-the-series-underappreciated-features-of-microsoft-sql-server.aspx

enabling the SQLCMD mode

http://www.simple-talk.com/sql/sql-tools/the-sqlcmd-workbench/

using :r

http://vadivel.blogspot.com/2007/10/sqlcmd-part-viii-r-and-about.html

joining :r with variables

http://msdn.microsoft.com/en-us/library/aa833281.aspx

unable to use buildin sqlcmd variables