|
Posted by ITBurns on 06/14/06 04:02
cmay wrote:
> 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?
If your procedure is not too complex to declare in a string, you could
create a variable that includes the CREATE PROCEDURE command and then
execute it with sp_executesql:
IF (1=1)
BEGIN
DECLARE @sql nvarchar(1000)
SET @sql = 'CREATE PROCEDURE Whatever
AS
SELECT 1 as one'
EXEC sp_executesql @sql
END
Navigation:
[Reply to this message]
|