7
Reply

imaginary dought in sql joins

aditya immadi

aditya immadi

Nov 3 2016 8:22 AM
361
Hi
 
i have small dought .if im inserting record into DB (record may have multple values) and record will be inserted into 2 tables .in first table after record insertion i need  to capture ID which is recently incremented (first table ID has Identity) .and i need to insert that value into second table in same time.is it possible without single join query .or without joins (which one is best).and i would like to done this in single code block execution.any leads
 
Thanks and Regards 

Answers (7)