proceduredemo17.sql

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

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

DECLARE @department varchar(10)
DECLARE @average decimal(19,4)
DECLARE @maximum decimal(19,4)
DECLARE @minimum decimal(19,4)

SET @department = '生产制造部'

EXEC SalaryByDepartment @department,
                                           @average OUTPUT,
                                           @maximum OUTPUT,
                                           @minimum OUTPUT 

SELECT '平均薪资:'+CONVERT(nvarchar, @average),
               '最高薪资:'+CONVERT(nvarchar,@maximum),
               '最低薪资:'+CONVERT(nvarchar,@minimum)