BizTalk Server General - SQL question

Author

SQL question

Brian C

2005-01-31, 5:53 pm

The first step of an orchestration calls this stored proc (see SQL below).
What it does is pass in a filename, inserts the filename and creates an ID
field that is auto-generated by the table. The stored proc passed the ID
back... now how do I get access to this ID?

Thanks in advance, Brian

create procedure usp_create_billing_file
@file_name varchar(50),
@file_id int out
as
begin
insert into BILLING_FILE (billing_file_name) values(@file_name);
set @file_id = @@identity
end