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 different acid properties?

628

Why is sql server log file full?

540

What is 5nf in normalization form?

576

Write a sql query to get zero records from a table having n number of records?

709

Define views.

596

Suppose you want to implement the one-to-many relationships while designing tables. How would you do it?

509

Tell me time data type, datetime2, datetimeoffset data type in sql server 2008?

573

Explain the different types of joins?

574

What is proper subset of candidate key?

561

How do I find my localdb version?

498

Explain what is lock escalation?

579

What is logon trigger?

551

Does transparent data encryption provide encryption when transmitting data across the network?

630

What the class forname () does?

547

What are the general features of sql server management studio? : sql server management studio

599