Can we execute a stored procedure inside a trigger?
- 6 Answers
- 22750 Views
- BirlaSoft, CarrizalSoft Technologies, United Healthcare, I also Faced
- E-Mail Answers
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
How to replace null values in expressions using isnull()?
What are a scheduled jobs or what is a scheduled tasks?
What is the difference between char, varchar and nvarchar?
Is there any difference between the primary key and unique key?
What is a db view?
What is attribute hierarchy? : sql server analysis services, ssas
Which data types generate inaccurate results if used with an = or <> comparison in a where clause of a sql statement?
How to locate and take substrings with charindex() and substring() functions?
What is query parameter in ssrs?
What are different types of replication in sql server?
What is abstracting periodical?
What gets stored inside msdb database?
What are the different subsets of sql?
What is an example of a foreign key?
How do I find the size of a sql server database?
