i-

本系统为企业进存销管理系统

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 账单地址码<= @到账单