UFN_ADHOCQUERY_IDSETINUSE
Return
| Return Type |
|---|
| bit |
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @IDSETREGISTERID | uniqueidentifier | IN | |
| @QUERYDEFINITIONXML | xml | IN |
Definition
Copy
CREATE function dbo.[UFN_ADHOCQUERY_IDSETINUSE]
(
@IDSETREGISTERID uniqueidentifier,
@QUERYDEFINITIONXML xml /* NOTE: This value is no parameter is no longer used; you may pass NULL for this parameter */
)
returns bit
as
begin
declare @RESULT bit = 0;
if exists(select 1 from [dbo].[ADHOCQUERYIDSETDEPENDENCY] where [IDSETREGISTERID] = @IDSETREGISTERID)
begin
set @RESULT = 1;
end
return @RESULT;
end;