ODBC Server Reference Manual

Transact-SQL Language
HP NonStop ODBC Server Reference Manual—429151-002
4-86
INTO Clause
[ table-reference.]column-name column-heading
retrieves the specified column and replaces the heading of the retrieved column
with the specified column-heading.
expression
is an expression. Expressions are described under Language Elements on
page 4-5.
aggregate-function
is one of the following aggregate functions:
AVG
COUNT
MAX
MIN
SUM
Aggregates are described under Language Elements on page 4-5.
INTO Clause
The INTO clause of the SELECT statement is not supported in the NonStop ODBC
Server and, if included, causes an error message. The clause has the following syntax:
table-name
is not supported.
FROM Clause
The FROM clause of the SELECT statement specifies the tables and views used in the
SELECT statement and has the following syntax:
table-reference
is a table or view used in the SELECT statement. The table-name or
view-name can be qualified with the database name and owner name.
[ INTO [ [database.]owner. ] table-name ]
FROM table-reference [ correlation-name ] [ HOLDLOCK ]
[, table-reference [ correlation-name ] [ HOLDLOCK ] ] ...
table-reference is:
[ [database.]owner.] { table-name }
{ view-name }