来自「本系统为企业进存销管理系统」· 代码 · 共 25 行

if exists(select name from sysobjects where name='雇员主文件_出生年月_PROC' and type= 'p')
drop PROC 雇员主文件_出生年月_PROC
GO 
CREATE PROC 雇员主文件_出生年月_PROC

@年月_TO  DATETIME,
@年月_FR DATETIME
AS
CREATE TABLE #雇员主文件(

	[雇员码] [varchar] (10) ,
	[雇员姓名] [varchar] (10) ,
	[部门码] [varchar] (10),
	[部门主管] [varchar] (10) ,
	[出生年月] [datetime],
	[民族] [varchar] (10),
	[婚姻] [varchar] (10) ,
	[子女] [int],
	[毕业学校] [varchar] (30),
	[学历] [varchar] (10),
	[专业] [varchar] (20) ,
	[工资标准] [numeric](18, 6))
INSERT INTO #雇员主文件 select * from 雇员主文件
SELECT * FROM #雇员主文件 WHERE 出生年月>=@年月_TO AND 出生年月<=@年月_FR