proceduredemo1.sql

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

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

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

CREATE PROCEDURE AverageSalary
AS
SELECT AVG(目前薪资) FROM 飞狐工作室

GO