Insert a Join Statement - (Insert Data to Multiple Tables) - C#/SQL/T-SQL/.NET
Posted
by peace
on Stack Overflow
See other posts from Stack Overflow
or by peace
Published on 2010-05-20T20:35:20Z
Indexed on
2010/05/20
20:40 UTC
Read the original article
Hit count: 263
I have a Winform that has fields need to be filled by a user. All the fields doesn't belong to one table, the data will go to Customer table and CustomerPhone table, so i decided to do multiple inserts. I will insert appropriate data to CustomerPhone first then Insert the rest data to Customer table.
Is it possible to Join an Insert OR Insert a Join? If show me a rough sample, i will be grateful.
Many Thanks
© Stack Overflow or respective owner