ZipGrep is a utility that can list and search zip (.war, .ear, .jar, etc) archives for text patterns, without the need to extract the archive's contents.
One of a set of tools we're offering as a way to say thank you for being a part of the community.
Solved
run sql files through batch file
Posted on 2013-01-01
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
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
-
2
3 Comments
sqlcmd -E -S yoursqlinstance -i backup.sql
refer for more details
http://stackoverflow.com/questions/3294545/how-to-run-sql-file-from-a-batch-file
refer for more details
http://stackoverflow.com/questions/3294545/how-to-run-sql-file-from-a-batch-file
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
Featured Post
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Hi all,
It is important and often overlooked to understand “Database properties”. Often we see questions about "log files" or "where is the database" and one of the easiest ways to get general information about your database is to use “Database p…
Occasionally there is a need to clean table columns, especially if you have inherited legacy data. There are obviously many ways to accomplish that, including elaborate UPDATE queries with anywhere from one to numerous REPLACE functions (even within…
In this episode Don builds upon the troubleshooting techniques by demonstrating how to properly monitor a vSphere deployment to detect problems before they occur. He begins the show using tools found within the vSphere suite as ends the show demonst…
Is your data getting by on basic protection measures? In today’s climate of debilitating malware and ransomware—like WannaCry—that may not be enough. You need to establish more than basics, like a recovery plan that protects both data and endpoints.…
Suggested Courses
Course of the Month8 days, 8 hours left to enroll
598 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.