You can give a try on OUTPUT clause with Insert query,
INSERT INTO test (info,userid)
OUTPUT INSERTED.ID ---whatever the test table column name is
VALUES (@request_info,@request_user_id);
Please use Marked as Answer if my post solved your problem and use Vote As Helpful if a post was useful.
No comments:
Post a Comment