Advantages and disadvantages of stored procedures.
- 2 Answers
- 7394 Views
- HCL, I also Faced
- E-Mail Answers
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
Can you explain what is indexed view? How to create it?
What options are available to audit login activity? : sql server security
What is user defined stored procedures?
Explain the dbcc pintable command when would you use it?
What is the difference between stored procedure and functions?
How to rebuild the master database?
How you can find out if an index is useful to the optimizer?
What is cdc in sql server?
Can primary key be a foreign key?
How do I start sql server 2017?
Do you know what are the steps to process a single select statement?
What are the basic functions for master, msdb, model, tempdb and resource databases? : SQL Server Architecture
Describe the functionalities that views support.
Explain Reporting Life Cycle?
Can a stored procedure call itself or a recursive stored procedure? How many levels of sp nesting is possible?
