USP_INSTALLATIONINFO_GETUPDATEPRODUCTINFORMATION

Returns information used for updating product information.

Parameters

Parameter	Parameter Type	Mode
@UPDATEPRODUCTINFORMATION	bit	INOUT
@INSTALLATIONNAME	nvarchar(100)	INOUT
@SERIALNUMBER	nvarchar(50)	INOUT
@CLARIFYSITEID	nvarchar(50)	INOUT
@DATABASEVERSION	int	INOUT

Definition

Copy



create procedure dbo.USP_INSTALLATIONINFO_GETUPDATEPRODUCTINFORMATION
(
    @UPDATEPRODUCTINFORMATION bit output,
    @INSTALLATIONNAME nvarchar(100) output,
    @SERIALNUMBER nvarchar(50) output,
    @CLARIFYSITEID nvarchar(50) output,
    @DATABASEVERSION int output
)
as
    set nocount on;

    select
        @UPDATEPRODUCTINFORMATION = UPDATEPRODUCTINFORMATION,
        @INSTALLATIONNAME = INSTALLATIONNAME,
        @SERIALNUMBER = SERIALNUMBER,
        @CLARIFYSITEID = CLARIFYSITEID
    from
        dbo.INSTALLATIONINFO
    where
        ID = 1;

    select top 1 @DATABASEVERSION = cast(replace(name, 'REVISIONLOG', '') as int) from sys.tables where name like 'REVISIONLOG%' order by 1 desc

    return 0;