@@Identity

create proc proc_sample

@caption varchar(20)=null,
@proid int,
@milestonename varchar(50)=null,
@name varchar(20)=null,
@abcname varchar(30)=null,
@date date

as 
begin

insert into tbl_promaster(milestonename,name,date)

values (@milestonename,name,varchar)

//Here proid will be generated..., i want  to insert this proid in next  table how to do this explain this scenario..., pls 

@@identity=@proid


insert into tbl_abc(proid,abcname)

values(@proid,'Pradeep')

thanks in advance




end