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
Explain Normalization and DE normalization
What is SQL Server?
What xml support does the sql server extend?
How to add additional conditions in SQL?
Why do we use sql limitations? Which constraints can we use while making a database in sql?
What stored procedure can you use to display the current processes?
Does index slows down insert statements?
How to select an exiting database using mssql_select_db()?
What is sql injection? How to protect against sql injection attack?
is there a column to which a default can't be bound? : Sql server database administration
What will be the maximum number of indexes per table?
What is an indice?
How to add a new column to an existing table with "alter table ... Add" in ms sql server?
Why truncate is ddl command?
Explain system functions or built-in functions? What are different types of system functions?
