USE [数据库名称]GO/******    脚本日期: 11/25/2014 01:05:48 ******/SET ANSI_NULLS ONGOSET QUOTED_IDENTIFIER ONGOCREATE PROCEDURE [用户].[存储过程名称]     @epId varchar(20),    @bizname varchar(150),    @resValue varchar(2) OUTPUTASBEGIN    SET NOCOUNT ON;    declare @epName varchar(500);    declare @belongSepa varchar(6);    declare @processinstid numeric(18, 0);    declare @orgid numeric(10, 0);    SET TRANSACTION ISOLATION LEVEL SERIALIZABLE;        set @resValue = 0;    declare order_cursor CURSOR LOCAL FORWARD_ONLY KEYSET SCROLL_LOCKS FOR select ep_name,belong_sepa,processinstid,orgid from ENTERPRISE where ep_id = @epId;        OPEN order_cursor    --开始循环游标变量    FETCH NEXT FROM order_cursor INTO @epName,@belongSepa,@processinstid,@orgid;    WHILE (@@FETCH_STATUS = 0)    BEGIN    insert into BAK_OLD_EPINFO values (@epId,@epName,@processinstid,@orgid,@belongSepa,getdate());    if (@@ERROR=0)    BEGIN        SET @resValue=0; --成功        delete from ENTERPRISE where ep_id = @epId;    END    ELSE    BEGIN        SET @resValue=1; --失败    END    FETCH NEXT FROM order_cursor INTO @epName,@belongSepa,@processinstid,@orgid;        END    CLOSE order_cursor    DEALLOCATE order_cursor    SET TRANSACTION ISOLATION LEVEL READ COMMITTED;END

declare @epid varchar(50);declare @epname varchar(500);declare @resvalue varchar(500);set @epid = ‘123456‘;set @epname = ‘xxxxxx‘;exec [用户].[存储过程名称] @epid,@epname,@resvalue outputprint @resvalue;