代码搜索：PROC
找到约 10,000 项符合「PROC」的源代码
代码结果 10,000
www.eeworm.com/read/160745/5565960
proc_+Ԧ
if exists(select name from sysobjects where name='proc_库存转移' and type ='p')
drop proc proc_库存转移
GO
create proc proc_库存转移
@物料编码 VARCHAR(30),
@从货位 VARCHAR(10),
@到货位 VARCHAR(10),
@从仓库 VARCHAR(1
www.eeworm.com/read/160745/5565965
proc_-
IF EXISTS (SELECT NAME FROM SYSOBJECTS WHERE NAME= 'PROC_实地盘点清除' AND TYPE='P')
DROP PROC PROC_实地盘点清除
go
CREATE PROC PROC_实地盘点清除
AS
delete FROM 实际盘点数据表
www.eeworm.com/read/160745/5565967
proc_
IF EXISTS (SELECT NAME FROM SYSOBJECTS WHERE NAME='PROC_采购订购状态过账' AND TYPE='P')
DROP PROC PROC_采购订购状态过账
GO
CREATE PROC PROC_采购订购状态过账
@PO_TO INT,
@PO_FR INT
AS
INSERT INTO 采购入库单明细表(采购单号,行,供应商编码
www.eeworm.com/read/160745/5565968
proc_+
IF EXISTS (SELECT NAME FROM SYSOBJECTS WHERE NAME='PROC_删除采购单' AND TYPE='P')
DROP PROC PROC_删除采购单
GO
CREATE PROC PROC_删除采购单
@源采购单 INT,
@AS_REN CHAR(1) OUTPUT---'0'-->成功;'1'---源采购单不存在;'2'---目标采购单存
www.eeworm.com/read/160745/5565969
proc_+
IF EXISTS (SELECT NAME FROM SYSOBJECTS WHERE NAME='PROC_拷贝采购单' AND TYPE='P')
DROP PROC PROC_拷贝采购单
GO
CREATE PROC PROC_拷贝采购单
@源采购单 INT,
@到采购单 INT,
@AS_REN CHAR(1) OUTPUT---'0'-->成功;'1'---源采购单不存在;
www.eeworm.com/read/160745/5565971
proc_
IF EXISTS (SELECT NAME FROM SYSOBJECTS WHERE NAME='PROC_改变采购单行状态' AND TYPE='P')
DROP PROC PROC_改变采购单行状态
GO
CREATE PROC PROC_改变采购单行状态
@PO INT,
@源行状态 CHAR(1),
@到行状态 CHAR(1),
@AS_REN CHAR(1) OUTPU
www.eeworm.com/read/160745/5565974
proc_
if exists(select name from sysobjects where name='proc_月结' AND TYPE='P' )
DROP PROC proc_月结
go
create proc proc_月结
@年 INT,
@月 INT
AS
INSERT INTO 明细库存表 ( 物料编码,物料描述,月初结存数量,月初材料成本,月初人工成本,月初制造费
www.eeworm.com/read/160745/5565975
proc_+
if exists(select name from sysobjects where name='proc_权限' AND TYPE='P' )
DROP PROC proc_权限
go
create proc proc_权限
@@US varchar(10)
AS
IF EXISTS(SELECT *FROM 用户权限 WHERE 增加采购单='1'and 用户编码=@@US)
www.eeworm.com/read/160745/5565976
proc_
if exists(select name from sysobjects where name='proc_月结检查' AND TYPE='P' )
DROP PROC proc_月结检查
go
create proc proc_月结检查
@日期 DATETIME
AS
/*声明的变量数据类型，要所对应的字段一致*/
DECLARE @一期月结 CHAR(1),@二期月结 CH
www.eeworm.com/read/160745/5566000
proc_
IF EXISTS (SELECT NAME FROM SYSOBJECTS WHERE NAME='PROC_凭证过账' AND TYPE='P')
DROP PROC PROC_凭证过账
GO
create PROC PROC_凭证过账
@客户编码 varchar(10)
as
INSERT INTO 应收账款明细账 ( 客户编码,借方金额,凭证号,发票号码,发票日期)
SE