Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
AskSQLTeam
Ask SQLTeam Question
0 Posts |
 Posted - 2001-04-26 : 12:53:41
|
Ben writes "I need to insert/update two separate tables with one SQL statement. Can this be done?
For example, a location (city, state_province, country) needs to be stored in two separate tables where they both have some common fields and others (i.e. pk fields) that are not.
Is it possible to write one SQL statement that can insert or update two tables?" |
|
|
|
|
|
Multiple Table Inserts with one SQL statement