IF EXISTS (SELECT name FROM master.dbo.sysdatabases WHERE name = N'My_Factory')
DROP DATABASE [My_Factory]
GO
CREATE DATABASE [My_Factory] ON (NAME = N'My_Factory_Data', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL\data\My_Factory_Data.MDF' , SIZE = 2, FILEGROWTH = 10%) LOG ON (NAME = N'My_Factory_Log', FILENAME = N'C:\Program Files\Microsoft SQL Server\MSSQL\data\My_Factory_Log.LDF' , SIZE = 1, FILEGROWTH = 10%)
COLLATE Chinese_PRC_CI_AS
GO
exec sp_dboption N'My_Factory', N'autoclose', N'true'
GO
exec sp_dboption N'My_Factory', N'bulkcopy', N'false'
GO
exec sp_dboption N'My_Factory', N'trunc. log', N'true'
GO
exec sp_dboption N'My_Factory', N'torn page detection', N'true'
GO
exec sp_dboption N'My_Factory', N'read only', N'false'
GO
exec sp_dboption N'My_Factory', N'dbo use', N'false'
GO
exec sp_dboption N'My_Factory', N'single', N'false'
GO
exec sp_dboption N'My_Factory', N'autoshrink', N'true'
GO
exec sp_dboption N'My_Factory', N'ANSI null default', N'false'
GO
exec sp_dboption N'My_Factory', N'recursive triggers', N'false'
GO
exec sp_dboption N'My_Factory', N'ANSI nulls', N'false'
GO
exec sp_dboption N'My_Factory', N'concat null yields null', N'false'
GO
exec sp_dboption N'My_Factory', N'cursor close on commit', N'false'
GO
exec sp_dboption N'My_Factory', N'default to local cursor', N'false'
GO
exec sp_dboption N'My_Factory', N'quoted identifier', N'false'
GO
exec sp_dboption N'My_Factory', N'ANSI warnings', N'false'
GO
exec sp_dboption N'My_Factory', N'auto create statistics', N'true'
GO
exec sp_dboption N'My_Factory', N'auto update statistics', N'true'
GO
use [My_Factory]
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].[dh_setup]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[dh_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_inquire_ywy]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[inh_inquire_ywy]
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].[xsdh_setup]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[xsdh_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].[dh]') and OBJECTPROPERTY(id, N'IsUserTable') = 1)
drop table [dbo].[dh]
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)
dro�
没有合适的资源?快使用搜索试试~ 我知道了~
资源推荐
资源详情
资源评论
收起资源包目录
My_Factory.zip (67个子文件)
工厂管理sql
frmInquireMINGXI2.frx 4B
frmInquireOYWY.frm 5KB
My_Factory.vbw 3KB
frmInquireOZC2.frm 9KB
frmLogin.frm 4KB
frmKHSetup1.frm 14KB
frmInquireGF.frm 5KB
Module1.bas 3KB
frmInquireOYWY2.frm 9KB
frmInquireIZC2.frm 9KB
frmWZLB1.frm 7KB
frmYWYSetup1.frm 11KB
frmGET1.frm 10KB
frmDH.frm 7KB
frmInquireIOZC2.frm 10KB
frmOUTH.frm 9KB
frmInquireZZ2.frm 9KB
frmZC1.frm 27KB
frmInquireCK.frm 5KB
frmInquireZZ.frm 5KB
frmYWYLB.frm 7KB
frmZZ.frm 23KB
frmMATE.frm 17KB
frmINH1.frm 26KB
frmInquireIOZC.frm 5KB
frmInquireOCK2.frm 9KB
frmXSDH1.frm 18KB
frmInquireOZC.frm 5KB
frmYWYSetup.frm 8KB
frmPLANG1.frm 17KB
frmMATELIST.frm 8KB
frmWZLB.frm 7KB
frmInquireGF2.frm 9KB
frmInquireOCK.frm 5KB
MSSCCPRJ.SCC 195B
sql
myFactory.sql 39KB
frmCKSetup1.frm 7KB
frmOFFER.frm 6KB
frmGET.frm 6KB
frmGF1.frm 12KB
frmXSDH.frm 7KB
frmMain.frm 10KB
My_Factory.vbp 2KB
frmInquireOKH.frm 5KB
frmInquireMINGXI2.frm 6KB
frmInquireIZC.frm 5KB
frmInquireYWY2.frm 9KB
frmZC.frm 10KB
frmInquireMINGXI.frm 4KB
frmOFFER1.frm 10KB
frmInquireOKH2.frm 9KB
frmINH.frm 9KB
frmYWYLB1.frm 7KB
frmWZSetup1.frm 12KB
frmOUTH1.frm 28KB
frmCKSetup.frm 8KB
frmInquireCK2.frm 9KB
frmKHSetup.frm 8KB
frmWZSetup.frm 8KB
frmZZLIST.frm 8KB
frmPLANGLIST.frm 8KB
frmDH1.frm 17KB
frmPLANG.frm 14KB
frmMATE1.frm 13KB
frmInquireYWY.frm 5KB
frmGF.frm 8KB
www.pudn.com.txt 218B
共 67 条
- 1
资源评论
邓凌佳
- 粉丝: 65
- 资源: 1万+
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功