1-) MSSQL RMOS - exec ile dışarıya veri aktarma top 1 return value

declare @sql nvarchar(4000)= '',@type int

set @sql = 'SELECT TOP 1 @type= Rez_Id FROM RmosFront.dbo.Rez where Rez_Id=1'

exec sp_executesql @sql,N'@type int output',@type = @type output

select @type as Rez_Id