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 |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2006-04-06 : 20:03:17
|
| Annad writes "Hi All,please can anyone tell me how i should call a sql stored procedure inside the trigger - exactly let me tell you all that what is my requirement - the need is that i have one table postposition inside when ever a position will be posted and i want to write the trigger after insert it will search the match alert table if what ever candidates have found with this posted position matched then the trigger will call the my stored procedure wwhich will take few parameters and update the send mail table and this all should be done in the respect of speed Optimization so the speed or performanance should not be affected.Note there could be 1000 of candidates in the match alert tabel so make sure this all working very fine with al of them.Please if you have solution then please kindly send me my email address.Thanks to All." |
|
|
afrika
Master Smack Fu Yak Hacker
2706 Posts |
Posted - 2006-04-06 : 21:07:00
|
| exec stored_proceedure_name @add_your_parameters_here |
 |
|
|
|
|
|
Calling procedure inside the Insert trigger