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�
没有合适的资源?快使用搜索试试~ 我知道了~
资源推荐
资源详情
资源评论
收起资源包目录
VB源码企业进存销系统.rar (68个子文件)
企业进存销系统
sql
myFactory.sql 39KB
_desktop.ini 9B
frmOFFER.frm 6KB
frmZC.frm 10KB
frmYWYLB1.frm 7KB
frmPLANG1.frm 17KB
frmInquireCK.frm 5KB
frmMATELIST.frm 8KB
frmInquireGF.frm 5KB
frmZC1.frm 27KB
frmInquireOZC.frm 5KB
frmInquireYWY.frm 5KB
frmYWYLB.frm 7KB
frmInquireOYWY.frm 5KB
frmInquireOCK.frm 5KB
frmMATE1.frm 13KB
frmKHSetup1.frm 14KB
frmWZLB1.frm 7KB
frmInquireIZC.frm 5KB
frmInquireZZ2.frm 9KB
My_Factory.vbp 2KB
frmInquireOCK2.frm 9KB
frmMain.frm 10KB
frmGF1.frm 12KB
frmWZSetup.frm 8KB
frmCKSetup.frm 8KB
frmInquireMINGXI2.frx 4B
frmZZLIST.frm 8KB
frmINH1.frm 26KB
frmDH.frm 7KB
frmInquireGF2.frm 9KB
frmXSDH1.frm 18KB
frmMATE.frm 17KB
frmZZ.frm 23KB
frmYWYSetup.frm 8KB
frmGET.frm 6KB
frmGF.frm 8KB
frmGET1.frm 10KB
frmInquireCK2.frm 9KB
frmDH1.frm 17KB
frmInquireOZC2.frm 9KB
frminquiremingxi2.f2x 4B
My_Factory.vbw 3KB
Module1.bas 3KB
frmLogin.frm 4KB
frmOFFER1.frm 10KB
frmInquireIOZC.frm 5KB
frmOUTH.frm 9KB
frmINH.frm 9KB
frmInquireYWY2.frm 9KB
frmInquireOKH.frm 5KB
frmInquireIOZC2.frm 10KB
frmWZLB.frm 7KB
frmCKSetup1.frm 7KB
frmOUTH1.frm 28KB
frmInquireOYWY2.frm 9KB
frmWZSetup1.frm 12KB
frmPLANG.frm 14KB
frmInquireMINGXI2.frm 6KB
frmYWYSetup1.frm 11KB
frmInquireIZC2.frm 9KB
frmInquireMINGXI.frm 4KB
_desktop.ini 9B
frmInquireOKH2.frm 9KB
frmInquireZZ.frm 5KB
frmKHSetup.frm 8KB
frmXSDH.frm 7KB
frmPLANGLIST.frm 8KB
共 68 条
- 1
资源评论
- 凌风网络2013-04-16vb6的。。。。本来想找.net的。测试不了。
haaker
- 粉丝: 1
- 资源: 20
上传资源 快速赚钱
- 我的内容管理 展开
- 我的资源 快来上传第一个资源
- 我的收益 登录查看自己的收益
- 我的积分 登录查看自己的积分
- 我的C币 登录后查看C币余额
- 我的收藏
- 我的下载
- 下载帮助
安全验证
文档复制为VIP权益,开通VIP直接复制
信息提交成功