Interested to Buy Any Domain ? << Click Here >> for more details...
What are the benefits of using stored procedures over sql
statements?
- 3 Answers
- 8157 Views
- Ness Technologies, I also Faced
- E-Mail Answers
Answer Posted / yudistara
reducing network traffic..
user friendlyness..
no need to write queries every time..
sp help to improve perfrmance
| Is This Answer Correct ? | 5 Yes | 1 No |
Post New Answer View All Answers
How do I start and stop sql server?
What is a rownum?
What are key constraints?
You notice that the transaction log on one of your databases is over 4gb the size of the data file is 2mb what could cause this situation, and how can you fix it?
How to insert a new row into a table with "insert into" statements in ms sql server?
What is “begin trans”, “commit tran”, “rollback tran” and “savetran”?
What is update locks?
What are the events recorded in a transaction log?
Explain partitioned view?
What are scalar functions in sql?
What is a subquery in a select query statement in ms sql server?
What are types of subqueries?
What the difference between UNION and UNIONALL?
How you can move data or databases between servers and databases in sql server?
What is the difference between varchar and nvarchar datatypes?
