雇员主文件_学历_proc.sql

来自「SQL server 进销存软件数据库设计。大家积极下载」· SQL 代码 · 共 28 行

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

@学历_TO  VARchar (10),
@学历_FR  VARchar (10)
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