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 can you control the amount of free space in your index pages?
What is implicit cursors?
If you want to send some data from access database to sql server database. What are different component of ssis will you use?
What are parameterized reports?
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?
Do you know what is openxml in sql server?
Tell me what is use of except clause? How it differs from not in clause?
What are cursors stored procedures and triggers?
How to find Duplicate Records In table?
Any one plz send me SQL Server Developer/DBA resume for 4 years experience
how to avoid cursors? : Sql server database administration
What do you need to connect php to sql server?
How to create prepared statements using odbc_prepare()?
What is the use of @@spid?
How to insert new line characters into strings?
