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 to create view in stored procedure sql server?
Explain system scalar functions?
Please explain go command in sql server?
What is a periodical index?
Explain transaction isolation levels in sql server?
What is the stuff?
What methods do you follow to protect from sql injection attack?
How many types of triggers in sql server?
What is the difference RDBMS and Graph Database?
Write SQL queries on Self Join and Inner Join.
How do I create a partition table in sql server?
What is index in an assignment?
Write an sql query to sort a table according to the amounts in a row and find the second largest amount.
what are the Prerequisites for Replication?
What is purpose of normalization?