Can we execute a stored procedure inside a trigger?
Answer Posted / mohd masood siddiqui
Yes, we can call a stored procedure.
SQL doesn't have a row trigger. Triggers fire once per
statement, not per row. Hence it's not recommended to have
triggers call procedures that have to execute one row at a
time. It's slow.
| Is This Answer Correct ? | 13 Yes | 3 No |
Post New Answer View All Answers
Can I use sql azure as a backup with log shipping or database mirroring?
Is there any difference between primary key and unique with the not null condition?
Do you have any idea about the tcl commands?
What are the export options of ssrs?
What is nolock?
what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration
Explain Geography datatype in SQL Server
What is SQL Azure Federations?
What is the difference between for auto and for nested?
What is merge?
How to use old values to define new values in update statements in ms sql server?
Benefits of Stored Procedures?
Explain a join?
What are the advantages of using cte?
What does set rowcount do?