【007】补丁工具需要的存储过程

/****** Object:  StoredProcedure [dbo].[AllocBuildSerials]    Script Date: 2021/11/1 10:13:43 ******/
SET ANSI_NULLS ON
GO

SET QUOTED_IDENTIFIER ON
GO

CREATE OR ALTER   PROCEDURE [dbo].[AllocBuildSerials] 
           @AllocCount INT OUTPUT,
           @StartSN BIGINT OUTPUT 
    AS 
BEGIN 
    DECLARE @ReturnValue INT;
    DECLARE @InstanceName NVARCHAR(256);
    DECLARE @DatabaseName NVARCHAR(256);    
    SET @InstanceName=CONVERT(NVARCHAR(256), SERVERPROPERTY('servername'));
    SET @DatabaseName=DB_NAME();
    EXEC    [dbo].[CLR_AllocSerials] @AllocCount,@InstanceName,@DatabaseName,@StartSN OUTPUT,@ReturnValue OUTPUT
    RETURN @ReturnValue
END

GO