销售主表_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
@CO_TO INT,
@CO_FR INT
AS
CREATE TABLE [#销售单主表] (
	[销售单号] [int]  ,
	[货币] [varchar] (10),
	[日期] [datetime] ,
	[状态] [char] (1),
	[客户编码] [varchar] (10)  ,
	[销售员] [varchar] (10)  ,
	[发货途径] [varchar] (10)  ,
	[仓库] [varchar] (10)  ,
	[联系人] [varchar] (10) ,
	[电话] [varchar] (15),
	[邮编] [varchar] (10) ,
	[传真] [varchar] (15) ,
	[预收金额] [numeric](18, 6) )
INSERT INTO #销售单主表
SELECT* FROM  销售单主表

WHERE 销售单号>=@CO_TO AND 销售单号<=@CO_FR
SELECT *FROM #销售单主表