Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
kalyan.cse05
Yak Posting Veteran
74 Posts |
 Posted - 2012-06-19 : 06:59:16
|
| 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
Master Smack Fu Yak Hacker
3385 Posts |
Posted - 2012-06-19 : 07:00:31
|
| exec sp1exec 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. |
 |
|
|
kalyan.cse05
Yak Posting Veteran
74 Posts |
Posted - 2012-06-19 : 07:08:17
|
| 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 |
|
|
|
|
|
|
Script to Run multiple SP at a time