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 setting must be added in the configuration file to deny a particular user from accessing the secured resources?
Explain the asp.net session state modes.
Explain swagger components.
Which is the parent class of the ASP.NET server control?
Which methods validate all the controls on a page?
What is work flow gen? how can it will work with .Net?
What is microsoft windows sharepoint services?
How does output caching work in ASP.NET?
What is the Difference between MVC And MVP design pattrens
How to find out what version of asp.net I am using on my machine?
What are the types of validation in asp net?
Disable Mouse right click on web page in asp.net?
Can I stream live content/events?
What are the different method of navigation in asp.net?
What are the different types of Caching techniques in ASP.NET?
