Interested to Buy Any Domain ? << Click Here >> for more details...
Answer Posted / dharmendra k. dixit
An Stored Procedure is basically a set of T-SQL Statement,
it hv lot of benifits thats y we are using SPs.
Some are the advantages of Stored Procedures.
1. it reduses the Network Traffic.
2. we can execute SP inside SP.
3. it takes slower time in execution bcz its a
preCompiled statement.
4. create once and can use multiple times.
| Is This Answer Correct ? | 5 Yes | 0 No |
Post New Answer View All Answers
What is a field name?
How to use go command in "sqlcmd"?
What is the simplest way to create a new database in ms sql server?
What is the size of transaction log file?
Explain filestream storage of sql server 2008?
explain what are the steps you will take, if you are tasked with securing an sql server? : Sql server database administration
What is a linked server in sql server?
How to list all columns in a table using odbc_columns()?
Find columns used in stored procedure?
How can we determine what objects a user-defined function depends upon?
What is a cube? : sql server analysis services, ssas
What is the difference between seek predicate and predicate?
Define the one-to-one relationship while designing tables.
What is "scheduled jobs" or "scheduled tasks"?
How do users use Report Builder with SQL Server data sources?
