Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


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

Where do you think the users names and passwords will be stored in sql server?

4 Answers   BirlaSoft,


What is a trace frag?

0 Answers  


Explain the difference between function and stored procedure?

0 Answers  


how to get the rowid/rownumbes of a table in sqlserver

7 Answers   IBM,


What are the type of Indexes? which one is best, why?

6 Answers  


What is the recursive stored procedure in sql server?

0 Answers  


What are user defined datatypes and when you should go for them?

1 Answers  


What do you mean by an execution plan? How would you view it?

0 Answers  


can you anybody tell me the how can you restore the master database. while migraion(one server to onther server)?

1 Answers  


Can we check locks in database? If so, how can we do this lock check?

0 Answers  


What is a cube? : sql server analysis services, ssas

0 Answers  


What is acid properties?

0 Answers  


Categories