if exists(select name from sysobjects where name='賬單地址_PROC' and type= 'p')
drop PROC 賬單地址_PROC
GO 
CREATE PROC 賬單地址_PROC
@從賬單 varchar (10),
@到賬單 varchar (10)
AS
CREATE TABLE [#賬單地址表] (
	[賬單地址碼] [varchar] (10) ,
	[賬單地址碼描述] [varchar] (20) )
INSERT INTO #賬單地址表 SELECT * FROM 賬單地址表
SELECT *FROM #賬單地址表 WHERE 賬單地址碼>= @從賬單 AND 賬單地址碼<= @到賬單