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
Indexes are updated automatically is the full-text index also updated automatically?
Explain go command in sql server?
you have a table with close to 100 million records recently, a huge amount of this data was updated now, various queries against this table have slowed down considerably what is the quickest option to remedy the situation? : Sql server administration
What is a non-clustered index?
What is a unique key constraint?
What is the difference between SQL notification and SQL invalidation?
How you can minimize the deadlock situation?
Does a full backup include transaction log?
What is the use of partition by in sql server?
What are the differences between user defined functions and stored procedures?
What are the differences between left join and inner join in sql server?
What are the hotfixes and patches in sql server?
What is the difference between coalesce() & isnull()?
What the class forname () does?
What are the steps you should follow to start sql server in single-user mode?
