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: 258

Filed under:
|
|
|
|

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

Related posts about sql-server

Related posts about tsql