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
how we use window authentication connection with sql server.?
What are out-of-range errors with date and time literals?
What is the significance of null value and why should we avoid permitting null values?
Will the writetext statement activate a trigger?
What are the two modes of authentication in sql server?
How can you control the amount of free space in your index pages?
What is mean by clustered index and non clustered index, give syntax of creation? : sql server database administration
Explain a differential backup?
Differentiate between ms sql server reporting services vs crystal reports?
Can you explain important index characteristics?
Why normalization is used?
List the ways in which dynamic sql can be executed?
Can we deploy SSRS reports on our personal website?
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 is the use of sql profiler in sql server 2012?
