记账凭证_供应商_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
@VEND_to VARCHAR(10),
@VEND_fr VARCHAR(10)
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 供应商编码>=@VEND_to and 供应商编码<=@VEND_fr
select *from  #记账凭证
--EXEC 记账凭证_供应商_PROC 'V01','V01'