Posted by cmay on 06/14/06 02:19

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?

• Next in forum: Re: Create Procedure in an IF block?
• Prev in forum: Re: Stored Procedure Issue - Problem with temporary tables
• Thread view: Create Procedure in an IF block?

[Reply to this message]