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 can we delete Duplicate row in table?
What are sub reports?
Would you store your query in a ssrs report or a database server? State the reason why?
How to change the data type of an existing column with "alter table" statements in ms sql server?
What is instead of trigger sql server?
What does man by sql wildcard characters in sql server?
How to replace the Query Result 'Null Value' with a text ?
How to divide query output into multiple groups with the group by clause in ms sql server?
Explain the steps to use transact-sql cursor?
What do you understand by triggers and mention the different types of it?
Explain syntax for viewing, dropping and disabling triggers?
what authentication modes does sql server support? : Sql server database administration
What is query optimizer in sql server?
How to edit table in sql server 2017?
What are the risks of storing a hibernate-managed object in a cache? How do you overcome the problems?
