一键计算所有属性值
update DLTB set [TBMJ]=0;
update DLTB set [KCDLBM]='';
update DLTB set [KCXS]=0.0;
update DLTB set [KCMJ]=0.0;
update DLTB set [TBDLMJ]=0.0;
update DLTB set [GDLX]='';
update DLTB set [TBXHMC]='';
update DLTB set [ZZSXMC]='';
update DLTB set [FRDBS]='0';
update DLTB set [SJNF]=2019;
update DLTB set [MSSM]='00';
update DLTB set [BZ]='';
update DLTB set [GDPDJB]='' where [DLBM] not like '01*';
update DLTB set [KCDLBM]='1203' where [DLBM] like '01*' and [GDPDJB] in ('2','3','4','5');
update DLTB set [GDLX]='PD' where [DLBM] in ('0102','0103') and [GDPDJB] in ('2','3','4','5');
update DLTB set [GDLX]='TT' where [DLBM] ='0101' and [GDPDJB] in ('2','3','4','5');
update DLTB set [XZDWKD]=0.0 where [DLBM] not in
( '1001','1002','1003','1004','1006','1009','1107','1107A','1107a','1101');
update DLTB set [GDDB]=1 where [DLBM] like '01*';
update DLTB set [GDDB]=0 where [DLBM] not like '01*';
update DLTB set [DLMC]='物流仓储用地' where [DLBM]='0508';
update DLTB set [DLMC]='商业服务业设施用地' where [DLBM]='05H1';
update DLTB set [DLMC]='工业用地' where [DLBM]='0601';
update DLTB set [DLMC]='采矿用地' where [DLBM]='0602';
update DLTB set [DLMC]='盐田' where [DLBM]='0603';
update DLTB set [DLMC]='城镇住宅用地' where [DLBM]='0701';
update DLTB set [DLMC]='农村宅基地' where [DLBM]='0702';
update DLTB set [DLMC]='公用设施用地' where [DLBM]='0809';
update DLTB set [DLMC]='公园与绿地' where [DLBM]='0810';
update DLTB set [DLMC]='广场用地' where [DLBM]='0810A';
update DLTB set [DLMC]='机关团体新闻出版用地' where [DLBM]='08H1';
update DLTB set [DLMC]='科教文卫用地' where [DLBM]='08H2';
update DLTB set [DLMC]='高教用地' where [DLBM]='08H2A';
update DLTB set [DLMC]='特殊用地' where [DLBM]='09';
update DLTB set [DLMC]='铁路用地' where [DLBM]='1001';
update DLTB set [DLMC]='轨道交通用地' where [DLBM]='1002';
update DLTB set [DLMC]='公路用地' where [DLBM]='1003';
update DLTB set [DLMC]='城镇村道路用地' where [DLBM]='1004';
update DLTB set [DLMC]='交通服务场站用地' where [DLBM]='1005';
update DLTB set [DLMC]='机场用地' where [DLBM]='1007';
update DLTB set [DLMC]='港口码头用地' where [DLBM]='1008';
update DLTB set [DLMC]='管道运输用地' where [DLBM]='1009';
评论0