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
What are ASHX files?
What are the HTML server controls in ASP.NET?
What is the good practice to implement validations in aspx page?
Explain the different parts that constitute ASP.NET application?
What is the difference between page directive include and action tag include?
Which object encapsulates state or data of a user?
what is command line compiler.what are the steps and how it is related to debugging.
When we use cookie less session? Explain its working?
What is the life cycle of web page?
How is it possible for .NET to support many languages?
What is the use of HttpHandlers? When to use this?
What is data binding in asp net?
Why do we need asp.net?
Disable browser cache for entire ASP.NET website?
Less than one page, how many windows will you be able to maintain?
