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

IF EXISTS (SELECT NAME FROM SYSOBJECTS WHERE NAME='付款_支票号_PROC' AND TYPE='P')
DROP PROC 付款_支票号_PROC
GO
create  PROC 付款_支票号_PROC
@check_to varchar(10),
@check_fr varchar(10)
as
CREATE TABLE [#付款主表]
 (
	[供应商编码] [varchar] (10)  ,
	[银行码] [varchar] (10) ,
	[付款类型] [char] (1) ,
	[支票序号] [int] ,
	[支票号码] [varchar] (10)  ,
	[支票日期] [datetime] ,
	[货币] [varchar] (10)  ,
	[汇率] [numeric](18, 6) ,
	[支票金额] [numeric](18, 6) DEFAULT (0),
	[注释] [text]  ,
	[已分配金额] [numeric](18, 6)  DEFAULT (0.00000),
	[剩余金额] [numeric](18, 6)  DEFAULT (0.00000))

insert into #付款主表 select* from 付款主表
where 支票号码>=@check_to and 支票号码<=@check_fr
select *from #付款主表
-- EXEC 付款_支票号_PROC 13356,13356