select and the IDENTITY column In the reference section for the select command, a bulleted item describes how to add a new IDENTITY column and use precision to specify the numeric datatype:
A specification to add a new IDENTITY column to the result table:
column_name = identity(precision)
Beginning with Adaptive Server Enterprise version 12.5.4, you can specify the IDENTITY column with int, smallint, and tinyint, as well as precision.
A specification to add a new IDENTITY column to the result table:
column_name = identity(int | smallint | tinyint | precision)
If you specify int, smallint, or tinyint, the resulting column is an integer. If you specify precision, the result is a numeric datatype.
select into existing table The reference section for the select command for Adaptive Server version 15.0 described the following select parameter:
[existing table] [[database.]owner.]table_name
indicates that you are selecting data into a proxy or other existing table. You cannot select data into a nonproxy table that has indexes. The column list in the select list must match the type, length, and number in the target table.
This information is incorrect. Replace it with the following:
existing table table_name
indicates that you are selecting data into a proxy table. You cannot use this select into with any other table type except proxy. The column list in the select list must match the type, length, and number in the proxy table.
In addition, example 13—which updated the existing authors table to include only books priced over $20—is incorrect, as it implied that the authors table existed, without including the existing keyword.