UFN_APPUSER_HASQUERY

Returns true if the user owns an ad-hoc query or a smart query

Return

Return Type
bit

Parameters

Parameter	Parameter Type	Mode	Description
@ID	uniqueidentifier	IN

Definition

Copy



CREATE function dbo.UFN_APPUSER_HASQUERY (@ID uniqueidentifier)
returns bit
as
begin
    declare @queryid uniqueidentifier;

    select @queryid = ID
    from dbo.ADHOCQUERY
    where OWNERID = @ID;

    if @queryid is null
    begin
        select @queryid = ID
        from dbo.SMARTQUERYINSTANCE
        where OWNERID = @ID;
    end

    if @queryid is null
        return 0;

    return 1;
end