+

来自「本系统为企业进存销管理系统」· 代码 · 共 19 行

if exists(select name from sysobjects where name='计量单位_转换_PROC' and type= 'p')
drop PROC 计量单位_转换_PROC
GO 
CREATE PROC 计量单位_转换_PROC
@UM varchar (10)
AS
CREATE TABLE [#计量单位转换] (
	[从计量单位编码] [varchar] (10) ,
	[到计量单位编码] [varchar] (10),
	[计量单位描述] [varchar] (10) ,
	[物料编码] [varchar] (30) ,
	[供应商编码] [varchar] (10) ,
	[客户编码] [varchar] (10) ,
	[转换率] [numeric](18, 0) )
	
INSERT INTO #计量单位转换 SELECT * FROM 计量单位转换
SELECT *FROM #计量单位转换 WHERE 从计量单位编码=@UM