sql更新数据的几种方式

1.全删除全插入2.delete当天数据insert当天数据3.根据主键更新数据mergeintoausingbon()whenmatchedthenupdatewhennotmatchedtheninsertINSERTINTOa(id,name)SELECTid,nameFROMbONDUPLICATEKEYUPDATEnameb.name4.更新拉链表updatefullsetend_dtdtfromfullinnerjoininconfull.idinc.idwhereend_dt30001231andfull.balinc.balinsertintofullselectinc.id,inc.bal,dt,30001231fromincleftjoinfullonfull.idinc.idandfull.balinc.balandfull.end_dt30001231-- 只匹配有效数据wherefull.idisnull