proceduredemo14.sql

100多个SQL小程序,包含游标,基本增删改查,希望多你有用

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

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

CREATE PROCEDURE dbo.MultipleNumber
@mult1 int,
@mult2 int,
@result int OUTPUT
AS
SET @result = @mult1 * @mult2

GO