What are the advantages of using stored procedures? Please
don't simply say compilation time will be saved as they are
already complied. Please specify some other advantages.
Answers were Sorted based on User's Feedback
Answer / paras
If your database resides on one server and you are accessing
it from different place then using Stored Procedure reduces
network traffic because you are just passing its name and
few parameters (if any)across the network instead of long query.
Is This Answer Correct ? | 6 Yes | 0 No |
Answer / santosh kumar sharma
You can encapsulate your business logic in SP. Easy to
maintain as any changes in the business logic, you'll just
have to alter the SP and not your application.
Is This Answer Correct ? | 2 Yes | 0 No |
List the types of recovery model available in sql server?
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? : Sql server administration
Can a synonym name of a table be used instead of a table name in a select statement?
How can you list all the columns in a database?
What specific conditions database should meet, before you can bulk copy data into it using bcp?
What is key attribute?
What is ems sql management studio? : sql server management studio
Why I am getting this error when renaming a database in ms sql server?
What is the differecne between equi-join and inner-join and natural join..Is there any difference or all are same?
How to retrieve data from log files in SQL SERVER ?????
What are Magic Table?
34 Answers 3i Infotech, Digiweb, Evalueserve, NIIT, PL,
What does the on update no action do?