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 to create an inline table-valued function?
What are parameterized reports?
How to get a list of table columns using the "sp_columns" stored procedure in ms sql server?
What is log shipping? Can we do logshipping with SQL Server 7.0 ?
How to create a simple user defined function in ms sql server?
What are the commands used in DCL?
How to invoke a trigger on demand?
Where are stored procedures in sql server?
How do I find my localdb version?
How to list all dsn entries on your local machine using odbc_data_source()?
Define views.
but what if you have to create a database with two filegroups, one on drive c and the other on drive d with log on drive e with an initial size of 600 mb and with a growth factor of 15%? : Sql server database administration
What is normalization of database? What are its benefits?
Why do we backup Active Directory ?
What is the difference between NOROW and LOCKROW?
