A SQL statement to modify the information of multiple tables and multiple fields _mssql

Before modifying two and above tables, it is necessary to use a few statements to modify, in case one of them is not modified, and there is no transaction mechanism, processing is very troublesome, so think can a statement complete?

The result is successful ~ ~

Multiple table multiple fields, you have to use the table associated with the way to modify the information:

Copy Code code as follows:

UPDATE ' user ' join ' binding ' on ' user '. ' uid ' = ' binding '. ' UID '
SET ' user '. ' Renren ' = ', ' binding '. ' Renren_token ' = ', ' binding '. ' Rt_time ' = '
WHERE ' user '. ' uid ' = '. $in [' uid '];

Syntax is similar to what is indicated above.

There is no better way to solve the problem, but still need to study further