本系统为企业进存销管理系统

if exists (select name from sysobjects where name='采购单_PROC' and type='P')
drop PROC 采购单_PROC
go
create PROC 采购单_PROC
@po_to int,
@po_fr int
as
 CREATE TABLE [#采购单主表] (
	[采购单号] [int] ,
	[日期] [datetime],
	[状态] [char] (10)DEFAULT (0),
	[供应商编码] [varchar] (10),
	[采购员] [varchar] (10) ,
	[发货途径] [varchar] (10) ,
	[仓库] [varchar] (10),
	[货币] [varchar] (10),
	[信用条款] [varchar] (10),
	[上次发票日期] [datetime],
	[联系人] [varchar] (10),
	[电话] [varchar] (15),
	[邮编] [varchar] (10),
	[传真] [varchar] (15),
	[预付金额] [numeric](18, 6) DEFAULT (0),
	[增值税码] [varchar] (10) )
	




INSERT INTO #采购单主表 SELECT *FROM 采购单主表
WHERE 采购单号>=@po_to  AND 采购单号<=@po_FR

SELECT *FROM #采购单主表

-- EXEC 采购单_PROC 1,1