UFN_SMARTQUERYINSTANCE_GETIDSETID

Returns the selection ID for a smart query instance, if a selection exists.

Return

Return Type
uniqueidentifier

Parameters

Parameter Parameter Type Mode Description
@SMARTQUERYINSTANCEID uniqueidentifier IN

Definition

Copy


      create function dbo.[UFN_SMARTQUERYINSTANCE_GETIDSETID]
      (
        @SMARTQUERYINSTANCEID uniqueidentifier
      )
      returns uniqueidentifier
      as
      begin
        declare @ID uniqueidentifier;
        select @ID = [IDSETREGISTERID] from dbo.[IDSETREGISTERSMARTQUERYINSTANCE] where [SMARTQUERYINSTANCEID] = @SMARTQUERYINSTANCEID;
        return @ID;
      end