What's the purpose of Stored Procedure?

Answer Posted / koti khammam

It will reduce the network traffic between client and
server so that the number of calls between client and
server are reduced.
It's an performance issue.

Is This Answer Correct ?    23 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the 10 characteristics of data quality?

525


Difference between uniqe index and uniqe constraint?

536


Differentiate between SQL and ORACLE joins and write their syntax.

583


What is filestream?

554


What do you mean by SQL injection attack?

609






When we should use and scope of @@identity?

537


What is the use of attributehierarchyvisible ? : sql server analysis services, ssas

565


Different types of keys in SQL?

620


Are there issues when exporting SSRS reports into Microsoft Excel? When my users are trying to export a SSRS report into Microsoft Excel, one or two columns in the report appear to merge together. Why might this be?

134


what are the new features introduced in sql server 2000? : Sql server database administration

543


What is the user of Primary key?

576


How to create a simple user defined function in ms sql server?

539


What information is maintained within the msdb database?

536


What is primary key and example?

499


If user is owning any SQL Objects, can we drop that user

1601