Dynamic Stored Procedure with output

hi ruchi,

 

you do like this 

 

DECLARE @Sql varchar(500)
SET @Sql='SELECT @Id=Id FROM tablname'
EXECUTE sp_executesql @Sql, N'@Id varchar(50) OUTPUT', @id=@Id OUTPUT