explain store procedure and trigger

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How can you access the properties and controls of master pages from content pages?

620


What is the current version of asp.net?

586


Explain the significance of routing? : asp.net mvc

646


What is the difference between session.abandon() vs clear()?

623


What is query string?

661






How will you load dynamic assembly? How will create assesblies at run time?

554


What is viewstate? What does the "enableviewstate” property do? Whay would I want it on or off?

607


What is the procedure to handle the process request using mhpm events fired? : asp.net mvc

640


Why SessionID changes in every request in asp.net?

629


Define authentication and authorization.

715


What is the life-span of the items in the viewstate?

586


How would you get asp.net running in apache web servers?

619


What do you mean by marshalbyref?

740


What is meant by server side scripting?

601


What are the difference between function and stored procedure in .net programming language?

353