Answer Posted / 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 View All Answers
Define repository pattern in asp.net mvc? : asp.net mvc
Describe paging in asp.net?
What is the caspol.exe tool used for?
Explain about ASP.NET?
What is difference between cookies and cache?
How can we prepairing Interview
What do you mean by authentication?
What are the differences between the response.write() and response.output.write()?
What is application and session in asp.net?
Apart from IDE what are the enhancements in asp.net 2.0?
How many types of sessions are there in asp net?
Will the asp.net validators run in server side or client side?
What is AutoPostback?
How to implement role based security in asp.net mvc? : Asp.Net MVC
How does asp net store session ids by default?
