Simply call test2 from test1 like:
EXEC test2 @newId, @prod, @desc;
Make sure to get @id using SCOPE_IDENTITY(), which gets the last identity value inserted into an identity column in the same scope:
SELECT @newId = SCOPE_IDENTITY()
Simply call test2 from test1 like:
EXEC test2 @newId, @prod, @desc;
Make sure to get @id using SCOPE_IDENTITY(), which gets the last identity value inserted into an identity column in the same scope:
SELECT @newId = SCOPE_IDENTITY()