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
How to update a field in SQL after ALTERING a row?
What is difference between rownum and row_number?
What is 'write-ahead log' in sql server 2000 ?
what is a traditional network library for sql servers? : Sql server database administration
How to concatenate two character strings together?
What extended events?
What do you understand by intent locks?
Explain what are the database objects? : SQL Server Architecture
Write a Select Query to display title for each group of records, which are collected with Compute Clause? Like titlefield column-A column-B ..... ..... ..... Sum ... titlefield column-A column-B ..... ..... ..... Sum ...
Write an sql query to find first weekday of the month?
What is join query?
Can truncate be rolled back?
Explain what role entity and relationship play in an ER diagram.
How to find which stored procedure is currently running in sql server?
What are the differences between ms sql server & oracle?