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

When setting replication, is it possible to have a publisher as 64 bit sql server and distributor or subscribers as a 32 bit sql server?

can you any body tell me which service pack is installed in the sql server?

What is the difference between clustered and non-clustered indexes in ms sql server?

‘Order by’ is not allowed in a view how can you sort information from a view?

What are the disadvantages of using querystrings to send data from one page to another?

What do you mean by authentication modes in sql server?

How to transfer data from a cursor to variables with a "fetch" statement?

How to how to convert numeric expression data types using the convert() function??

Explain identity in sql server?

What are the difference between primary key and unique key? : sql server database administration

How to create new table with "create table" statements?

When do u use clustered index and non-clustered index?

For more SQL Server Interview Questions Click Here