Posted by Erland Sommarskog on 10/02/63 11:50

cmay (cmay@walshgroup.com) writes:
> 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.

Ah, if you are using some program to generate the input script, putting
the CREATE PROCEDURE in dynamic SQL is a fair game. Of course you need
to double all the single quotes, and if the procedure itself employs
dynamic SQL, the result can be about unreadable. But as long as the result
is not meant to be read - who cares?

--
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: out of order identity field - sql2000
• Prev in forum: Re: Create Procedure in an IF block?
• Thread view: Re: Create Procedure in an IF block?

[Reply to this message]