Merit & demerit of Stored Procedure | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive

Merit & demerit of Stored Procedure

Hi Guys,
Recently I have faced an interview where I am asked about the merits and demerits of Stored Procedured. I am aware of merits of stored proceure but not know what are the demerits or pitfalls of stored procedure. Can you please update regarding this. Best Regards,
Papak Mondal…1/wa/supportPage?currentPage=Faqs&faqKindId=1 Madhivanan Failing to plan is Planning to fail
Yes I got the answer. Thank you very much. Best Regards,
Papak Mondal