开发工具:
文件大小: 605kb
下载次数: 0
上传时间: 2010-03-13
详细说明： IF EXISTS (SELECT name FROM master.dbo.sysdatabases WHERE name = N'My_vehicle') DROP DATABASE [My_vehicle] GO CREATE DATABASE [My_vehicle] ON (NAME = N'My_vehicle_Data', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL\data\My_vehicle_Data.MDF' , SIZE = 1, FILEGROWTH = 10%) LOG ON (NAME = N'My_vehicle_Log', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL\data\My_vehicle_Log.LDF' , SIZE = 1, FILEGROWTH = 10%) COLLATE Chinese_PRC_CI_AS GO exec sp_dboption N'My_vehicle', N'autoclose', N'true' GO exec sp_dbopt ion N'My_vehicle', N'bulkcopy', N'false' GO exec sp_dboption N'My_vehicle', N'trunc. log', N'true' GO exec sp_dboption N'My_vehicle', N'torn page detection', N'true' GO exec sp_dboption N'My_vehicle', N'read only', N'false' GO exec sp_dboption N'My_vehicle', N'dbo use', N'false' GO exec sp_dboption N'My_vehicle', N'single', N'false' GO exec sp_dboption N'My_vehicle', N'autoshrink', N'true' GO exec sp_dboption N'My_vehicle', N'ANSI null default', N'false' GO exec sp_dboption N'My_vehicle', N'recursive triggers', N'false' GO exec sp_dboption N'My_vehicle', N'ANSI nulls', N'false' GO exec sp_dboption N'My_vehicle', N'concat null yields null', N'false' GO exec sp_dboption N'My_vehicle', N'cursor close on commit', N'false' GO exec sp_dboption N'My_vehicle', N'default to local cursor', N'false' GO exec sp_dboption N'My_vehicle', N'quoted identifier', N'false' GO exec sp_dboption N'My_vehicle', N'ANSI warnings', N'false' GO exec sp_dboption N'My_vehicle', N'auto create statistics', N'true' GO exec sp_dboption N'My_vehicle', N'auto update statistics', N'true' GO use [My_vehicle] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[ck_setup]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[ck_setup] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[gf_setup]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[gf_setup] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[inh_setup]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[inh_setup] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[kh_setup]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[kh_setup] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[kucun_setup]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[kucun_setup] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[outh_setup]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[outh_setup] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[wz_setup]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[wz_setup] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[ywy_setup]') and OBJECTPROPERTY(id, N'IsProcedure') = 1) drop procedure [dbo].[ywy_setup] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[dm_ck]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[dm_ck] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[dm_gf]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[dm_gf] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[dm_kh]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[dm_kh] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[dm_wz]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[dm_wz] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[dm_wzlb]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[dm_wzlb] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[dm_ywy]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[dm_ywy] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[dm_ywylb]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[dm_ywylb] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[inh]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[inh] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[kucun]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[kucun] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[outh]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[outh] GO if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[zc]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) drop table [dbo].[zc] GO CREATE TABLE [dbo].[dm_ck] ( [dm] [char] (6) COLLATE Chinese_PRC_CI_AS NOT NULL , [mc] [char] (40) COLLATE Chinese_PRC_CI_AS NULL , [bz] [char] (255) COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[dm_gf] ( [dm] [char] (8) COLLATE Chinese_PRC_CI_AS NOT NULL , [mc] [char] (40) COLLATE Chinese_PRC_CI_AS NULL , [addr] [char] (40) COLLATE Chinese_PRC_CI_AS NULL , [yzbm] [char] (6) COLLATE Chinese_PRC_CI_AS NULL , [tel] [char] (40) COLLATE Chinese_PRC_CI_AS NULL , [itladd] [char] (50) COLLATE Chinese_PRC_CI_AS NULL , [email] [char] (50) COLLATE Chinese_PRC_CI_AS NULL , [sui_no] [char] (20) COLLATE Chinese_PRC_CI_AS NULL , [bank_no] [char] (20) COLLATE Chinese_PRC_CI_AS NULL , [bank] [char] (30) COLLATE Chinese_PRC_CI_AS NULL , [ywman] [char] (8) COLLATE Chinese_PRC_CI_AS NULL , [bz] [char] (255) COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[dm_kh] ( [dm] [char] (8) COLLATE Chinese_PRC_CI_AS NOT NULL , [mc] [char] (40) COLLATE Chinese_PRC_CI_AS NULL , [lbdm] [char] (30) COLLATE Chinese_PRC_CI_AS NULL , [addr] [char] (40) COLLATE Chinese_PRC_CI_AS NULL , [yzbm] [char] (6) COLLATE Chinese_PRC_CI_AS NULL , [tel] [char] (40) COLLATE Chinese_PRC_CI_AS NULL , [itladd] [char] (50) COLLATE Chinese_PRC_CI_AS NULL , [ywman] [char] (8) COLLATE Chinese_PRC_CI_AS NULL , [email] [char] (50) COLLATE Chinese_PRC_CI_AS NULL , [sui_no] [char] (20) COLLATE Chinese_PRC_CI_AS NULL , [bank_no] [char] (30) COLLATE Chinese_PRC_CI_AS NULL , [bank] [char] (30) COLLATE Chinese_PRC_CI_AS NULL , [card_no] [char] (13) COLLATE Chinese_PRC_CI_AS NULL , [mb_reb] [numeric](12, 2) NULL , [bz] [char] (255) COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[dm_wz] ( [dm] [char] (30) COLLATE Chinese_PRC_CI_AS NOT NULL , [mc] [char] (40) COLLATE Chinese_PRC_CI_AS NULL , [jldw] [char] (8) COLLATE Chinese_PRC_CI_AS NULL , [lbdm] [char] (30) COLLATE Chinese_PRC_CI_AS NULL , [rkj] [numeric](12, 2) NULL , [fxj] [numeric](12, 2) NULL , [lsj] [numeric](12, 2) NULL , [cj] [char] (20) COLLATE Chinese_PRC_CI_AS NULL , [yxrq] [datetime] NULL , [bz] [char] (255) COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[dm_wzlb] ( [lbcode] [char] (30) COLLATE Chinese_PRC_CI_AS NULL , [lb] [char] (30) COLLATE Chinese_PRC_CI_AS NULL , [lbcode1] [char] (30) COLLATE Chinese_PRC_CI_AS NULL , [lb1] [char] (30) COLLATE Chinese_PRC_CI_AS NULL , [bz] [char] (255) COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[dm_ywy] ( [dm] [char] (6) COLLATE Chinese_PRC_CI_AS NOT NULL , [mc] [char] (20) COLLATE Chinese_PRC_CI_AS NULL , [lb] [char] (30) COLLATE Chinese_PRC_CI_AS NULL , [tel] [char] (40) COLLATE Chinese_PRC_CI_AS NULL , [addr] [char] (40) COLLATE Chinese_PRC_CI_AS NULL , [sfz] [char] (18) COLLATE Chinese_PRC_CI_AS NULL , [lbcode] [char] (30) COLLATE Chinese_PRC_CI_AS NULL , [bz] [char] (255) COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[dm_ywylb] ( [lbcode] [char] (30) COLLATE Chinese_PRC_CI_AS NOT NULL , [lb] [char] (30) COLLATE Chinese_PRC_CI_AS NULL , [bz] [char] (255) COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[inh] ( [in_date] [datetime] NULL , [ywman] [char] (8) COLLATE Chinese_PRC_CI_AS NULL , [inh_no] [char] (14) COLLATE Chinese_PRC_CI_AS NOT NULL , [gfdm] [char] (8) COLLATE Chinese_PRC_CI_AS NULL , [ckdm] [char] (6) COLLATE Chinese_PRC_CI_AS NULL , [wzdm] [char] (30) COLLATE Chinese_PRC_CI_AS NOT NULL , [qihao] [char] (8) COLLATE Chinese_PRC_CI_AS NULL , [sl] [numeric](10, 0) NOT NULL , [in_danj] [numeric](12, 2) NULL , [i_zk] [numeric](5, 0) NULL , [i_zke] [numeric](12, 2) NULL , [jsfk] [char] (2) COLLATE Chinese_PRC_CI_AS NULL , [jz] [char] (2) COLLATE Chinese_PRC_CI_AS NULL , [yf] [numeric](5, 0) NULL , [bz] [char] (100) COLLATE Chinese_PRC_CI_AS NULL , [bz1] [char] (10) COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[kucun] ( [update_date] [datetime] NULL , [kucun_no] [char] (14) COLLATE Chinese_PRC_CI_AS NOT NULL , [ckdm] [char] (6) COLLATE Chinese_PRC_CI_AS NULL , [wzdm] [char] (30) COLLATE Chinese_PRC_CI_AS NOT NULL , [qihao] [char] (8) COLLATE Chinese_PRC_CI_AS NULL , [sl] [numeric](10, 0) NOT NULL , [total_je] [numeric](12, 2) NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[outh] ( [out_date] [datetime] NULL , [ywman] [char] (8) COLLATE Chinese_PRC_CI_AS NULL , [outh_no] [char] (14) COLLATE Chinese_PRC_CI_AS NOT NULL , [khdm] [char] (8) COLLATE Chinese_PRC_CI_AS NULL , [ckdm] [char] (6) COLLATE Chinese_PRC_CI_AS NULL , [wzdm] [char] (30) COLLATE Chinese_PRC_CI_AS NOT NULL , [qihao] [char] (8) COLLATE Chinese_PRC_CI_AS NULL , [sl] [numeric](10, 0) NOT NULL , [out_danj] [numeric](12, 2) NULL , [o_zk] [numeric](5, 0) NULL , [o_zke] [numeric](12, 2) NULL , [jsfk] [char] (2) COLLATE Chinese_PRC_CI_AS NULL , [jz] [char] (2) COLLATE Chinese_PRC_CI_AS NULL , [yf] [numeric](5, 0) NULL , [bz] [char] (100) COLLATE Chinese_PRC_CI_AS NULL , [bz1] [char] (100) COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY] GO CREATE TABLE [dbo].[zc] ( [zc_no] [char] (8) COLLATE Chinese_PRC_CI_AS NOT NULL , [zc_date] [datetime] NULL , [ywman] [char] (8) COLLATE Chinese_PRC_CI_AS NULL , [o_ckdm] [char] (6) COLLATE Chinese_PRC_CI_AS NULL , [i_ckdm] [char] (6) COLLATE Chinese_PRC_CI_AS NULL , [wzdm] [char] (30) COLLATE Chinese_PRC_CI_AS NOT NULL , [qihao] [char] (8) COLLATE Chinese_PRC_CI_AS NULL , [sl] [numeric](10, 0) NOT NULL , [total_je] [numeric](12, 2) NULL , [bz] [char] (100) COLLATE Chinese_PRC_CI_AS NULL ) ON [PRIMARY] GO SET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS ON GO CREATE PROCEDURE ck_setup ( @dm char (6), @mc char (40), @bz char (255) ) AS insert dm_ck ( dm, mc, bz ) values ( @dm, @mc, @bz ) GO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS ON GO CREATE PROCEDURE gf_setup ( @dm char (8), @mc char (40), @addr char (40), @yzbm char (6), @tel char (40), @itladd char (50), @email char (50), @sui_no char (20), @bank_no char (20), @bank char (30), @ywman char(8), @bz char (255) ) AS insert dm_gf ( dm,mc,addr,yzbm,tel,itladd,email,sui_no,bank_no,bank,ywman,bz ) values ( @dm, @mc, @addr, @yzbm, @tel, @itladd, @email, @sui_no, @bank_no, @bank, @ywman, @bz ) GO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS ON GO CREATE PROCEDURE inh_setup ( @in_date datetime, @ywman char (20), @inh_no char (8), @gfdm char (8), @ckdm char (6), @wzdm char (30), @qihao char (8), @sl numeric (10), @in_danj numeric(12, 2), @i_zk numeric(5, 0), @i_zke numeric(12, 2), @jsfk char (2), @jz char (2) , @yf numeric (5,0), @bz char (100) ) AS insert inh ( in_date, ywman, inh_no, gfdm, ckdm, wzdm, qihao, sl, in_danj, i_zk, i_zke, jsfk, jz, yf, bz ) values ( @in_date, @ywman, @inh_no, @gfdm, @ckdm, @wzdm, @qihao, @sl, @in_danj, @i_zk, @i_zke, @jsfk, @jz, @yf, @bz ) GO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS ON GO CREATE PROCEDURE kh_setup ( @dm char (8), @mc char (40), @lbdm char(30), @addr char (40), @yzbm char (6), @tel char (40), @itladd char (50), @ywman char (8), @email char (50), @sui_no char (20), @bank_no char (20), @bank char (30), @card_no char (13), @mb_reb numeric (12,2), @bz char (255) ) AS insert dm_kh ( dm,mc,lbdm,addr,yzbm,tel,itladd,ywman,email,sui_no,bank_no,bank,card_no,mb_reb,bz ) values ( @dm, @mc, @lbdm, @addr, @yzbm, @tel, @itladd, @ywman, @email, @sui_no, @bank_no, @bank, @card_no, @mb_reb, @bz ) GO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS ON GO CREATE PROCEDURE kucun_setup ( @update_date datetime, @kucun_no char (14), @ckdm char (6), @wzdm char (30), @qihao char (8), @sl numeric (10), @total_je numeric(12, 2) ) AS insert kucun ( update_date, kucun_no, ckdm, wzdm, qihao, sl, total_je ) values ( @update_date, @kucun_no, @ckdm, @wzdm, @qihao, @sl, @total_je ) GO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS ON GO CREATE PROCEDURE outh_setup ( @out_date datetime, @ywman char (20), @outh_no char (8), @khdm char (8), @ckdm char (6), @wzdm char (30), @qihao char (8), @sl numeric (10), @out_danj numeric(12, 2), @o_zk numeric(5, 0), @o_zke numeric(12, 2), @jsfk char (2), @jz char (2) , @yf numeric (5,0), @bz char (100) ) AS insert outh ( out_date, ywman, outh_no, khdm, ckdm, wzdm, qihao, sl, out_danj, o_zk, o_zke, jsfk, jz, yf, bz ) values ( @out_date, @ywman, @outh_no, @khdm, @ckdm, @wzdm, @qihao, @sl, @out_danj, @o_zk, @o_zke, @jsfk, @jz, @yf, @bz ) GO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS ON GO CREATE PROCEDURE wz_setup ( @dm char(30), @mc char(40), @jldw char(8), @lbdm char(30), @rkj numeric(12,2), @fxj numeric(12,2), @lsj numeric(12,2), @cj char(20), @yxrq datetime, @bz char(255) ) AS insert dm_wz ( dm,mc,jldw,lbdm,rkj,fxj,lsj,cj,yxrq,bz ) values ( @dm,@mc,@jldw,@lbdm,@rkj,@fxj,@lsj,@cj,@yxrq,@bz ) GO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO SET ANSI_NULLS ON GO CREATE PROCEDURE ywy_setup ( @dm char (6), @mc char (20), @lb char (30), @tel char (40), @addr char (40), @sfz char (18), @lbcode char (30), @bz char (255) ) AS insert dm_ywy ( dm, mc, lb, tel, addr, sfz, lbcode, bz ) values ( @dm, @mc, @lb, @tel, @addr, @sfz, @lbcode, @bz ) GO SET QUOTED_IDENTIFIER OFF GO SET ANSI_NULLS ON GO ...展开收缩
(系统自动生成,下载前可以参看下载内容)
下载文件列表
相关说明
- 本站资源为会员上传分享交流与学习,如有侵犯您的权益,请联系我们删除.
- 本站是交换下载平台，提供交流渠道，下载内容来自于网络，除下载问题外，其它问题请自行百度。
- 本站已设置防盗链，请勿用迅雷、QQ旋风等多线程下载软件下载资源，下载后用WinRAR最新版进行解压.
- 如果您发现内容无法下载，请稍后再次尝试；或者到消费记录里找到下载记录反馈给我们.
- 下载后发现下载的内容跟说明不相乎，请到消费记录里找到下载记录反馈给我们，经确认后退回积分.
- 如下载前有疑问，可以通过点击"提供者"的名字，查看对方的联系方式，联系对方咨询.
