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 |
|
souLTower
Starting Member
39 Posts |
 Posted - 2004-05-20 : 10:15:14
|
| Good morning. I am updating an application. Some of the queries look like this...UPDATE TableA A JOIN Table B ONA.x = B.xSet A.y = B.y = myValueWHERE A.z = someValue;Is this valid SQL?Thank youGod Bless |
|
|
SamC
White Water Yakist
3467 Posts |
Posted - 2004-05-20 : 11:09:18
|
| No, Set @Variable = column = expressionis valid. You should write:Set A.y = myValue, B.y = myvalue |
 |
|
|
souLTower
Starting Member
39 Posts |
Posted - 2004-05-20 : 11:36:46
|
| Thank you very muchGod Bless |
|
|
|
|
|
|
SQL Query validation