if exists(select name from sysobjects where name='計(jì)量單位_PROC' and type= 'p')
drop PROC 計(jì)量單位_PROC
GO 
CREATE PROC 計(jì)量單位_PROC
@UM_TO varchar (10),
@UM_FR varchar (10)
AS
CREATE TABLE [#計(jì)量單位主文件] (
	[計(jì)量單位編碼] [varchar] (10) ,
	[計(jì)量單位描述] [varchar] (10))

INSERT INTO #計(jì)量單位主文件 SELECT * FROM 計(jì)量單位主文件

SELECT * FROM #計(jì)量單位主文件 WHERE 計(jì)量單位編碼>= @UM_TO AND 計(jì)量單位編碼<= @UM_FR