CREATEPROCEDURE PROC_LOCALVAR --'1' (@V aS varchar(1)) AS DECLARE @SQL AS VARCHAR(MAX) DECLARE @LOCAL AS VARCHAR(20) SET @SQL='IF '+@V+'=1 BEGIN SET @LOCAL=''DIL'' END ELSE BEGIN SET @LOCAL=''DILN'' END ' PRINT(@SQL) EXEC(@SQL) SELECT @LOCAL
Must declare the scalar variable "@LOCAL".
var
This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)