Stored Procedures, Dynamic SQL or static SQL and testing.

Hi. What preferences do you all have when using SQL. Stored Procedures or PHP generated dynamic SQL or parameterized static SQL. Whichever you use how do you test them? Do you use unit testing in your PHP code? If so, do you also have unit code testing for the SQL statements (I suppose this mainly relates to SPs). Does using a different RDBMS make a difference to the SQL coding style you'd use? This isn't for any sort of thesis, just trying to see what the general consensus is of those that reply. Thanks for answering. Richard Quadling. -- Richard Quadling Twitter : EE : Zend @RQuadling : e-e.com/M_248814.html : bit.ly/9O8vFY