Tech
Forums
Jobs
Books
Events
Live
Interviews
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
7
Reply
imaginary dought in sql joins
aditya immadi
Nov 3 2016 8:22 AM
372
Reply
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
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
7
)
Next Recommended Forum
Advantage of view
Query to import table from access database to sql database