reducing network traffic.. user friendlyness.. no need to write queries e

What are the benefits of using stored procedures over sql
statements?

Question Posted / yudistara

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

Please Help Members By Posting Answers For Below Questions

Explain filtered indexes benefits?

989

Explain syntax for disabling triggers?

1021

What do you understand by sql server agent?

965

Define Unique Key?

984

How to create percentile function?

151

Write a SQL query to delete a table?

1116

Can we use where clause in union?

1043

What is spatial and temporal data?

975

What is nolock?

958

How to verify a login name with sqlcmd tool?

1194

How do I port a number to sql server?

1019

what is raid and what are different types of raid configurations? : Sql server database administration

1018

How optimize sql query with multiple joins in sql server?

872

What is a fan-out query in SQL Azure?

121

what is datawarehouse?

1095