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 to include timer or counting time to display next page in asp.net

1805


What is the use of data set in asp.net?

668


Does google crawl redirects?

697


What is tracing? Where is it used?

796


Explain managed code an un-managed code.

762


Describe how passport authentication works.

764


Can we create a multiple user simultaneously ?

786


Explain parts of assembly?

722


Can I recieve both html markup for page and code in the asp.net web page's source code portion in the web browser?

714


What is asp.net used for?

796


Explain how viewstate is being formed?

723


What is Difference between Production Serves and Development Servers? And Suppose, m adding/deleting C# file in a project based on the Specific Requirement. These Files are Automatically updated in Production Servers? So Which tool is needed to do This One?

1713


Explain the difference between an exe and a dll?

702


How does asp page work?

712


can we remote debug applications with the remote debugger installed with vs.net 2002, with vs.net 2003?

1927