【SQL开源代码栏目提醒】:本文主要为网学会员提供生产管理系统.sql,希望对需要生产管理系统.sql网友有所帮助,学习一下!
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SF_cg2审核采购订单]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[SF_cg2审核采购订单]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SF_cg5订货合同计划登记]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[SF_cg5订货合同计划登记]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SYS清采购订单]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[SYS清采购订单]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[SYS清采购订单审核]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[SYS清采购订单审核]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[mrp计算old]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[mrp计算old]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sf_KF2批次调拨单]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[sf_KF2批次调拨单]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sf_cg1删除全部未用项]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[sf_cg1删除全部未用项]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sf_cg1取得采购项]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[sf_cg1取得采购项]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sf_cg1填写采购订单]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[sf_cg1填写采购订单]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sf_cg3修改采购订单]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[sf_cg3修改采购订单]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sf_cj1填生产订单]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[sf_cj1填生产订单]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sf_cj2审生产订单]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[sf_cj2审生产订单]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sf_cj5填完工报告单]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[sf_cj5填完工
报告单]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sf_cj5由MRP生成生产订单]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[sf_cj5由MRP生成生产订单]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sf_kf1填成品入库单]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[sf_kf1填成品入库单]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sf_mps主生产计划审核]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[sf_mps主生产计划审核]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sf_mps主生产计划预排]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[sf_mps主生产计划预排]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sf_mps填需求计划]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[sf_mps填需求计划]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sf_mrpMpsTest]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[sf_mrpMpsTest]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sf_mrpTest子项毛需求]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[sf_mrpTest子项毛需求]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sf_mrpTest计算]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[sf_mrpTest计算]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sf_mrpmps]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[sf_mrpmps]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sf_mrp子项毛需求]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[sf_mrp子项毛需求]
GO
if exists (select * from dbo.sysobjects where id = object_id(N'[dbo].[sf_mrp生产件资源负荷]') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure [dbo].[sf_mrp生产件资源负荷]
GO
if exists (select * from dbo.sysobjec