USING

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:

• For more information on aliasing field-expressions, see the SELECT Clause Reference.

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:

Improving Query Readability

© 2004 Microsoft Corporation. All rights reserved.