Storing and running a sql script in the database.

From: Terrian, Thomas J Mr CTR DLA J6DIB <>
Date: Fri, 3 Apr 2009 12:52:16 -0400
Message-ID: <B538F62DA0448741B308EA69417CC30201462A2F_at_COL1SMX19.USE.AD.DLA.MIL>

I have a simple sql script that selects from a couple of tables. What I would like to do is store the script in the database and run it from there. For example, instead of _at_test.sql going to the O/S to find test.sql, I want it to find the script in the database somewhere. Does anyone know how to do this?

I know I can rewrite it into a stored procedure but I would rather just leave it as a sql script.....any ideas?

Tom Terrian  

Received on Fri Apr 03 2009 - 11:52:16 CDT

Original text of this message