Can we execute a stored procedure inside a trigger?

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

More SQL Server Interview Questions

How to receive returning result from a query?

0 Answers  


How to change the system date and time from SQL Plus Terminal ?

0 Answers   MCN Solutions,


How to use transact-sql statements to access the database engine?

0 Answers  


List the different index configurations possible for a table?

0 Answers  


Which data type can be used only on OUTPUT parameters of the stored proceduer?

2 Answers  






What is transaction server isolation?

0 Answers  


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?

0 Answers  


Explain about Joins?

0 Answers   Infosys,


How can you control the amount of free space in your index pages?

0 Answers  


What is the command used to get the version of sql server?

1 Answers  


Where can you add custom error messages to sql server?

0 Answers  


How many full-text indexes can a table have?

0 Answers  


Categories