in reply to Re^3: Abstracting SQL without Stored Procedures
in thread Abstracting SQL without Stored Procedures

Frankly, it might even be best to store your queries in the database itself and pre-load them when the app starts up. *shrugs*
But if you do that - make sure that you actually keep the source to that information in operating system files, preferably under source control. Have the SQL specialist edit these files and load them to the data server as needed (and after thorough testing, of course).

Michael

  • Comment on Re^4: Abstracting SQL without Stored Procedures