SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 Script to Run multiple SP at a time
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

kalyan.cse05
Yak Posting Veteran

India
68 Posts

Posted - 06/19/2012 :  06:59:16  Show Profile  Reply with Quote
I have 20 SPs and 5 update scripts. I want to run all these at a time through a script. Can someone please help me?

kalyan Ashis Dey

nigelrivett
Flowing Fount of Yak Knowledge

United Kingdom
3328 Posts

Posted - 06/19/2012 :  07:00:31  Show Profile  Visit nigelrivett's Homepage  Reply with Quote
exec sp1
exec sp2
...
update ...
update ...


==========================================
Cursors are useful if you don't know sql.
SSIS can be used in a similar way.
Beer is not cold and it isn't fizzy.
Go to Top of Page

kalyan.cse05
Yak Posting Veteran

India
68 Posts

Posted - 06/19/2012 :  07:08:17  Show Profile  Reply with Quote
Thanks for your help.
But i don't need that actually. these 20 SPs are new SPs and need to create first. So i have a Folder which contains these 20 SPs. Now i need a batch file which take the SP name from the folder and read the contents of the SP and create it in the Database.

kalyan Ashis Dey
Go to Top of Page
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.05 seconds. Powered By: Snitz Forums 2000