USING

<using_clause> ::= USING <field_expr> AS <alias> [ , <field_expr> AS <alias> ... ]

The USING clause declares aliased field-expressions that do not appear in the output records but can be referenced anywhere in the query.
The USING clause is employed to improve query readability.


Remarks:


Examples:

A. Declaring aliased field-expressions

The following example query returns the "account name" portion of the fully-qualified account name that appears in the resolved "SID" field of the EVT input format:
SELECT Username
USING TO_LOWERCASE( RESOLVE_SID(Sid) ) AS FQAccount, 
	EXTRACT_TOKEN( FQAccount, 1, '\\') AS Username
FROM Security

See also:

Field Expressions
Field Names and Aliases
SELECT

Improving Query Readability


© 2004 Microsoft Corporation. All rights reserved.