关于UPDATE的问题

Question

在ORACLE中可以这样UPDATE：
UPDATE land 
            SET (land_number, district_code, street_code, block_code,
                 land_numerator, land_denominator, land_name, rw_code,
                 land_rights, land_use_desc, land_grade, area_cert,
                 area_survey, farmland_state, right_state, geo_state, state,
                 state_date, land_type, arcid, note, start_date,
                 data_state, districtid, approval_number, ref_x, ref_y,
                 POSITION, begin_depth, end_depth, case_number) =
                   (SELECT a.land_number, a.district_code, a.street_code,
                           a.block_code, a.land_numerator, a.land_denominator,
                           a.land_name, a.rw_code, a.land_rights,
                           a.land_use_desc, a.land_grade, a.area_cert,
                           a.area_survey, a.farmland_state, a.right_state,
                           a.geo_state, a.state, a.state_date, a.land_type,
                           a.land_number, a.note, a.start_date, a.data_state,
                           a.districtid, a.approval_number, a.ref_x, a.ref_y,
                           a.POSITION, a.begin_depth, a.end_depth,
                           a.case_number
                      FROM imp_land a, tmp_land b
                     WHERE a.case_number = incase_number
                       AND b.att_mod = 1
                       AND b.big_land_id = land.land_id
                       AND b.land_id = a.land_id)SQLServer中如何实现这样的更新呢？

Answer 1

要换成类似：
UPDATE land  
            SET land_number=a.land_number, district_code=a.district_code  FROM imp_land a, tmp_land b 
                     WHERE a.case_number = incase_number 
                       AND b.att_mod = 1 
                       AND b.big_land_id = land.land_id 
                       AND b.land_id = a.land_id) 
这种才行

Answer 2

update land  
set 'land.*'='ab.*'
from imp_land a, tmp_land b  
WHERE a.case_number = incase_number  
AND b.att_mod = 1  
AND b.big_land_id = land.land_id  
AND b.land_id = a.land_id)  

Answer 3

SQL Server使用的是T-SQL，Oracle使用的是PL/SQL，用法上相差很大。SQL Server 不支持楼主的这种做法。update更新格式类似如下：
update 表A
  set 
     f1 = t2.f1,
     f2 = t2.f2,
     f3 = t2.f3
from 表A as t1
    inner join 表B as t2 on t1.id=t.id
where t1.name like 'sss%'