级联删除，删除p_00abcs_bdtww中满足第二个from的数据
delete from p_00abcs_bdtww
from p_00abcs_bdtww p , [00abcs_bdtww] l
where l.BDTPRO_COD = p.BDTPRO_COD
and l.BDTBR = p.BDTBR
and l.BDTDP = p.BDTDP;
select * into ods_load_test_ww from ods_load_test_zxf where 1=2;
创建同样结构表
阅读(760) | 评论(0) | 转发(0) |
