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 the Difference Between Primary and Foreign Key?

0 Answers   Accenture, Deloitte, JPMorgan Chase, Maveric,

What is the difference between a HAVING CLAUSE and a WHERE CLAUSE?

11 Answers   World Tech, Yardi Software,

How do I open a .db file?

0 Answers  

Explain query editor regions

0 Answers  

What are truncate options available in sql server? : sql server database administration

0 Answers  

How do you start single user mode in clustered installations?

0 Answers  

What is the most common trace flags used with sql server?

0 Answers  

What do you need to connect php to sql server?

0 Answers  

what is a self join? Explain it with an example? : Sql server database administration

0 Answers  

What is the downside of using udf?

0 Answers  

Why Do you want to work in this company?

4 Answers   HCL,

What are triggers? How do you invoke a trigger on demand?

0 Answers   Hexaware,

For more SQL Server Interview Questions Click Here
Categories