Sign up to receive Decoded, a new monthly digest with product updates, feature release info, continuing education opportunities, and more.
run sql files through batch file
i need to run few sql files that hv stored procudures in them through a batch files , i dont know anything much abt how to do that , plz help with an example
Asked:
-
2
1 Solution
1) First Open one new notepad
then
write the sql commands that you want to excute
like this for example
USE MASTER
go
SELECT * FROM SYSDATABASES
go
now save the file with .sql suppose say (example.sql)
2) now open another notepad in the same folder
write the following code
osql -S servername -U username -P password <example.sql
pause
save this as .bat extension (this will create the batch file) file
3) double click on the batch file it will excute the commands
refer
http://www.sqlservercentral.com/Forums/Topic501783-8-1.aspx
then
write the sql commands that you want to excute
like this for example
USE MASTER
go
SELECT * FROM SYSDATABASES
go
now save the file with .sql suppose say (example.sql)
2) now open another notepad in the same folder
write the following code
osql -S servername -U username -P password <example.sql
pause
save this as .bat extension (this will create the batch file) file
3) double click on the batch file it will excute the commands
refer
http://www.sqlservercentral.com/Forums/Topic501783-8-1.aspx
Question has a verified solution.
Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.
Have a better answer? Share it in a comment.
Join & Write a Comment Already a member? Login.
Featured Post
Tackle projects and never again get stuck behind a technical roadblock.
Join Now
refer for more details
http://stackoverflow.com/questions/3294545/how-to-run-sql-file-from-a-batch-file