Posted by cmay on 10/02/44 11:50

I am using a Code Generation program that creates a script for the
necessary stored procedures.

I guess I could put them in a big string, but I would have to make sure
I escaped all my single quotes.




Erland Sommarskog wrote:
> cmay (cmay@walshgroup.com) writes:
> > I am writing some code generation stuff and I am trying to get a script
> > like this to work:
> >
> > IF (something)
> > BEGIN
> > CREATE PROCEDURE Whatever
> > AS
> > SELECT 1 as one
> > END
> >
> >
> > But it complains about this, so I am guessing that I can't put the
> > create prodcedure in an IF block.
> >
> > Does anyone know of a work around for this?
>
> What is the real purpose of this? Using T-SQL to generate code sounds
> utterly painful to me. As pointed out in another post, you would have to
> use dynamic SQL, but only do this if you like to hurt yourself.
>
> If the purpose is simply to write an installation script, I recommend that
> you write the installation script in a client language: Perl, VB, VBscript
> or whatever.
>
> For more information on dynamic SQL, see
> http://www.sommarskog.se/dynamic_sql.html.
>
>
>
> --
> Erland Sommarskog, SQL Server MVP, esquel@sommarskog.se
>
> Books Online for SQL Server 2005 at
> http://www.microsoft.com/technet/prodtechnol/sql/2005/downloads/books.mspx
> Books Online for SQL Server 2000 at
> http://www.microsoft.com/sql/prodinfo/previousversions/books.mspx

• Next in forum: Re: Create Procedure in an IF block?
• Prev in forum: knowing which jobs/dts/SSIS affect which tables
• Thread view: Re: Create Procedure in an IF block?

[Reply to this message]