search condition

Second, because there may not be a primary key over the table, the search condition of the query may be unable to uniquely identify the row.

There is no limit to the number of predicates , separated by an AND clause, that can be included in a search condition .

Indicates that the data column is included in a search condition for the query (is part of a WHERE or HAVING clause).

Specifies an additional search condition expression for the data column, linked to previous expressions with a logical OR.

If you use an aggregate function in a search condition, the condition involves a summary and must therefore be part of the HAVING clause.

If so, the Query and View Designer automatically converts the search condition into a join.

Searches that use the read or unread state of a message as a search condition also have a special performance impact.

Parentheses can be used to override this precedence in a search condition.

If language_term is specified, the language it represents will be applied to all elements of the search condition.

If you do not specify a search condition, all rows from the source table will be copied to the destination table.

Indicates that the second search condition must not be present for a match.

NOT reverses the result of a search condition.

Following is an example of the Predicate showing selectivity of a search condition.

There is no limit to the number of predicates that can be included in a search condition.

The search condition, WHERE clause, of a view to make the view dynamically comply with the user or environment at run time.

If you do not specify a search condition, all rows will be copied to the destination table.

The HAVING clause search condition is expressing a predicate over the properties of the group.

Specifies that all columns in the table registered for full-text searching should be used to search for the given contains search condition.

A searched DELETE statement deletes multiple rows if the search condition does not uniquely identify a single row.

The search for those documents returns the complete "comments" documents that are satisfying the search condition.

A filter is a search condition defined by the contents of a SQL WHERE clause.

The only search condition that returns TRUE is the IS NULL predicate.

Whatever the contains_search_condition you use, make sure the search text you type is enclosed in double quotation marks ( "search text" ).

Specify a search condition (possibly compound) for use in a WHERE clause that filters the records.

The search condition may not contain any of the other columns in the queue.

If you do not specify a search condition, all rows will be deleted.

If you do not specify a search condition, all rows will be updated.

Loading variables with data values and then using them to specify a search condition in a WHERE clause.

Explains how to include several data columns as part of the search condition for a query.

The word "ran" in the document matches the search condition because of stemming.

The following table summarizes search condition operators that are defined for standard SQL.

Specifies a search condition (filter) for the associated data column.

Search specific document contents based on a given search condition without needing to render the ODF document in editors.

The HAVING clause additionally excludes rows not meeting its search condition.

Specifies a search condition for a group or an aggregate.

Specifies the search condition for the rows returned by the query.

The recordset selects only those records that meet the search condition you specified.

Text of search condition for a check constraint.

The search condition, in this case "learning curve" , can be quite complex and can be composed of one or more terms.

In many full-text queries, the number of items matching the search condition is very large.

Similarly, if you choose the search type FREETEXT, ItemFinder uses the freetext_search_condition syntax.

The search condition can also be the condition upon which a join is based.

Specifies the search condition for the group to meet.

The default value in the drop-down list is based on the type of the data column to use in the WHERE clause search condition.

If you add a search condition, you can aggregate the subset of rows that meet that condition.

Searched updates specify a search condition to qualify the rows to delete.

Searched deletes specify a search condition to qualify the rows to delete.

The WHERE clause excludes rows not meeting its search condition.

Specifies the search condition for the group or the aggregate to meet.

Specifies a search condition to restrict the rows returned.

If you choose the search type CONTAINS, ItemFinder uses the contains_search_condition syntax.

The search condition need not refer to the column being updated.

Returns the set that results from filtering a specified set based on a search condition.

Filter column, enter a search condition.

The Content List widget renders the new work items according to the new search condition.

A join condition is simply a search condition.

For each search condition, you can specify either a literal or a parameterized value.

For example, using the "rear reflector" search condition above, type in the text box: rear reflector.

This topic discusses the conventions you must use when entering the following types of literal values for a search condition

Enter the search condition in the text box, and click