Advantages and disadvantages of stored procedures.

Answers were Sorted based on User's Feedback



Advantages and disadvantages of stored procedures...

Answer / 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

Advantages and disadvantages of stored procedures...

Answer / suresh

yes

Is This Answer Correct ?    0 Yes 3 No

Post New Answer

More SQL Server Interview Questions

what exactly sql injuction.how to overcome.....

0 Answers   CTS, IBM,


What is split brain scenario in DB mirroring?

1 Answers  


You have a stored procedure, which execute a lengthy batch job. This stored procedure is called from a trigger you do not want to slow the data entry process you do not want trigger to wait for this batch job to finish before it completes itself what you can do to speed up the process?

0 Answers  


What is filtered index?

0 Answers  


What is auditing in sql server?

0 Answers  






What are different type of Collation Sensitivity?

0 Answers  


What is normalization? What number of normalization shapes are there?

0 Answers  


How do you maintain database integrity where deletions from one table will automatically cause deletions in another table?

0 Answers  


Where sql server user names and passwords are stored in sql server? : sql server database administration

0 Answers  


Give the query of getting last two records from the table in SQL SERVER?

0 Answers   Petranics Solutions,


Why do we use functions?

0 Answers  


What is the sql profiler?

0 Answers  


Categories