计量单位_转换_proc.sql

SQL server 进销存软件数据库设计。大家积极下载

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