title: One Stored Procedure to insert one table and retrieve ID and insert multiple tables
body: <p>I have 3 tables and columns. ex: Green (userID, Name, Address), Red (userID, TemproraryAddress), Blue (userID, WorkPlace).</p>
  
  <p>I want to insert data into Green while userID is auto incremented int and unique id. After inserting those details want to retrieve userID and insert into Red and Blue Tables in one stored procedure</p>
  
  <p>Note: This example table is to show a sample scenario, not for real world usage...</p>