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 clustered and non-clustered indexes in ms sql server?

0 Answers  

How to select nth record from a table?

13 Answers   DELL, Microsoft, Ramco,

What is use of @@ spid in sql server?

0 Answers  

What is database black box testing?

0 Answers  

How many tables can be joined in SQL Server?

0 Answers   Cap Gemini,

What is read committed?

0 Answers  

What is the datatype returned by count(*)

22 Answers   247Customer, Asian CERC,

What is built-in function?

0 Answers  

What is transact-sql language?

0 Answers  

What is the difference between the following two sql statements select count(*) from <tablename> select count(col_name) from <tablename>

5 Answers   247Customer,

What is temporary table in sql server? Why we use temp table?

0 Answers  

What is partition in sql server?

0 Answers  

For more SQL Server Interview Questions Click Here
Categories