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 assign alias name for ASP.NET Web API Action?
What is session and cookies in asp.net?
What is HTTPModule and HTTPcontext? What is the use of each?
What is the difference between session and viewstate in asp.net?
Which is the parent class of the ASP.NET server control?
What is protected configuration?
How can we communicate with each server in N-tier Architecture? and what are the methods?
Any one can tell how we store tiff format images in database and retrive from the database(need for tiff format only)
Which Is Faster MVC or ASP.net ?
Whats the difference between registerclientscriptblock, registerclientscriptinclude and registerclientscriptresource?
What is the adavantage of using ASP.NET routing?
What do you mean by authorization?
What is the difference between client-side and server-side validations in ASP.NET?
Contrast OOP and SOA. What are tenets of each ?
Explain login controls.
