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...

  1. Categories >> Software >> Databases >> SQL Server
  2. Suggest New Category

What is difference between Triggers and store procedure?

Question Posted / sivasiva

Answers were Sorted based on User's Feedback



What is difference between Triggers and store procedure?..

Answer / vidit tyagi

triggers are events which fires automaticaly when any insert
,update or delete command execute
but in case of stored procedure we have to manualy
execute / fire to procedure

Is This Answer Correct ?    5 Yes 0 No

What is difference between Triggers and store procedure?..

Answer / sivasiva

Triggers:
Triggers create event that event pass the value for
insert,update delete automatically updated value for the
table.triggers are event driven sepecified procedure.store
and managed by DBMS.automatically fires the value.

Store procedure:
Fast Accesing.Reduse network traffic.sepatre businees rules
and logic from presentation layer

Is This Answer Correct ?    2 Yes 0 No

Post New Answer

More SQL Server Interview Questions

what is a schema in sql server 2005? : Sql server database administration

0 Answers  

How do I clean up sql server transaction log?

0 Answers  

What do you understand by recursive stored procedure?

0 Answers  

What is recursion? Is it possible for a stored procedure to call itself or recursive stored procedure?

0 Answers  

how we use window authentication connection with sql server.?

0 Answers   MCN Solutions,

What Is The Difference Between Primary Key & Super Key

3 Answers   Accenture,

Explain some DBCC commands?

6 Answers  

what is normalization? Explain different levels of normalization? : Sql server database administration

0 Answers  

What are sql server procedures?

0 Answers  

What is the difference between locking and multi-versioning?

0 Answers  

How many types of indexes are there in SQL Server?

6 Answers   CarrizalSoft Technologies, United Healthcare,

What is a data source file?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories