关于UPDATE的问题
在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中如何实现这样的更新呢？

------解决方案--------------------
要换成类似：
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) 


这种才行
------解决方案--------------------

SQL code

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)

------解决方案--------------------
SQL code


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%'