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
sql database suspect We have a sql database that is showing as suspect. How can we recover?
How to drop existing views from a database in ms sql server?
What are recommended options to be used while using db mirroring? : sql server database administration
Why are you getting errors when creating a new odbc dsn?
What is the cartesian product of the table?
What are various limitations of the views?
How do you manipulate data?
What is difference between count (*) and count column?
How can you check the version of sql server?
What are the types of subquery?
Difference between Inner vs outer joins?
what is dbcc? : Sql server database administration
Explain system views?
What is the difference between the export /import functions in sql studio and standalone sql manager? : sql server management studio
What are sub reports?
