INSERT INTO jzorder_mx
(djbh,dj_sn,dj_sort,spid,dw,jlgg,pihao,baozhiqi,sxrq,baozhshl,lingsshl,hw,shl,dj,hshj,koul,je,shlv
,she,hsje,lshj,zengp,wlqrshl,wlqxsl,wlqrjg,wlqrje,wlqrshe,wlqrhsje,is_wlzx,kfqrshl,kfqxsl,is_kfzx,is_zx,is_gsp
,isjs,istk,yiwchsl,canssl,quxsl,yiwchje,yiwchsje,pici,fapiaoh,bukccb,nhshj,yhshj,jiansh,buckcb,is_hs,chbdj,yhsshl
,yhesje,xgdjbh,recnum,ys_sn,ydj,ndj,weixsl,yixsl,duiydjbh,duiydj_cn,lshje,phyqlx,miejph,beizhu,is_jush,dwdj,pizhwh
,gebjj,jmlx,ml,jbyp,ddshl,zhilzhk,dangqzht,ddbh,hegeshl,bhegeshl,yaopfl,jixing,ishmffzj,isdbthzj,is_lc,xh,bukcdj,xdw
,is_qy,jsdj,shjj,jkdj_sn,jkdjbh,qhshl)
--SELECT TOP 1 * FROM jzorder_mx WHERE djbh LIKE 'XSGZDA%'
SELECT djbh,dj_sn,dj_sort,spid,dw,jlgg,pihao,baozhiqi,sxrq,baozhshl,lingsshl,hw,shl,dj,hshj,koul,je,shlv
,she,hsje,lshj,zengp,0 wlqrshl,0 wlqxsl,0 wlqrjg,0 wlqrje,0 wlqrshe,0 wlqrhsje,'否' AS is_wlzx,0 kfqrshl,0 kfqxsl,'否' AS is_kfzx,'否' AS is_zx,'否' AS is_gsp
,'否' AS isjs,'否' AS istk,0 yiwchsl,0 canssl,0 quxsl,0 yiwchje,0 yiwchsje,pici,fapiaoh,0 bukccb,nhshj,yhshj,jiansh,0 buckcb,'否' AS is_hs,chbdj,0 yhsshl
,0 yhesje,xgdjbh,recnum,0 ys_sn,ydj,ndj,0 weixsl,0 yixsl,duiydjbh,duiydj_cn,lshje,0 phyqlx,miejph,beizhu,'' is_jush,dwdj,'' pizhwh
,gebjj,0 jmlx,0 ml,jbyp,0 ddshl,'' zhilzhk,'' dangqzht,'' ddbh,0 hegeshl,0 bhegeshl,yaopfl,jixing,ishmffzj,isdbthzj,is_lc,'' xh,bukcdj,xdw
,'否' AS is_qy,jsdj,0 shjj,jkdj_sn,jkdjbh,qhshl
FROM pf_djmx
WHERE djbh='XSGZDA00799516'
