OutPut Stored Procedure !!

CREATE procedure guest_regi
@memname varchar(50),
@mememail varchar(50),
@memphone varchar(50),
@memregtype varchar(50),
@memactive int,
@gid int output
as
insert into tblmemregistration
(
memname,
mememail,
memphone,
memregtype,
memactive
)

values
(
@memname,
@mememail,
@memphone,
@memregtype,
@memactive
)

select @gid=@@IDENTITY


GO