explain store procedure and trigger

Question Posted / merinkmathew

3 Answers
5593 Views
I also Faced
E-Mail Answers

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 two new properties are added in asp.net 4.0 page class?

0 Answers

Are cookies client side or server side?

0 Answers

Difference between overriding and overloading?

0 Answers

Can more than one person use the same login?

0 Answers MCN Solutions,

What is ViewState? What does the "EnableViewState" property do? Why would I want it on or off?

0 Answers

What is the use Membership in asp.net? and What is the use profiler in asp.net?

1 Answers

Explain cashing in asp.net.

0 Answers

What is the purpose of the following segment? If ( !IsPostBack) { sqldataAdapter1.Fill (dsusers1); DataGrid1.DataBind (); } a) To populate the DataAdapter the first time the web page id displayed. b) To populate the DataSet every time the web page is displayed. c) To populate the DataAdapter every time the web page is displayed. d)To populate the DataSet the first time the web page is displayed.

2 Answers Syntax Softtech,

What is Difference between Callbacks and Postback in ASP.NET?

1 Answers Patni,

What is role-based security?

1 Answers

Where are session variables stored?

0 Answers

What is razor? : asp.net mvc

0 Answers

For more ASP.NET Interview Questions Click Here