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
hi i am working as a testengineer , so i want to no the backend data base connection can any one tell mwe in detail
What is Federation and Federation Member?
Explain an automatic checkpoint
Give me any three differences between Truncate and Delete.
Determine when an index is appropriate?
What is a covered index?
Mention what are the different types of ssrs reports?
After removing a table from database, what other related objects have to be dropped explicitly?
Detail about the hardware which is supported by SQL server?
What is the most common trace flags used with sql server?
Where are sql server user names and passwords stored in sql server?
What is dbcc?
What do we have to check in database testing?
Is ssrs support other database except ms sql server?
Can a table have 2 foreign keys?
