The only disadvantage I see with Stored-procs is that we cannot use them w

Advantages and disadvantages of stored procedures.

Question Posted / manoj

Answer Posted / manoj

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

Please Help Members By Posting Answers For Below Questions

What is the difference between sql server 2000 object owner and sql server 2005 schema? : sql server database administration

982

What is the query and subquery?

1078

How to declare a cursor with "declare ... Cursor" in ms sql server?

1046

How do you create type- insensitive operator?

1043

What is the difference between an index and a unique index?

1000

How to get a list all databases on the sql server?

1099

List all the types of user-defined functions?

1099

How to manipulate data from one table to another table ?

969

What are the differences between ms sql server & oracle?

1060

What are “unrepeatable reads”?

1234

Please differentiate between a local and a global temporary table?

1007

Can I use sql azure as a backup with log shipping or database mirroring?

156

What are the commands used in DCL?

1026

What is Fragmentation and Defragmentation? For 32GB Table,How can we do the fragmentation?

4384

What is database mirroring?

1117