USP_DATALIST_QUERYVIEWADHOCQUERIES
Returns a list of ad-hoc queries for a particular query view.
Parameters
| Parameter | Parameter Type | Mode | Description |
|---|---|---|---|
| @QUERYVIEWID | uniqueidentifier | IN | Input parameter indicating the context ID for the data list. |
Definition
Copy
create procedure dbo.USP_DATALIST_QUERYVIEWADHOCQUERIES(@QUERYVIEWID uniqueidentifier)
as
set nocount on;
select ID,
NAME
from dbo.ADHOCQUERY
where QUERYVIEWCATALOGID = @QUERYVIEWID