Can we execute a stored procedure inside a trigger?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are subqueries in sql server?

606


Would you store your query in a ssrs report or a database server? State the reason why?

110


How to drop an existing stored procedure in ms sql server?

556


What is the syntax for encrypting a column in SQL Server?

563


Explain tablesample?

561






How can change procedure in sql server?

530


Difference between 2NF &3NF ?

688


What are the different types of backups avaialabe in sql server 2005?

630


How to write the storeprocedure with in the store procedure? and how can we write the store procedure with in a trigger vice versa? plz post me the exact answer?

2129


What is the boxing and unboxing concept in .net?

558


What were the latest updates to SQL Azure service?

94


What is the difference between delete and truncate statements?

579


How to include date and time values in sql statements?

638


What are the disadvantages of indexes?

544


Describe the functionalities that views support.

672