Can we execute a stored procedure inside a trigger?
Answers were Sorted based on User's Feedback
Answer / uttam singh rawat
Yes , we can execute the proc inside the trigger
exce proce_name(param,param1)
Is This Answer Correct ? | 35 Yes | 5 No |
Answer / 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 |
Answer / sql2000
The question is asking for if a SP can be executed from
within a trigger. In MS SQL 2000 have executed and this is
possible.
Is This Answer Correct ? | 9 Yes | 3 No |
Answer / reva ram sahu
Triger are executed automatically so we can't call them
within a stored procedure or within a function they are
executer explicitly when any DML command take place and also
fire in case of sql server 2005 whenere there is any DDL
command such as create table/proce or alter table/proce
Is This Answer Correct ? | 4 Yes | 11 No |
Answer / swetha
No you can't call stored procedure inside triggers.
Is This Answer Correct ? | 11 Yes | 29 No |
Answer / digambar patil
no, we cannot execute stored procedure in trigger.
Is This Answer Correct ? | 2 Yes | 20 No |
How to receive returning result from a query?
How to change the system date and time from SQL Plus Terminal ?
How to use transact-sql statements to access the database engine?
List the different index configurations possible for a table?
Which data type can be used only on OUTPUT parameters of the stored proceduer?
What is transaction server isolation?
Thanks to some maintenance being done, the sql server on a failover cluster needs to be brought down. How do you bring the sql server down?
Explain about Joins?
How can you control the amount of free space in your index pages?
What is the command used to get the version of sql server?
Where can you add custom error messages to sql server?
How many full-text indexes can a table have?