USP_ADHOCQUERY_DELETEIDSET
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @ADHOCQUERYID | uniqueidentifier | IN | |
| @CHANGEAGENTID | uniqueidentifier | IN |
Definition
Copy
create procedure [dbo].[USP_ADHOCQUERY_DELETEIDSET]
@ADHOCQUERYID [uniqueidentifier],
@CHANGEAGENTID [uniqueidentifier] = null
with execute as owner
as
declare @FUNCTIONNAME as nvarchar(128)
declare @FUNCTIONNAMEEXISTS as nvarchar(128)
-- drop existing tv function
set @FUNCTIONNAME = dbo.UFN_ADHOCQUERY_MAKEIDSETFUNCTIONNAME(@ADHOCQUERYID)
exec USP_IDSET_DELETE @FUNCTIONNAME, @FUNCTIONNAMEEXISTS, @CHANGEAGENTID
-- remove from ID Set register
exec USP_IDSETREGISTER_DELETEFORADHOCQUERY @ADHOCQUERYID, @CHANGEAGENTID
return 0