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 are the types of lock supported by ?

0 Answers   HCL,

what's the maximum size of a row? : Sql server database administration

0 Answers  

What is named calculation? : sql server analysis services, ssas

0 Answers  

What is row by row processing ?

2 Answers  

How to truncate a table first before running a package?

1 Answers  

How to make a column nullable?

0 Answers  

what type of index will get created after executing the above statement? : Sql server database administration

0 Answers  

Explain primary key, foreign key and unique key?

0 Answers  

What does the on update no action do?

0 Answers  

What are the different types of stored procedures?

0 Answers  

What is meant by datasource?

0 Answers  

How efficient you are in oracle and SQL server?

0 Answers   CGI,

For more SQL Server Interview Questions Click Here
Categories