Hello, I'm new to procedures and I have a question I did not find on the internet.
I need to create a procedure to include 2 tables: "User", "Supplier".
The provider has a user FK, that is, in this procedure, I need to insert a user, get the id of that user and insert a provider with the Fk of the user that was created.
How can I do this?
Thank you in advance ...