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 |
|
Lemmy44
Starting Member
20 Posts |
 Posted - 2005-03-31 : 10:09:10
|
| OK, I have a query that needs to be written that checks for the existence of two values, and if they do exist, one column in one table needs to be updated, and then another column in a different table needs to be updated as well.Is there a way to accomplish this in one query, or do I need to write two separate queries? Basically, can you run an update query on two different tables at the same time?Thanks. |
|
|
X002548
Not Just a Number
15586 Posts |
Posted - 2005-03-31 : 10:11:50
|
| 2 updates, or 1 update and 1 trigger (which will have another update anyway)Brett8-) |
 |
|
|
|
|
|
Updating Two Tables