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 the steps to use transact-sql cursor?
what is a check constraint?
What do you mean by recursive stored procedure?
What is the openxml statement in sql server?
Write a SQL query to make a column as unique?
What is difference statement and preparedstatement?
How many full-text indexes can a table have?
What are partitioned views and distributed partitioned views?
Explain contrast amongst grouped and non-bunched records?
What is a non-clustered index?
Explain different types of Normalization.
How to create a view on an existing table in ms sql server?
Does full backup break log chain?
What is a view and what are its advantages?
Define the one-to-one relationship while designing tables.
