Can we execute a stored procedure inside a trigger?
- 6 Answers
- 23175 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
Can we write ddl in trigger?
Explain timestamp datatype?
What is the name of the system variable that returns the number of rows affected by a SQL statement?
What are the main differences between #temp tables and @table variables and which one is preferred?
Difference between Sql server reporting services and Crystal reports?
What is update_statistics command?
What is the syntax to execute the sys.dm_db_missing_index_details? : sql server database administration
What is the federation in sql azure?
Why functions are used in sql server?
How to convert a unicode strings to non-unicode strings?
What is the difference between Normalization and De-normalization?
How many ways to create table-valued functions?
How many levels of sp nesting are possible?
What are difference between Cluster index and Non-Cluster index?
How do I repair damaged sql server mdf file database? In previous day my mdf file has got damage due to unknown reasons then I used dbcc chekcdb command but it failed, MDF file is important for me, I don’ know that how to get back mdf file data. Please anyone suggest me?
