Re: Call Script from within a script
From: Louis Davidson (dr_dontspamme_sql_at_hotmail.com)
Date: 09/16/04
- Next message: Louis Davidson: "Re: Access to SQL Conversion IIF"
- Previous message: Adam Machanic: "Re: Access to SQL Conversion IIF"
- Maybe in reply to: Tibor Karaszi: "Re: Call Script from within a script"
- Messages sorted by: [ date ] [ thread ]
Date: Wed, 15 Sep 2004 20:11:28 -0400
Building stored procedures is the best way. Scripts are not known to SQL
Server. It is just a stream of characters coming in as batches that are
then executed.
What you might consider doing is to build your own script builder that you
use to precompile your scripts. Then send it to the query processor. It
wouldn't be too very hard to do, kind of a big replace operation.
-- ---------------------------------------------------------------------------- Louis Davidson (drsql@hotmail.com) Compass Technology Management Pro SQL Server 2000 Database Design http://www.apress.com/book/bookDisplay.html?bID=266 Note: Please reply to the newsgroups only unless you are interested in consulting services. All other replies will be ignored :) "Martin" <NO_SPAMdavid1234@yahoo.com> wrote in message news:uYN0PN3mEHA.2552@TK2MSFTNGP11.phx.gbl... > Hi, > > I have two scripts > > SCRIPT_A and SCRIPT_B > > I always have to run SCRIPT_A BEFORE SCRIPT_B, > > however I sometimes run SCRIPT_A independently > > rather than place all code from SCRIPT_A inside SCRIPT_B and I would just > like to have something like an include in SCRIPT_B that references SCRIPT_A. > > I guess what I am looking for is the ability to "#include" in TSQL or an > least run one script inside the other. > > cheers > > martin. > > >
- Next message: Louis Davidson: "Re: Access to SQL Conversion IIF"
- Previous message: Adam Machanic: "Re: Access to SQL Conversion IIF"
- Maybe in reply to: Tibor Karaszi: "Re: Call Script from within a script"
- Messages sorted by: [ date ] [ thread ]
Relevant Pages
|
