explain store procedure and trigger

Question Posted / merinkmathew

3 Answers
5460 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

What are the advantages and disadvantages of session?

0 Answers

How is a session stored and maintained in asp.net?

0 Answers

write a sample code make use of xmltext writer

1 Answers GCI,

What are resource file and how do we generate resource file?

0 Answers

hi .net gurus. plz if any one has dumps on 70-631 and 70-541 on windows sharepoint services kindly mail me.

0 Answers

What do you mean by authorization?

0 Answers

How can you handle exceptions in asp.net?

0 Answers

We have 2 sites in which one site allows the user with out asking credentials and second one ask for credentials through a log page. What might be the configurations settings for both sites? We can use IIS and web.config files together.

1 Answers ADITI,

what is the use of untyped data set ?

5 Answers TCS, Wipro,

To display data in a Repeater control which templete is provided ?

4 Answers Siebel,

14. What are your Future Plans for Swatz Oils GROUP U.K?

0 Answers CSC, Swatz Oils, TCS,

What is custom tag in Web.Config?

0 Answers Accenture,

For more ASP.NET Interview Questions Click Here