USP_CLOUDCATALOGDEFINITION_GETDEFINITION

Returns the URL, Name and Description from the CLOUDCATALOGDEFINITION table

Parameters

Parameter	Parameter Type	Mode
@ID	uniqueidentifier	IN
@DATALOADED	bit	INOUT
@URL	UDT_WEBADDRESS	INOUT
@NAME	nvarchar(100)	INOUT
@DESCRIPTION	nvarchar(255)	INOUT
@TSLONG	bigint	INOUT

Definition

Copy



create procedure dbo.USP_CLOUDCATALOGDEFINITION_GETDEFINITION
    (@ID uniqueidentifier,
     @DATALOADED bit = 0 output,
     @URL UDT_WEBADDRESS output, 
     @NAME nvarchar(100) output,
     @DESCRIPTION nvarchar(255) output,
     @TSLONG bigint = 0 output
     )
as

    set nocount on;
    set @DATALOADED = 0;
    set @TSLONG = 0;

    select @DATALOADED = 1,
            @URL = URL,
            @NAME = NAME,
            @DESCRIPTION = DESCRIPTION,
            @TSLONG = TSLONG
    from
        dbo.CLOUDCATALOGDEFINITION
    where
        ID = @ID;

    return 0;