Search Documentation by Keyword

usp_Core_Query

You are here:
← All Topics

This stored procedure dynamically selects data from a table or a view. It is the primary method of extracting test result data from the database. Omitted parameters will acquire their default values.

Parameters

ParameterTypeRDescription
@TableSchemanvarchar(128)Schema of object to be queried.

Default: 'dbo'
@TableNamenvarchar(128)*Name of object to be queried. Can be either a table or a view.
@ColumnActionchar(1)Specifies whether columns matching the patterns expressed in @ColumnList should be [I]ncluded or [E]xcluded.

Default: 'E'
@ColumnListnvarchar(max)Comma-delimited list of LIKE-syntax patterns that specify columns to be included or excluded form the query. Escape special characters with a backslash.

Default: '%RunId,CADIS\_SYSTEM\_%'
@Wherenvarchar(max)Logical expression that will be applied to the query in a WHERE clause.

Default: NULL
@OrderBynvarchar(max)Column list that will be applied to the query in an ORDER BY clause.

Default: NULL
×