Advantages and disadvantages of stored procedures.

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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How to download and install sql server 2005 books online?

541


How do we upgrade from SQL Server 6.5 to 7.0 and 7.0 to 2000?

1633


What are the properties of the transaction?

549


What happens if null values are involved in boolean operations?

557


What is the difference function and stored procedure?

565






what is a self join? Explain it with an example? : Sql server database administration

499


Write a SQL query to delete a table?

655


What is the difference between implicit and explicit transaction?

566


What is named calculation? : sql server analysis services, ssas

531


Explain differentiate between a having clause and a where clause?

519


What stored by the model? : sql server database administration

547


To automatically record the time on which the data was modified in a table, which data type should you choose for the column?

533


What is purpose of normalization?

527


explain databases and sql server databases architecture? : Sql server database administration

522


How to change the password of a login name in ms sql server?

561