|
Posted by Stu on 06/14/06 03:39
It's generally not a good idea to dynamically create stored procedures;
why are you trying to do that? Perhpas there's a better way to solve
the problem you're trying to do.
Stu
cmay wrote:
> 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?
Navigation:
[Reply to this message]
|