UFN_QUERYVIEW_GETMARTKEYFROMID

Return

Return Type
nvarchar(255)

Parameters

Parameter Parameter Type Mode Description
@QUERYVIEWID uniqueidentifier IN

Definition

Copy


create function dbo.UFN_QUERYVIEW_GETMARTKEYFROMID (@QUERYVIEWID uniqueidentifier)
  returns nvarchar(255)
  with execute as caller
  as 

  begin

    declare @MARTKEY nvarchar(255) = null
    set @MARTKEY = (select [MARTKEY] from dbo.[QUERYVIEWCATALOG] where [ID] = @QUERYVIEWID)
      return @MARTKEY

  end