Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / peter nguyen
Stored procedures are a set of control flow SQL queries.
Main advantage of stored procedure: it is a precompiled
statement, hence:
Some advantages of Stored Procedures are:
1. It reduces the Network Traffic.
2. We can execute standard procedure inside standard
procedure
3. Execution faster because it’s a precompiled statement.
4. Create once and may re-use multiple times.
| Is This Answer Correct ? | 3 Yes | 1 No |
Post New Answer View All Answers
How many tables can be joined in SQL Server?
What types of Joins are possible with Sql Server?
What is acid properties?
What are the components of sql server service broker?
What are the main sources of data?
Explain the various types of concurrency problem. I.e. Lost or buried updates, uncommitted dependency, inconsistent analysis, phantom read?
What is save transaction and save point?
what are the three command line utilities and what are their primary functions?
What are the advantages of the mirroring?
What is indexing and its types?
Explain sql delete command?
what are the basic functions for master, msdb, model, tempdb and resource system databases? : sql server database administration
What is blocking and how would you troubleshoot it? : sql server database administration
What is the full meaning of dml?
Explain primary key in sql server?
