付款_银行_proc.sql

来自「SQL server 进销存软件数据库设计。大家积极下载」· SQL 代码 · 共 26 行

IF EXISTS (SELECT NAME FROM SYSOBJECTS WHERE NAME='付款_银行_PROC' AND TYPE='P')
DROP PROC 付款_银行_PROC
GO
create  PROC 付款_银行_PROC
@bank_to varchar(10),
@bank_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 银行码>=@bank_to and 银行码<=@bank_fr
select *from #付款主表
-- EXEC 付款_支票号_PROC  'b01','b01'