雇员主文件_专业_proc.sql

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

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) L ,
	[出生年月] [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