 加好友  发短信
等级：三尾狐
帖子：778
积分：7463
威望：0
精华：0
注册：2009/9/7 10:55:00
|
SQL语句生成一个表格  Post By：2011/5/30 10:17:00 [只看该作者]
现有如下SQL语句，希望能在FOXTABLE中生成一个表格，不知如何做？
insert into tblrsxx(GZLBMC,DWBM,BMMC,SFZ,XM,XB,GL,XLMC,XWMC,MZMC,RYBM,CSRQ,CSD,YJ,RYXZ,ZZZKMC,ZW,JBMC,JBDM,GZJB,RZSJNY,ZJYCTZSJ,YRZW,YRZSJNY,CJGZSJ,LBDWSJ,DZYSXLSJ,GZTFNY,LTSJ,LTQZW,KZQDMC,KMBM,JSBJ,RQ,GK,YHBM,YHZH,PXJBXH,BY1,BY2,BY3,BY4,BY5,BY6,BY7,BY8,BY9,BY10,RSXZ,GZXZ,BZQK,DWBS,ZGDW,L_ZWDJDM,BZLB,PROGRAM,JZDM,ZRYY,JRYY,JRXTSJ,WDWDRSJ,RYZXNY,YSNYBZ,YDWBM,L_ZWLBDM,RYDCNY,CZBJ) values('其他','JX0001000','002','612729192701024829','刘珍','女',0,'XL--','XW--','MZ--','0000QT021900200078118',NULL,NULL,NULL,'XZ01','ZZ--',NULL,'JB--',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'QD--','002001001001','0','2011-05-05','GK01','01','050501100078118',118,'0000QT02190020007811',NULL,NULL,NULL,'stencil601',0,0,0,0,0,'4','4','1','ZT01','JX0001',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,NULL,NULL,'00100000000000000000') | | insert into tblrsxx(GZLBMC,DWBM,BMMC,SFZ,XM,XB,GL,XLMC,XWMC,MZMC,RYBM,CSRQ,CSD,YJ,RYXZ,ZZZKMC,ZW,JBMC,JBDM,GZJB,RZSJNY,ZJYCTZSJ,YRZW,YRZSJNY,CJGZSJ,LBDWSJ,DZYSXLSJ,GZTFNY,LTSJ,LTQZW,KZQDMC,KMBM,JSBJ,RQ,GK,YHBM,YHZH,PXJBXH,BY1,BY2,BY3,BY4,BY5,BY6,BY7,BY8,BY9,BY10,RSXZ,GZXZ,BZQK,DWBS,ZGDW,L_ZWDJDM,BZLB,PROGRAM,JZDM,ZRYY,JRYY,JRXTSJ,WDWDRSJ,RYZXNY,YSNYBZ,YDWBM,L_ZWLBDM,RYDCNY,CZBJ) values('其他','JX0001000','002','610327193705092923','高兰','女',0,'XL--','XW--','MZ--','0000QT021900200078589',NULL,NULL,NULL,'XZ01','ZZ--',NULL,'JB--',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'QD--','002001001001','0','2011-05-05','GK01','01','050501100078589',589,'0000QT02190020007858',NULL,NULL,NULL,'stencil601',0,0,0,0,0,'4','4','1','ZT01','JX0001',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,NULL,NULL,'00100000000000000000') | | insert into tblrsxx(GZLBMC,DWBM,BMMC,SFZ,XM,XB,GL,XLMC,XWMC,MZMC,RYBM,CSRQ,CSD,YJ,RYXZ,ZZZKMC,ZW,JBMC,JBDM,GZJB,RZSJNY,ZJYCTZSJ,YRZW,YRZSJNY,CJGZSJ,LBDWSJ,DZYSXLSJ,GZTFNY,LTSJ,LTQZW,KZQDMC,KMBM,JSBJ,RQ,GK,YHBM,YHZH,PXJBXH,BY1,BY2,BY3,BY4,BY5,BY6,BY7,BY8,BY9,BY10,RSXZ,GZXZ,BZQK,DWBS,ZGDW,L_ZWDJDM,BZLB,PROGRAM,JZDM,ZRYY,JRYY,JRXTSJ,WDWDRSJ,RYZXNY,YSNYBZ,YDWBM,L_ZWLBDM,RYDCNY,CZBJ) values('其他','JX0001000','002','612729194409220047','曹兰','女',0,'XL--','XW--','MZ--','0000QT021900200087036',NULL,NULL,NULL,'XZ01','ZZ--',NULL,'JB--',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'QD--','002001001001','0','2011-05-05','GK01','01','050501100087036',36,'0000QT02190020008703',NULL,NULL,NULL,'stencil601',0,0,0,0,0,'4','4','1','ZT01','JX0001',NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,NULL,'0',NULL,NULL,NULL,'00100000000000000000') |
[此贴子已经被作者于2011-5-30 10:19:53编辑过]
|
