T_SQL : to execute local .sql file

Reference : http://shunge.blog.51cto.com/2944070/693704

1. Use .bat  to execute .sql :   XXX.bat

osql -S"127.0.0.1"  -U"sa" -P"sa" -d"Northwind" -i"%CD%\1.sql"

osql -S"127.0.0.1"  -U"sa" -P"sa" -d"Northwind" -i"%CD%\2.sql"

pause

2.Run in SQL management studio :

xp_cmdshell 'osql -U yourUserName -P YourPassword -d yourDBName -i D:\==SP\sp_Import_UpdJobStatus.sql'