收款主表_客户_proc.sql

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

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

@CUST_TO VARCHAR(10),
@CUST_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 客户编码>=@CUST_TO AND  客户编码<=@CUST_FR 

SELECT *FROM #收款主表