Answer Posted / manisha
Stored procedured are precompiled and preoptimized sql stmts
so it takes less processing time,means executes much faster.
Can be shared between multiple user,so more reusable.
Much easier to manage it,since it resides in DB
more secure,flexible
Is This Answer Correct ? | 16 Yes | 3 No |
Post New Answer View All Answers
What is indexing and its types?
What is sql server locking?
What will be the value of @@fetch_status if a row that was a part of the cursor resultset has been deleted from the database after the time the stored procedure that opened the cursor was executed?
What are the basic features of a trigger in ms sql server?
What are the differences between clustered and non-clustered index?
What are tables in sql server?
what is the system function to get current user's user id? : Sql server database administration
What is read uncmmited?
What is the concept of optimization?
What are user defined functions in ms sql server?
What stored by the msdb?
What are the advantages of log shipping?
How will you optimize a stored procedure optimization?
How to add the custom code in Report?
What is use of @@ spid in sql server?