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
What is a mixed extent?
What is the difference between NOROW and LOCKROW?
What are types of subqueries?
Can you tell me some of the common replication dmv's and their use? : sql server replication
How to use union to merge outputs from two queries together in ms sql server?
Can you explain about buffer cash and log cache in sql server?
Write a query to include a constraint, to check whether the employee salary is greater than 5000?
Explain what is meant by replication of database?
What happens if you are trying to access a schema not owned by you?
What is sql service broker?
What is a view and what are its advantages?
What is indexing and its types?
What is page-level compression?
What is data modeling and Reterminal integrity?
Explain filtered indexes benefits?