收款主表_支票_proc.sql

来自「java开发数据库源码,关于仓库系统的数据库,功能齐全,测试成功」· SQL 代码 · 共 24 行

IF EXISTS(SELECT NAME FROM SYSOBJECTS WHERE NAME='收款主表_支票_PROC' AND TYPE='P')
DROP PROC 收款主表_支票_PROC
GO
CREATE PROC 收款主表_支票_PROC

@CH_TO [varchar] (30),
@CH_FR [varchar] (30)
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 支票号码>=@CH_TO AND  支票号码<=@CH_FR

SELECT *FROM #收款主表