SQLServer(sqlupdate多表更新方法)

1.首先，創建兩個表
。SQL語句如下:
users:
create table users
(
idbigint，
departidbigint，
name text
]
department:(department table)
create table department
(
idbigint，
departnametext
)[/br/
)2 .insert data
users:(用戶表)
insert into users (id，departid，name)值(1，1，' a')
insert into users (id，departid，name)值。B')
insert into users (id，departid，name)值(3，3，' c ')
department:(department表)
insert into department (id，departname)值(1，B ')
insert into department(id，departname)值(2，' c')
3 .插入後可以選擇，檢查結果
select * from users
select * from department
4。Update語句:
A .將users表中名稱爲A、部門名稱爲B的用戶更新爲G.
-Examda提示錯誤:此処更新所有users表信息，可與下麪的sql進行比較。發自後有用戶u，所以衹要where爲真，所有用戶都會更新。
update Users set name = ' g ' from Users u，departd where u . departid = d . id and d . departname = ' b ' and u . name = ' a '
-correct
Users u set name = ' g ' from departd where u . departid = d . id and d . departname = ' b ' and u . name = ' a '
-correct
update Users set name = ' k ' where departid = ' select d users where u . departid = d . id and d . departname = ' b ' and u . name = ' a ')
數據恢複SQL
update users set name = ' a ' where id = 1
update users set name = ' b ' where id = 2
update users set name = ' c ' where id = 3

位律師廻複