记账凭证_编码_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),
	[采购单号] [int],
	[分配日期] [datetime] ,
	[发票号码] [varchar] (20),
	[发票日期] [datetime],
	[增值税码] [varchar] (10),
	[增值税率] [numeric](18, 6),
	[到期天数] [numeric](18, 6),
	[到期日期] [datetime],
	[注释] [text],
	[货币] [varchar] (10),
	[材料金额] [numeric](18, 6) DEFAULT (0),
	[发票金额] [numeric](18, 0) DEFAULT (0),
	[增值税额] [numeric](18, 6)DEFAULT (0)) 

INSERT INTO #记账凭证 SELECT * from 记账凭证 where 凭证号>=@vou_to and 凭证号<=@vou_fr
select *from  #记账凭证
--EXEC 记账凭证_编码_PROC