Hi ,
Check this
<br />
use Scope_Identity() or @@idetity
also check on @@Error if any error happen
Create proc usp_name
( @name varchar(30),@gard int)
as
begin
declare @id int
insert into FirstTable
(name)
values
(@name)
set @id = @@identity
insert into Secondtable
(stid , grade)
value
(@id , @grade
end
Best Regards
M.Mitwalli