exec stored proc -- return record id?

[texas]

how do you return a record number once you insert data into a sql table?

[mendhak]

SELECT @@IDENTITY will get you the id value inserted. You could return it in an OUTPUT parameter.

[texas]

what is an OUTPUT parameter?

this is what i came up with....?

create  procedure [p_save_new]  @sheetname varchar(1000), @sheetdata text, @categoryid int, @username nvarchar(50) as
insert into tblcheatsheet
(sheetname, sheetdata,categoryid,active)
values (@sheetname, @sheetdata, @categoryid  , '1')

insert into tblWhoWhen
values(@@IDENTITY , @username, Getdate())

[mendhak]

create procedure [p_save_new] @sheetname varchar(1000), @sheetdata text, @categoryid int, @username nvarchar(50), @ReturnValue INT OUTPUT as

insert into tblcheatsheet
(sheetname, sheetdata,categoryid,active)
values (@sheetname, @sheetdata, @categoryid , '1')

SELECT @ReturnValue = @@IDENTITY FROM tblcheatsheet

insert into tblWhoWhen
values(@ReturnValue , @username, Getdate())

[texas]

what was wrong with the way i was doing it?