Interested to Buy Any Domain ? << Click Here >> for more details...
Can we execute a stored procedure inside a trigger?
- 6 Answers
- 25004 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
When would you use a before or after trigger?
explain different types of backups avaialabe in sql server? Given a particular scenario, how would you go about choosing a backup plan? : Sql server database administration
What is a cube? : sql server analysis services, ssas
Explain security with sql azure?
What is the use of keyword with encryption.
what are the different types of SSRS reports?
What do you mean by an execution plan?
What are the advantages of having an index on the sql server?
List some advantages and disadvantages of stored procedure?
Tell me the difference between clustered and non-clustered index?
What is the maximum rows in sql server table?
How to create a simple user defined function in ms sql server?
what are the different ways of moving data/databases between servers and databases in sql server? : Sql server database administration
What is an identity?
What is transaction server isolation?
