Answer Posted / dharmendra k. dixit
An Stored Procedure is basically a set of T-SQL Statement,
it hv lot of benifits thats y we are using SPs.
Some are the advantages of Stored Procedures.
1. it reduses the Network Traffic.
2. we can execute SP inside SP.
3. it takes slower time in execution bcz its a
preCompiled statement.
4. create once and can use multiple times.
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
how to avoid cursors? : Sql server database administration
What is the difference between Clustered and Non-Clustered Index?
Define Business Edition in SQL Azure?
Explain how to integrate the ssrs reports in application?
In which tcp/ip port does sql server run? Can it be changed?
How do I run a trace in sql server?
How to find the second highest salary of an employee?
What is the purpose of optimization?
Can you use order by when defining a view?
Can we insert data if clustered index is disabled?
What is the use of for clause?
What are ddl (data definition language) statements for tables in ms sql server?
What are joins in sql and what are the different types of joins?
you have developed an application which uses many stored procedures and triggers to update various tables users ocassionally get locking problems which tool is best suited to help you diagnose the problem? : Sql server administration
List types of tables in SQL Azure?