Can we execute a stored procedure inside a trigger?

Categories >> Software >> Databases >> SQL Server
Suggest New Category

Question Posted / abcd

6 Answers
25018 Views
BirlaSoft, CarrizalSoft Technologies, United Healthcare, I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

Can we execute a stored procedure inside a trigger?..

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

Can we execute a stored procedure inside a trigger?..

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

Can we execute a stored procedure inside a trigger?..

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

Can we execute a stored procedure inside a trigger?..

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

Can we execute a stored procedure inside a trigger?..

Answer / swetha

No you can't call stored procedure inside triggers.

Is This Answer Correct ?

11 Yes

29 No

Can we execute a stored procedure inside a trigger?..

Answer / digambar patil

no, we cannot execute stored procedure in trigger.

Is This Answer Correct ?

2 Yes

20 No

Post New Answer