Seed Statement
The seed statement is a nonrecursive SELECT statement that retrieves row data from other tables to store in the named query.
Syntax Element … |
Specifies … |
DISTINCT |
that only one row is to be returned from any set of duplicates that might result from a given expression list. Two rows are considered duplicates only if each value in one is equal to the corresponding value in the other. |
ALL |
that all rows, including duplicates, are to be returned in the results of the expression list. This is the default value. |
* |
that all columns of all tables referenced in the FROM clause of the seed statement be returned. When qualified by table_name, specifies that all columns of table_name only are to be returned. |
expression |
any valid SQL expression, including scalar UDFs. |
AS |
an optional introduction to expression_alias_name. |
expression_alias_name |
an alias for the expression. |
table_name |
the name of a table, derived table, or view. table_name.* in the select list can define the table from which rows are to be returned when two or more tables are referenced in the FROM clause. |
FROM |
an introduction to the names of one or more tables, views, or derived tables from which expression is to be derived. The FROM clause in a seed statement cannot specify the TABLE option. |