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

What is clr? Difference between clr & cts?

684


What is the difference between the response.write() and response.output.write() methods?

507


What are user controls?

565


What is the life cycle of an asp.net page?

524


What should you do is you want to remove an existing component but would like to make some funtionalities?

1480






Please brief not about xsd,xslt & xml?

542


What is authentication in asp.net?

564


Why do we need Sessions?

578


What is asp.net and its advantages?

547


Which is faster union or union all?

570


How can you identify that the page is post back?

552


What are the three parts of an http response?

525


Define view state.

548


Can a master page have more than one contentplaceholder?

506


What is a web server? What are the load limits in it?

584