Interested to Buy Any Domain ? << Click Here >> for more details...
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's the ASP.Net Application life cycle?
What are session state modes in asp.net?
What is validation in asp.net?
Explain what is viewstate?
How can you handle unmanaged code exceptions in asp.net?
What is asp.net mvc5? : Asp.Net MVC
Where can I get the details on migration of existing projects using various technologies to asp.net?
What is in a session cookie?
What is AutoEventWireup attribute for ?
Web API uses which library for JSON serialization?
What does asax stand for?
What is master page in dtp?
Explain Authentication mechanism in dotnet
Define dll hell?
How to handle errors in Web API?
