可以的。
select_into_statement
SELECT
[DISTINCT | ALL]
{* | select_item[, select_item]...}
INTO
{variable_name[, variable_name]... | record_name}
FROM
{table_reference | (subquery)}
[alias]
[, {table_reference | (subquery)}
[alias] ]...
rest_of_select_statement; select_item
{ function_name[(parameter_name[, parameter_name]...)]
| NULL
| numeric_literal
| [schema_name.]{table_name | view_name}.*
| [[schema_name.]{table_name. | view_name.}]column_name
| sequence_name.{CURRVAL | NEXTVAL}
| 'text'}
[ [AS] alias ]table_reference
[schema_name.]{table_name | view_name}[@dblink_name]
select_into_statement
SELECT
[DISTINCT | ALL]
{* | select_item[, select_item]...}
INTO
{variable_name[, variable_name]... | record_name}
FROM
{table_reference | (subquery)}
[alias]
[, {table_reference | (subquery)}
[alias] ]...
rest_of_select_statement; select_item
{ function_name[(parameter_name[, parameter_name]...)]
| NULL
| numeric_literal
| [schema_name.]{table_name | view_name}.*
| [[schema_name.]{table_name. | view_name.}]column_name
| sequence_name.{CURRVAL | NEXTVAL}
| 'text'}
[ [AS] alias ]table_reference
[schema_name.]{table_name | view_name}[@dblink_name]
在sybase和mssql中是成功的