proceduredemo16.sql

T-SQL示例大全

/* 文件名称: 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