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 is difference between sql and sql server?

688


Explain “not null constraint” in sql server?

719


what is a self join? : Sql server database administration

686


How does using a separate hard drive for several database objects improves performance right away?

695


but what if you have to create a database with two filegroups, one on drive c and the other on drive d with log on drive e with an initial size of 600 mb and with a growth factor of 15%? : Sql server database administration

717






What do you understand by physical_only option in dbcc checkdb?

743


What are the advantages of having an index on the sql server?

681


What is the difference between stored procedure and user defined functions?

846


How many replicas are maintained for each SQL Azure database?

138


Can you import Microsoft Excel data to SSRS?

111


Why do we need normalization?

656


How to find the service pack installed? : sql server database administration

762


Relational calculus is what type of language?

778


Explain filtered indexes benefits?

768


What is indexed view?

746