雇员主文件_雇员_proc.sql

SQL server 进销存软件数据库设计。大家积极下载

if exists(select name from sysobjects where name='雇员主文件_雇员_PROC' and type= 'p')
drop PROC 雇员主文件_雇员_PROC
GO 
CREATE PROC 雇员主文件_雇员_PROC
@EMP_TO varchar (10),
@EMP_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 雇员码>=@EMP_TO AND 雇员码<=@EMP_FR