What are the advantages and disadvantages of using stored procedures versus calling SQL inline in Cold Fusion?

Submitted by: Administrator
Stored procedures abstract database logic from server side code. They also offer performance benefits in pushing application logic to the database side.

The disadvantage is that if they are poorly written then they can hinder database performance and make development a little more obfuscated.
Submitted by: Administrator

Read Online ColdFusion Job Interview Questions And Answers