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


explain store procedure and trigger

Answers were Sorted based on User's Feedback



explain store procedure and trigger..

Answer / deepak baldia

A stored procedure is a set of SQL commands that has been
compiled and stored on the database server.

A trigger is a special kind of stored procedure that is
invoked whenever an attempt is made to modify the data in
the table it protects. Modifications to the table are made
using INSERT,UPDATE,OR DELETE statements.

Is This Answer Correct ?    7 Yes 0 No

explain store procedure and trigger..

Answer / michael jerold

sp means to execute set of quries in single sp.and we can
call manually.


Trigger means dml operation happens the event will fire
automatically. we can not call manually.

Is This Answer Correct ?    2 Yes 0 No

explain store procedure and trigger..

Answer / vim@l katiyar

stored procedure is collection of sql query/command.it is database object.it stored in databse and uses for validation data and data access from data source. but it has some disadvantage like this .if more than one SP uses same server .
server performance down and once create and use many times.

trigger is sql procedure that initiates action when database modification query perform.it is automatically create .it is not executed like stored procedure .it is also execute stored procedure . when data modification sql command executed then action performed by trigger

Is This Answer Correct ?    0 Yes 0 No

Post New Answer

More ASP.NET Interview Questions

Which property on a Combo Box do you set with a column name, prior to setting the DataSource, to display data in the combo box?

1 Answers  


What are Authentication mechanisms in .Net?

6 Answers   Accenture,


What Are The Difference Between AutoEventWireup="true" and AutoEventWireup="False"

12 Answers   Phoenix Technologies,


What data type does the Range Validator control support?

5 Answers  


Why do we use web config?

0 Answers  


What is base class of .net?

0 Answers  


What is a 401 redirect?

0 Answers  


What is http response header?

0 Answers  


How you will handle session when deploying application in more than a server?

0 Answers  


COM+ Used ________________ Isolation Level

0 Answers   CTS,


what is the differance between native code & managed code?

5 Answers   Microsoft,


What is the use of session in web application?

0 Answers  


Categories