동적 쿼리

declare @SQL as nvarchar(100)
declare @parmas as nvarchar(100)
declare @output as int

set @SQL = 'select @ordercnt = count(*) from Table'
set params = '@ordercnt as int OUTPUT'
exec sp_excutesql @SQL, @params, @ordercnt = @output OUTPUT
select @output