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?
How to add code to the existing article (using improve article)?
How do you migrate data from mssql server to azure?
What are the advantages of using cte?
What is the sql server 2000 version number?
Explain important index characteristics?
List some of the rules that apply to creating and using a ‘view’
What is the default sql server instance name?
what is the maximum size of a row? : Sql server database administration
What is ms sql server service broker?
What causes index fragmentation?
What is user-defined multi-statement table-valued function?
Tell me about joins in database system and explain each in detail.
What is difference between inner join and full join?
What is implicit mode in sql server?
