proceduredemo16.sql

来自「T-SQL示例大全」· SQL 代码 · 共 23 行

/* 文件名称: ProcedureDemo16.sql */
USE 北风贸易
GO

if exists (select * from dbo.sysobjects where id = object_id(N'dbo.SalaryByDepartment') and OBJECTPROPERTY(id, N'IsProcedure') = 1)
drop procedure dbo.SalaryByDepartment
GO

CREATE PROCEDURE dbo.SalaryByDepartment
@department varchar(10),
@average money OUTPUT,
@maximum money OUTPUT,
@minimum money OUTPUT
AS
SELECT @average = AVG(目前薪资),
              @maximum = MAX(目前薪资),
              @minimum = MIN(目前薪资)
     FROM 飞狐工作室
     WHERE 部门 = @department

GO