sample84.sql

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

/* 文件名称: Sample84.sql */

USE 北风贸易
GO

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

CREATE PROCEDURE MultipleThreeValue
@Number1 int,
@Number2 int,
@Number3 int 
AS
RETURN @Number1 * @Number2 * @Number3