explain store procedure and trigger
Answers were Sorted based on User's Feedback
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 |
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 |
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 |
what is the purpose of update panel control in ajax?
.net allows which inheritence
6 Answers AG Technologies, Samcomm,
What is inheritance and an how it be used, example with an example?
can we transfer data from one page to another page using viewstate if so how?if not y?
Which method do you invoke on the DataAdapter control to load your generated dataset with data?
What are the types of authentication in asp.net?
What is machine.config and web.config ?
Difference between abstract factory pattern and factory method pattern in .NET with example.
3 Answers ACS, IBM, Keane India Ltd,
Define xmlreader class.
all asp.net interives questions
How to send auto matic emails based on scheduled tasks to several of my clients
What are the events that happen when a client requests an asp.net page from iis server?