UFN_QUERYVIEW_GETMARTKEY

Return

Return Type
nvarchar(255)

Parameters

Parameter Parameter Type Mode Description
@OBJECTNAME nvarchar(128) IN

Definition

Copy


create function dbo.UFN_QUERYVIEW_GETMARTKEY(@OBJECTNAME nvarchar(128))
  returns nvarchar(255)
  with execute as caller
  as 

  begin

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

  end