Answer / uttam singh rawat

Yes , we can execute the proc inside the trigger

exce proce_name(param,param1)

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.

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.

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

Answer / swetha

No you can't call stored procedure inside triggers.

Answer / digambar patil

no, we cannot execute stored procedure in trigger.

Do you know how to make remote connection in database?

0 Answers  

How to convert numeric expression data types using the cast() function?

0 Answers  

How efficient you are in oracle and SQL server?

0 Answers   CGI,

What is mean by dml?

0 Answers  

Mention the differences between local and global temporary tables.

0 Answers  

hi i gone though satyam interview. what is Acid Properties?

2 Answers   Satyam,

How do we get current date in SQL Server 2000, Oracle, MS Access?

13 Answers  

What are the four main query statements?

7 Answers   Wipro,

What is the difference between substr and charindex in the sql server?

0 Answers  

What happens if you insert a duplicate key for the primary key column in ms sql server?

0 Answers  

Explain what are commit and rollback in sql?

0 Answers  

please bar with my english i having a database called tblhallreservation in which res_date is date field has to select all the fields in table deponding on month either has to display all details for the month jan or feb and so on

1 Answers