销售管理系统相关代码

--销售管理系统相关代码班级:计科学061学号:061004103姓名:方爽--创建数据库IFEXISTS(SELECTnameFROMmaster.dbo.sysdatabasesWHEREname=N'销售管理系统')DROPDATABASE[销售管理系统]GOCREATEDATABASE[销售管理系统]ON(NAME=N'销售管理系统_Data',FILENAME=N'F:\销售管理系统_SQL\销售管理系统_Data.MDF',SIZE=2,FILEGROWTH=10%)LOGON(NAME=N'销售管理系统_Log',FILENAME=N'F:\销售管理系统_SQL\销售管理系统_Log.LDF',SIZE=1,FILEGROWTH=10%)COLLATEChinese_PRC_CI_ASGOexecsp_dboptionN'销售管理系统',N'autoclose',N'false'GOexecsp_dboptionN'销售管理系统',N'bulkcopy',N'false'GOexecsp_dboptionN'销售管理系统',N'trunc.log',N'true'GOexecsp_dboptionN'销售管理系统',N'tornpagedetection',N'false'GOexecsp_dboptionN'销售管理系统',N'readonly',N'false'GOexecsp_dboptionN'销售管理系统',N'dbouse',N'false'GOexecsp_dboptionN'销售管理系统',N'single',N'false'GOexecsp_dboptionN'销售管理系统',N'autoshrink',N'true'GOexecsp_dboptionN'销售管理系统',N'ANSInulldefault',N'false'GOexecsp_dboptionN'销售管理系统',N'recursivetriggers',N'false'GOexecsp_dboptionN'销售管理系统',N'ANSInulls',N'false'GOexecsp_dboptionN'销售管理系统',N'concatnullyieldsnull',N'false'GOexecsp_dboptionN'销售管理系统',N'cursorcloseoncommit',N'false'GOexecsp_dboptionN'销售管理系统',N'defaulttolocalcursor',N'false'GOexecsp_dboptionN'销售管理系统',N'quotedidentifier',N'false'GOexecsp_dboptionN'销售管理系统',N'ANSIwarnings',N'false'GOexecsp_dboptionN'销售管理系统',N'autocreatestatistics',N'true'GOexecsp_dboptionN'销售管理系统',N'autoupdatestatistics',N'true'GOif((@@microsoftversion/power(2,24)=8)and(@@microsoftversion&0xffff=724))execsp_dboptionN'销售管理系统',N'dbchaining',N'false'GOuse[销售管理系统]GO--检查当前数据库是否已存在相应表ifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].[FK_客户订货表_商品基础信息表]')andOBJECTPROPERTY(id,N'IsForeignKey')=1)ALTERTABLE[dbo].[客户订货表]DROPCONSTRAINTFK_客户订货表_商品基础信息表GOifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].[FK_库存表_商品基础信息表]')andOBJECTPROPERTY(id,N'IsForeignKey')=1)ALTERTABLE[dbo].[库存表]DROPCONSTRAINTFK_库存表_商品基础信息表GOifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].[FK_销售表_商品基础信息表]')andOBJECTPROPERTY(id,N'IsForeignKey')=1)ALTERTABLE[dbo].[销售表]DROPCONSTRAINTFK_销售表_商品基础信息表GOifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].[FK_销售退货表_商品基础信息表]')andOBJECTPROPERTY(id,N'IsForeignKey')=1)ALTERTABLE[dbo].[销售退货表]DROPCONSTRAINTFK_销售退货表_商品基础信息表GOifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].[FK_客户订货表_客户基础信息表]')andOBJECTPROPERTY(id,N'IsForeignKey')=1)ALTERTABLE[dbo].[客户订货表]DROPCONSTRAINTFK_客户订货表_客户基础信息表GOifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].[FK_客户结款表_客户基础信息表]')andOBJECTPROPERTY(id,N'IsForeignKey')=1)ALTERTABLE[dbo].[客户结款表]DROPCONSTRAINTFK_客户结款表_客户基础信息表GOifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].[FK_客户订货表_订货票号表]')andOBJECTPROPERTY(id,N'IsForeignKey')=1)ALTERTABLE[dbo].[客户订货表]DROPCONSTRAINTFK_客户订货表_订货票号表GOifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].[FK_销售表_销售票号表2]')andOBJECTPROPERTY(id,N'IsForeignKey')=1)ALTERTABLE[dbo].[销售表]DROPCONSTRAINTFK_销售表_销售票号表2GOifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].[FK_销售退货表_销售退单票号表]')andOBJECTPROPERTY(id,N'IsForeignKey')=1)ALTERTABLE[dbo].[销售退货表]DROPCONSTRAINTFK_销售退货表_销售退单票号表GOifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].[FK_客户结款记录表_客户结款表]')andOBJECTPROPERTY(id,N'IsForeignKey')=1)ALTERTABLE[dbo].[客户结款记录表]DROPCONSTRAINTFK_客户结款记录表_客户结款表GOifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].[销售管理视图]')andOBJECTPROPERTY(id,N'IsView')=1)dropview[dbo].[销售管理视图]GOifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].[客户结款记录表]')andOBJECTPROPERTY(id,N'IsUserTable')=1)droptable[dbo].[客户结款记录表]GOifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].[客户结款表]')andOBJECTPROPERTY(id,N'IsUserTable')=1)droptable[dbo].[客户结款表]GOifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].[客户订货表]')andOBJECTPROPERTY(id,N'IsUserTable')=1)droptable[dbo].[客户订货表]GOifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].[库存表]')andOBJECTPROPERTY(id,N'IsUserTable')=1)droptable[dbo].[库存表]GOifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].[销售表]')andOBJECTPROPERTY(id,N'IsUserTable')=1)droptable[dbo].[销售表]GOifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].[销售退货表]')andOBJECTPROPERTY(id,N'IsUserTable')=1)droptable[dbo].[销售退货表]GOifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].[商品基础信息表]')andOBJECTPROPERTY(id,N'IsUserTable')=1)droptable[dbo].[商品基础信息表]GOifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].[客户基础信息表]')andOBJECTPROPERTY(id,N'IsUserTable')=1)droptable[dbo].[客户基础信息表]GOifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].[操作员信息表]')andOBJECTPROPERTY(id,N'IsUserTable')=1)droptable[dbo].[操作员信息表]GOifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].[订货票号表]')andOBJECTPROPERTY(id,N'IsUserTable')=1)droptable[dbo].[订货票号表]GOifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].[销售票号表]')andOBJECTPROPERTY(id,N'IsUserTable')=1)droptable[dbo].[销售票号表]GOifexists(select*fromdbo.sysobjectswhereid=object_id(N'[dbo].[销售退单票号表]')andOBJECTPROPERTY(id,N'IsUserTable')=1)droptable[dbo].[销售退单票号表]GO--创建用户ifnotexists(select*frommaster.dbo.sysloginswhereloginname=N'山')BEGINdeclare@logindbnvarchar(132),