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
What is sql injection and why is it a problem? : sql server security
How can sql server instances be hidden?
what is nonclustered index
Why is normalisation important?
When setting replication, is it possible to have a publisher as 64 bit sql server and distributor or subscribers as a 32 bit sql server?
What are trace flags and mention a few common trace flags used with sql server?
Do you know the isolation level that sql server support?
What is snapshot report?
How to find table changes in sql server?
hi i am working as a testengineer , so i want to no the backend data base connection can any one tell mwe in detail
How to delete existing triggers using "drop trigger"?
What is sql azure database?
What is nested transaction?
what is new philosophy for database devises for sql server 7.0? : Sql server database administration
What are click through reports?