MS-SQL: Add an output parameter at your select statement. After the insert statement you fill the parameter with the Id from scope_identity () function.insert into table_test (....) VALUES (...);set @id= ...

MS-SQL: Add an output parameter at your select statement. After the insert statement you fill the parameter with the Id from scope_identity () function.insert into table_test (....) VALUES (...);set @id= ...

Luis

Could you kindly give an example how you could get @id parameter as an output parameter

Thanks