收款主表_银行码_proc.sql

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

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),
	[收款类型] [varchar] (30),
	[支票号码] [varchar] (30),
	[支票日期] [datetime] ,
	[货币] [varchar] (10), 
	[支票金额] [numeric](18, 0)DEFAULT(0),
	[注释] [text] ,
	[已分配金额] [numeric](18, 6) DEFAULT(0),
	[剩余金额] [numeric](18, 6) DEFAULT(0))
INSERT INTO #收款主表 SELECT *FROM 收款主表
WHERE 银行码>=@BANK_TO AND  银行码<=@BANK_FR

SELECT *FROM #收款主表