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 |
|
doran_doran
Posting Yak Master
179 Posts |
 Posted - 2009-11-05 : 09:19:33
|
| I have to create about 30 SP for 30 diff tables. They will all follow the same pattern. Is there a systematic way to create all the SP at once instead of one by one? |
|
|
gangadhara.ms
Aged Yak Warrior
549 Posts |
Posted - 2009-11-05 : 09:52:11
|
| As the Stored procedure objects is user specific you can't create the all the sp's in one go though it is similar for all all 30 tables.Thanks,Gangadhar |
 |
|
|
doran_doran
Posting Yak Master
179 Posts |
Posted - 2009-11-05 : 10:03:00
|
| these will be under dbo and we will make sure certain people have access to it. |
|
|
|
jimf
Master Smack Fu Yak Hacker
2875 Posts |
Posted - 2009-11-05 : 11:41:58
|
| You could do it dynamically, but it would take you more time to write that code than it would to just do it manually.JimEveryday I learn something that somebody else already knew |
|
|
|
doran_doran
Posting Yak Master
179 Posts |
Posted - 2009-11-05 : 12:17:36
|
| kool. I will create them manually them. |
|
|
|
|
|
|
Create Stroed Proc for many tables