exemple: create proc test @id int out as set @id=2 go Get declare @id int exec test @id outselect @id