동적쿼리 값 반환

DECLARE @IntVariable    INT;
DECLARE @SQLString NVARCHAR(500);
DECLARE @ParamDefinition    NVARCHAR(500);
DECLARE @max_title    VARCHAR(30);

SET @IntVariable = 197;
SET @SQLString = N'SELECT @max_titleOUT = max(JobTitle) FROM AdventureWorks.HumanResources.Employee
                            WHERE BusinessEntityID = @level';
SET @ParamDefinition = N'@level tinyint, @max_titleOUT varchar(30) OUTPUT';
EXECUTE sp_executesql @SQLString, @ParamDefinition, @level = @IntVariable, @max_titleOUT = @max_title OUTPUT;
SELECT @max_title;