应收账明细_客户_proc.sql

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

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)  ,
	[销售单] [int]  ,
	[货币] [varchar] (10) ,
	[凭证号] [int],
	[发票号码] [varchar] (20)  ,
	[发票日期] [datetime] ,
	[借方金额] [numeric](18, 6),
	[贷方金额] [numeric](18, 6),
	[余额] [numeric](18, 6))
INSERT INTO #应收账款明细账 SELECT* FROM 应收账款明细账
WHERE 客户编码>=@CUST_TO AND 客户编码<=@CUST_FR

SELECT *FROM #应收账款明细账