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
How can you implement encapsulation in asp.net?
Explain the role of global.asax?
Why would a company use an application service provider?
What is the basic purpose of the required field validator? How can you use a required field validator to check that the user changes the initial value of a text box? a listbox?
Can we store object in viewstate?
Where is cookie used in asp.net?
What are sql joins?
Mention the execution process for managed code?
Describe the difference between inline and code behind - which is best in?
How long should a session id be?
How do you secure your connection string information?
In how many ways we can retrieve table records count?
How you can return View from ASP.NET Web API method?
What is difference between viewstate and session in asp net?
Explain code snippet to register exception filters from controller?
