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

What are the types of indexing?

1084

What is the definition for sql server 2000?

1091

What are page splits? : SQL Server Architecture

990

Explain why variables called the most powerful component of ssis?

1102

What are the 3 types of schema?

1111

What is the sql profiler?

942

What are views used for?

1015

How secure is sql server database?

1014

What is page in sql server?

948

How to set database to be single_user in ms sql server?

1030

Why we use trigger in sql server with example?

962

What are the different editions available in sql server 2000?

1052

What are the underflow and overflow behaviors on float literals?

1113

Write a query for primary key constraint with identity key word?

1031

Explain sql server authentication modes?

1134