Sql语句大全--更新

今天抽空整理下项目中的Sql语句

Update 语句

Update语句
  update   OLASF1.LLB set CBBTHCC= '52' WHERE CBPOLNUM='C201728534'
  update   OLASF1.LLB set CBBTHCC= '01' WHERE CBPOLNUM='C201728534'
  update   OLASF1.LB set CBBTHCC= '01' WHERE CBPOLNUM='C201728534'
1
2
3
4

update NCSUF1.CSM3 set RCPTID='101101617',SUBOFF='',PMTYPE='S',KEYDTE='20221108', MRGTIM='11150500',MRGDTE='20221108'where POLNUM  in('H101101617','')
1

update  olaf1.lc set CCSITU1 = 'C2' where ccagent1 in ('10950') and CCPOLNUM in ('H99910')
'S59875')
1
2

update OLUF1.LCA set CAPDTOYY= '23',CAPDTOMM='03', CAPDTODD = '22' where CAPOLNUM = 'C100739'
update OLAUF1.LLA setSUBYY= '12',CASUBMM='03', CASUBDD = '22' where CAPOLNUM = 'C10739'
1
2

update  COAUF1.NLICY set filler3=SUBSTR(filler3,1,6)||' '||SUBSTR(filler3,8,13) ,filler1='Y'||SUBSTR(filler1,2,19)
where polnum IN('H110041','H000063',
'00021','C13342','H0252')  
                              
go

update  COASF1.NBICY set filler2=SUBSTR(filler2,1,7)||'0'||SUBSTR(filler2,9,12)
where polnum IN('柔柔弱弱','','','','')                            

go

update COAUF1.nbdnf set status='Y',filler2='Y'||SUBSTR(filler2,2,19)
where polnum IN('1041','000063',
'H0021','C2','252')  
1
2
3
4
5
6
7
8
9
10
11
12
13
14