销售凭证_凭证_proc.sql

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

IF EXISTS(SELECT NAME FROM SYSOBJECTS WHERE NAME='销售凭证_凭证_PROC' AND TYPE='P')
DROP PROC 销售凭证_凭证_PROC
GO
create  PROC 销售凭证_凭证_PROC
@VOU_TO INT,
@VOU_FR INT
AS 
CREATE TABLE [#销售记账凭证] (
	[凭证号] [int] ,
	[客户编码] [varchar] (10),
	[分配日期] [datetime],
	[销售订单] [int]  ,
	[发票号码] [varchar] (20)  ,
	[发票日期] [datetime] ,
	[增值税码] [varchar] (10) ,
	[增值税率] [numeric](18, 6) ,
	[到期天数] [numeric](18, 6)  ,
	[到期日期] [datetime]  ,
	[注释] [text] ,
	[货币] [varchar] (10) ,
	[发票金额] [numeric](18, 6)  ,
	[增值税金额] [numeric](18, 6))
INSERT INTO #销售记账凭证 SELECT * FROM 销售记账凭证
WHERE 凭证号>=@VOU_TO AND 凭证号<=@VOU_FR

SELECT *FROM #销售记账凭证
-- EXEC 销售凭证_凭证_PROC 1,3