[dba-SQLServer] Storing sql in database and other stuff

jwcolby jwcolby at colbyconsulting.com
Mon Mar 24 15:21:54 CDT 2008


Guys, here is the deal.

I have a sequence of steps which need to be performed in an rather exact
order to get an order filled.  These steps include running a bunch of action
queries in a specific order.  At the moment I have built the queries and
have them stored in a directory but I KNOW that somehow I actually saved the
queries inside of my database one time.  I think maybe I saved them as
stored procedures though I am not sure.

So, I need to figure out how to save the queries inside of my database, then
I need to build a stored procedure to run all of these queries (or stored
procedures?) in order.  If I can accomplish that then building an order will
drop to an hour instead many hours.

So, how do I store the queries inside of a database?

John W. Colby
Colby Consulting
www.ColbyConsulting.com 




More information about the dba-SQLServer mailing list