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 specific conditions database should meet, before you can bulk copy data into it using bcp?
What is Fragmentation and Defragmentation? For 32GB Table,How can we do the fragmentation?
What is a mixed extent?
Where sql server usernames and passwords are stored in a sql server?
Is sql server implemented as a service or an application? : Sql server database administration
Where the sql logs gets stored?
Is sql server free?
Does order by actually change the order of the data in the tables or does it just change the output?
Sql server reporting services vs. Crystal reports.
What is a heap?
Explain DBCC?
What are the events recorded in a transaction log?
How to apply cascading referential integrity in place of triggers?
How many clustered indexes can be created on a table? I create a separate index on each column of a table. what are the advantages and disadvantages of this approach?
What is cursor in ms sql server?
