清空数据不清表
--注意：以下脚本是全部清空数据表数据，执行必须小心！！！---------------------------
truncate tableBcpkc_cczs
truncate tableBcpkc_ckbh
truncate tableBcpkc_ckit
truncate tableBcpkc_dbbh
truncate tableBcpkc_dbit
truncate tableBcpkc_jcit
truncate tableBcpkc_pdbh
truncate tableBcpkc_pdit
truncate tableBcpkc_rkbh
truncate tableBcpkc_rkit
truncate tableBcpkc_tjbh
truncate tableBcpkc_tjit
truncate tableBOM_goodsbh
truncate tableBOM_goodsit
truncate tableBOM_gsbh
truncate tableBOM_gsit
truncate tableBOM_gsitmx
truncate tableBOM_xsddbh
truncate tableBOM_xsddit
truncate tableclcg_ddbh
truncate tableclcg_ddit
truncate tableclcg_fpbh
truncate tableclcg_fpit
truncate tableclcg_jhbh
truncate tableclcg_jhit
truncate tableclcg_jsbh
truncate tableclcg_jsit
truncate tableclcg_rkbh
truncate tableclcg_rkit
truncate tableclcg_thbh
truncate tableclcg_thit
truncate tableclcg_xjbh
truncate tableclcg_xjit
truncate tableclck_ckit
truncate tableclkc_cczs
truncate tableclkc_ckbh
truncate tableclkc_ckit
truncate tableclkc_dbbh
truncate tableclkc_dbit
truncate tableclkc_jcbh
truncate tableclkc_jcit
truncate tableclkc_jxctj
truncate tableclkc_pdbh
truncate tableclkc_pdit
truncate tableclkc_rkbh
truncate tableclkc_rkit
truncate tableclkc_tjbh
truncate tableclkc_tjit
truncate tableclsc_cczs
truncate tableclsc_hybh
truncate tableclsc_hyit
truncate tableclsc_llbh
truncate tableclsc_llit
truncate tableclsc_pdbh
truncate tableclsc_pdit
truncate tableclsc_sqbh
truncate tableclsc_sqit
truncate tableclxs_bjbh
truncate tableclxs_bjit
truncate tableclxs_ckbh
truncate tableclxs_ckit
truncate tableclxs_ddbh
truncate tableclxs_ddit
truncate tableclxs_fpbh
truncate tableclxs_fpit
truncate tableclxs_thbh
truncate tableclxs_thit
truncate tablecpzz_dzbh
truncate tablecpzz_dzit
truncate tablecwfk_bzbh
truncate tablecwfk_bzit
truncate tablecwfk_fkbh
truncate tablecwfk_fkit
truncate tablecwfk_fkit_xm
truncate tablecwfk_fpbh
truncate tablecwfk_fpit
truncate tablecwfk_hxbh
truncate tablecwfk_hxit
truncate tablecwfk_jybh
truncate tablecwfk_jyit
truncate tablecwfk_pdbh
truncate tablecwfk_pdit
truncate tablecwfk_qtbh
truncate tablecwfk_qtit
truncate tablecwfk_rzbh
truncate tablecwfk_rzit
truncate tablecwfk_sqbh
truncate tablecwfk_sqit
truncate tablecwfk_tjbh
truncate tablecwfk_tjit
truncate tablecwfk_yfbh
truncate tablecwsk_djtjbh
truncate tablecwsk_fpbh
truncate tablecwsk_fpit
truncate tablecwsk_hxbh
truncate tablecwsk_hxit
truncate tablecwsk_jybh
truncate tablecwsk_jyit
truncate tablecwsk_khzk
truncate tablecwsk_pdbh
truncate tablecwsk_pdit
truncate tablecwsk_qtbh
truncate tablecwsk_qtit
truncate tablecwsk_rzbh
truncate tablecwsk_rzit
truncate tablecwsk_skbh
truncate tablecwsk_skit
--truncate tablecwsk_skit_xm
truncate tablecwsk_tjbh
truncate tablecwsk_tjit
truncate tablecwsk_ysbh
truncate tablecwsk_ztbh
truncate tablecwsk_ztit
truncate tableAPFK_Init
truncate tableARSK_Init
truncate tablecwsk_khtj
truncate tablefwgl_gzbh
truncate tablefwgl_gzit
truncate tablefwgl_twbh
truncate tablefwgl_twit
truncate tablejhgl_yzbh
truncate tablejhgl_yzit
truncate tableJLgl_bfbh
truncate tableJLgl_bfit
truncate tableJLgl_cgbh
truncate tableJLgl_cgit
truncate tableJLgl_ghbh
truncate tableJLgl_ghit
truncate tableJLgl_lybh
truncate tableJLgl_lyedit
truncate tableJLgl_lyit
truncate tableJLgl_rkbh
truncate tableJLgl_rkit
truncate tableJLgl_sgbh
truncate tableJLgl_sgit
truncate tableJLgl_sjbh
truncate tableJLgl_sjit
truncate tableJLgl_sjjgbh
truncate tableJLgl_sjjgit
truncate tableJLgl_sxbh
truncate tableJLgl_sxit
truncate tableJLgl_sxjgbh
truncate tableJLgl_sxjgit
truncate tableJLgl_thbh
truncate tableJLgl_thit
truncate tableJLgl_xhbh
truncate tableJLgl_xhit
truncate tableJLgl_xjbh
truncate tableJLgl_xjit
truncate tablejlgl_zdjlbh
truncate tablejlgl_zdsjzq
truncate tablejlgl_zdxjzq
truncate tableJLgl_zledit
truncate tablekhgl_gzjl
truncate tablekhgl_skjl
truncate tableLbkc_cczs
truncate tableLbkc_ckbh
truncate tableLbkc_ckit
truncate tableLbkc_dbbh
truncate tableLbkc_dbit
truncate tableLbkc_jcit
truncate tableLbkc_pdbh
truncate tableLbkc_pdit
truncate tableLbkc_rkbh
truncate tableLbkc_rkit
truncate tableLbkc_tjbh
truncate tableLbkc_tjit
truncate tableLbkc_tzbh
truncate tableLbkc_tzit
truncate tablelckc_bfbh
truncate tablelckc_bfit
truncate tablelckc_cczs
truncate tablelckc_ckbh
truncate tablelckc_ckcw
truncate tablelckc_ckit
truncate tablelckc_dbbh
truncate tablelckc_dbit
truncate tablelckc_jcit
truncate tablelckc_pcbh
truncate tablelckc_pcit
truncate tablelckc_pdbh
truncate tablelckc_pdit
truncate tablelckc_rkbh
truncate tablelckc_rkit
truncate tablelckc_tjbh
truncate tablelckc_tjit
truncate tablemjbf_dzbh
truncate tablemjbf_dzit
truncate tablemjcl_dzbh
truncate tablemjcl_dzit
truncate tablemjdb_dzbh
truncate tablemjdb_dzit
truncate tablemjdd_dzbh
truncate tablemjdd_dzit
truncate tablemjdh_dzbh
truncate tablemjdh_dzit
truncate tablemjdh_gybh
truncate tablemjdh_gyit
truncate tablemjdh_gyita
truncate tablemjfc_dzbh
truncate tablemjfc_dzit
truncate tablemjfk_dzbh
truncate tablemjfk_dzit
truncate tablemjfx_dzbh
truncate tablemjfx_dzit
truncate tablemjfx_rkbh
truncate tablemjfx_rkit
truncate tablemjjs_skbh
truncate tablemjjs_skit
truncate tablemjly_dzbh
truncate tablemjly_dzit
truncate tablemjpc_dzbh
truncate tablemjpc_dzit
truncate tablemjrk_dzbh
truncate tablemjrk_dzit
truncate tablemjsc_dzbh
truncate tablemjsc_dzit
truncate tablemjsm_dzbh
truncate tablemjsm_dzit
truncate tablemjsm_jhbh
truncate tablemjsm_jhit
truncate tablemjtm_dzbh
truncate tablemjtm_dzit
truncate tablemjxm_dzbh
truncate tablemjxm_dzit
truncate tablemjxs_dzbh
truncate tablemjxs_dzit
truncate tablemjys_dzbh
truncate tablemjys_dzit
truncate tablemjzd_dzmjzt
truncate tablemjzd_ggzk
truncate tablemjzd_mjbh
truncate tablemjzd_mjbh_ysk
truncate tablemjzd_mjkw
truncate tablemjzd_mjmd
truncate tablemjzd_mjNo
truncate tablemjzd_mjwzlb
truncate tablemjzd_mjwzrj
truncate tablemjzl_bgbh
truncate tablemjzd_mjwzrj
truncate table mjzd_mjbh_ysk
truncate table mjdd_jhit
truncate table mjdd_jhbh
truncate tableplkc_cczs
truncate tableplkc_ckbh
truncate tableplkc_ckit
truncate tableplkc_dbbh
truncate tableplkc_dbit
truncate tableplkc_jcit
truncate tableplkc_pdbh
truncate tableplkc_pdit
truncate tableplkc_rkbh
truncate tableplkc_rkit
truncate tableplkc_tjbh
truncate tableplkc_tjit
truncate tableQcjl_dzbh
truncate tableQcjl_dzit
truncate tableQcjl_fxjl
truncate tableQcjl_khth
truncate tableQcjl_khts
truncate tableQcjl_sbzl
truncate tableQcxj_fhbh
truncate tableQcxj_fhit
truncate tableQcxj_jybh
truncate tableQcxj_jyit
truncate tableQcxj_ptbh
truncate tableQcxj_ptit
truncate tableQcxj_yhbh
truncate tableQcxj_yhit
truncate tableRsgl_changeRec
truncate tableRsgl_dbRec
truncate tableRszd_Rsda
truncate tableRSgl_EduCourse
truncate tableRsgl_family
truncate tableRsgl_gsRec
truncate tableRsgl_jfRec
truncate tableRsgl_leaveRec
truncate tableRsgl_LyRec
truncate tableRsgl_outRec
truncate tableRsgl_ZjRec
truncate tableRsjx_khbh
truncate tableRsjx_khit
truncate tableRsjx_khjgbh
truncate tableRsjx_khjgit
truncate tableRSjx_khlb
truncate tableRsjx_khmb_Dept
truncate tableRsjx_khmb_pslb
truncate tableRsjx_khmb_Rec
truncate tableRsjx_khmb_Rs
truncate tableRsjx_khmbbh
truncate tableRsjx_khmbit
truncate tableRSjx_khObj
truncate table Rssc_khoperObj
truncate table Rskq_newdzit
truncate table Rskq_newdzbh
truncate table Rssc_kfbh
truncate table Rssc_kfit
truncate table Rsda_edit
truncate tablescbf_dzbh
truncate tablescbf_dzit
truncate tablescbl_dzbh
truncate tablescbl_dzit
truncate tableScbz_Label
truncate tablescdd_dzbh
truncate tablescdd_dzit
truncate tablescdd_gzbh
truncate tablescdd_gzit
truncate tablescdd_pcit
truncate tablescdd_tbit
truncate tablescdd_wgbh
truncate tablescdd_wgit
truncate tablescfh_pcbh
truncate tablescfh_pcit
truncate tablescfh_scbh
truncate tablescfh_scit
truncate tablescfx_dzbh
truncate tablescfx_dzit
truncate tablescgs_hbbh
truncate tablescgs_hbit
truncate tablescgs_jhbh
truncate tablescgs_jhit
truncate tablescjg_dzbh
truncate tablescjg_dzit
truncate tablescjg_pcbh
truncate tablescjg_pcit
truncate tablescjj_dzbh
truncate tablescjj_dzit
truncate tablescjy_dzbh
truncate tablescjy_dzit
truncate tablescjy_pcbh
truncate tablescjy_pcit
truncate tablescjy_ssbh
truncate tablescjy_ssgy
truncate tablescjy_ssit
truncate tablescmw_pcbh
truncate tablescmw_pcit
truncate tablescmw_scbh
truncate tablescmw_scit
truncate tablescpt_Bpcbh
truncate tablescpt_Bpcit
truncate tablescpt_dnbh
truncate tablescpt_dnit
truncate tablescpt_dzitAdd
truncate tablescpt_gybh
truncate tablescpt_gyit
truncate tablescpt_lhbh
truncate tablescpt_lhit
truncate tablescpt_lwbh
truncate tablescpt_lwit
truncate tablescpt_pcbh
truncate tablescpt_pcit
truncate tablescpt_upbh
truncate tablescpt_upit
truncate tablescwg_dzbh
truncate tablescwg_dzit
truncate tablescyh_cgybh
truncate tablescyh_cgyit
truncate tablescyh_dnbh
truncate tablescyh_dnit
truncate tablescyh_dzitAdd
truncate tablescyh_gyjsbh
truncate tablescyh_gyjsit
truncate tablescyh_pcbh
truncate tablescyh_pcit
truncate tablescyh_psbh
truncate tablescyh_psit
truncate tablescyh_upbh
truncate tablescyh_upit
truncate tablewtfw_cczs
truncate tablewtfw_jgbh
truncate tablewtfw_jgit
truncate tablewtfw_jhbh
truncate tablewtfw_jhit
truncate tablewtfw_pdbh
truncate tablewtfw_pdit
truncate tablewtrp_fwjgtj
truncate tablexsbj_dzbh
truncate tablexsbj_dzit
truncate tablexsdd_dzbh
truncate tablexsdd_dzit
truncate tablexsdd_dzitAdd
truncate tablexsdd_Edbh
truncate tablexsdd_Edit
truncate tablexsfh_dzbh
truncate tablexsfh_dzit
truncate tableXsfx_cczs
truncate tableXsfx_ckbh
truncate tableXsfx_ckit
truncate tableXsfx_pdbh
truncate tableXsfx_pdit
truncate tableXsfx_rkbh
truncate tableXsfx_rkit
truncate tablexsht_dzbh
truncate tablexsht_dzit
truncate tablexsht_edbh
truncate tablexsht_edbh_olbh
truncate tablexsht_edit
truncate tablexsht_ldbh
truncate tablexsht_ldit
truncate tablexsjs_dzbh
truncate tablexsjs_dzit
truncate tablexsth_dzbh
truncate tablexsth_dzit
truncate table jhzd_rlit
truncate table clkc_cczs_xckc
truncate table lckc_cczs_xckc
truncate table lbkc_cczs_xckc
truncate table plkc_cczs_xckc
truncate table bcpkc_cczs_xckc
truncate table rzsc_dzbh
truncate table rzsc_dzit
truncate table rzsc_gybh
truncate table rzsc_gyit
truncate table rzsc_inbh
truncate table rzsc_init
truncate table xsdd_gylx
truncate table xsdd_itBomCL
truncate table xsdd_itBomGS
truncate table xsdd_itSumdzbh
truncate table xsdd_itSumGS
truncate table scdd_dzit_scjh
truncate table scdd_gylx
truncate table MRP_xsddbh
truncate table MRP_xsddit
truncate table jhsc_MPSbh
truncate table jhsc_MPSit
truncate table jhsc_pcbh
truncate table jhsc_pcit
truncate table jhsc_RCCP
truncate table jhsc_RCCP_Calc
truncate table jhsc_RCCP_gs
truncate table jhsc_RCCP_gsmx
truncate table jhsc_RCCP_gzzx
truncate table zd_goods
truncate table Cbzd_goodsdj
truncate table zd_kh
truncate table zd_scbz
--truncate table zdDept
truncate table lyzd_lcbz
truncate table lyzd_lcxhlb
truncate table lyzd_lcxh
truncate table lyzd_lcxhDept
truncate table lyzd_lcys
truncate table lyzd_lcysDept
truncate table Sbgl_zdsb
truncate table zdSelfRep
truncate table tkPeriodCo
TRUNCATE TABLECRMzd_kh
--TRUNCATE TABLEzd_Employee
--delete tkuser where userID>2265
TRUNCATE TABLECRMfy_Init
TRUNCATE TABLECRMfy_dzbh
TRUNCATE TABLECRMfy_dzit
TRUNCATE TABLECRMfy_hxbh
TRUNCATE TABLECRMfy_hxit
TRUNCATE TABLECRMfy_fkbh
TRUNCATE TABLECRMfy_fkit
TRUNCATE TABLEwfzd_attachs
truncate tableOatz_cbtz
truncate tableOatz_zgtz
truncate tableOatz_bmtz
truncate tabletkUserInfo_Recv
truncate tabletkUserInfo_Send
truncate table tkLinkItem
truncate table tkLog
update tkSeed--自动编码表
setdzbh=0,MainID=0,nowDate=GETDATE(),nowMonth=CONVERT(varchar(6), GETDATE(), 12)
update tkKeyField --自动编码表
set MainID=0
GO
SET IDENTITY_INSERT lyzd_lcxhlb ON
GO
INSERT lyzd_lcxhlb(xhlbID,lbCode,xhlbmc)
values (0,'00','待定'),
(1,'99','系统预置')
GO
SET IDENTITY_INSERT lyzd_lcxhlb OFF
GO
SET IDENTITY_INSERT zd_kh ON
GO
INSERT zd_kh(khID,khdm,khmc,FType)
values (0, '00','待定',3)
GO
SET IDENTITY_INSERT zd_kh OFF
GO
SET IDENTITY_INSERT lyzd_lcbz ON
GO
INSERT lyzd_lcbz(bzid,bzdm,bzmc )
values (0, '00', '待定')
GO
SET IDENTITY_INSERT lyzd_lcbz OFF
GO
SET IDENTITY_INSERT lyzd_lcys ON
GO
INSERT lyzd_lcys(ysid,ysdm,ysmc )
values (0, '00', '待定')
GO
SET IDENTITY_INSERT lyzd_lcys OFF
GO
SET IDENTITY_INSERT zd_scbz ON
GO
INSERT zd_scbz(liid,bzdm,bzmc )
values (0, '00', '待定')
GO
SET IDENTITY_INSERT zd_scbz OFF
GO
SETIDENTITY_INSERT lyzd_lcxh ON
GO
INSERTlyzd_lcxh(xhid,xhdm,xhmc,khxhdm,xhlbid,tzmc,khid )
values (0, '00','待定','待定',0,'系统值，禁止删改',0)
,(1, '99-01','运输(FOB)','运输(FOB)',1,'系统值，禁止删改',0)
,(2, '99-02','安装','安装',1,'系统值，禁止删改',0)
,(3, '99-03','税额','税额',1,'系统值，禁止删改',0)
,(4, '99-04','中间商回扣','中间商回扣',1,'系统值，禁止删改',0)
,(5, '99-05','样板模具费','样板模具费',1,'系统值，禁止删改',0)
,(6, '99-06','搬运费','搬运费',1,'系统值，禁止删改',0)
,(7, '99-07','卸货费','卸货费',1,'系统值，禁止删改',0)
,(8, '99-08','质保金','质保金',1,'系统值，禁止删改',0)
,(9, '99-09','待定1','',1,'系统值，禁止删改',0)
,(10, '99-10','待定2','',1,'系统值，禁止删改',0)
,(11, '99-11','待定3','',1,'系统值，禁止删改',0)
,(12, '99-12','待定4','',1,'系统值，禁止删改',0)
,(13, '99-13','待定5','',1,'系统值，禁止删改',0)
,(14, '99-14','待定6','',1,'系统值，禁止删改',0)
,(15, '99-15','待定7','',1,'系统值，禁止删改',0)
,(16, '99-16','待定8','',1,'系统值，禁止删改',0)
,(17, '99-17','待定9','',1,'系统值，禁止删改',0)
,(18, '99-18','待定10','',1,'系统值，禁止删改',0)
,(19, '99-19','待定11','',1,'系统值，禁止删改',0)
,(20, '99-20','待定20','',1,'系统值，禁止删改',0)
,(21, '99-21','待定21','',1,'系统值，禁止删改',0)
,(22, '99-22','待定22','',1,'系统值，禁止删改',0)
,(23, '99-23','待定23','',1,'系统值，禁止删改',0)
,(24, '99-24','待定24','',1,'系统值，禁止删改',0)
,(25, '99-25','待定25','',1,'系统值，禁止删改',0)
,(26, '99-26','待定26','',1,'系统值，禁止删改',0)
,(27, '99-27','待定27','',1,'系统值，禁止删改',0)
,(28, '99-28','待定28','',1,'系统值，禁止删改',0)
,(29, '99-29','待定29','',1,'系统值，禁止删改',0)
,(30, '99-30','待定30','',1,'系统值，禁止删改',0)
GO
SET IDENTITY_INSERT lyzd_lcxh OFF
GO
SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO
本文由大数据人旗下SQL交流QQ群成员:土鳖，收集整理。
页:
[1]