set @sql="select @n=max(id) from example where id in (select top "+ str(@a) + " id from example order by id desc)"; exec sp_executesql @sql,N'@n int output',@m output
declare @a int; declare @sql Nvarchar(200); declare @m int;set @sql=N"select @r=max(id) from example where id in (select top "+ str(@a) + " id from example order by id desc)" exec SP_EXECUTESQL @sql,N'@r INT OUTPUT',@m
exec sp_executesql @sql,N'@n int output',@m output
declare @sql Nvarchar(200);
declare @m int;set @sql=N"select @r=max(id) from example where id in (select top "+ str(@a) + " id from example order by id desc)"
exec SP_EXECUTESQL @sql,N'@r INT OUTPUT',@m