Advantages and disadvantages of stored procedures.

Question Posted / narenukt

Answers were Sorted based on User's Feedback

Advantages and disadvantages of stored procedures...

The only disadvantage I see with Stored-procs is that we
cannot use them with select statements.

Is This Answer Correct ?

9 Yes

8 No

Advantages and disadvantages of stored procedures...

Answer / suresh

yes

Is This Answer Correct ?

0 Yes

3 No

More SQL Server Interview Questions

query processing

Which data type columns are the best candidates for full-text indexing?

What is Query Execution Plan? How does it help optimize or tune a database driven application?

What is a trigger?

What are the differences between INNER JOIN, LEFT JOIN and RIGHT JOIN in SQL Server?

Tell me what is the difference between locking and multi-versioning?

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

Does server sql treat char as a variable-length or fixed-length column?

What is user defined stored procedures?

What is full outer join in sql server joins?

What is an Index?

How to test a dml trigger in ms sql server?

For more SQL Server Interview Questions Click Here