ODBC Server Reference Manual

Transact-SQL Language
HP NonStop ODBC Server Reference Manual—429151-002
4-43
Adding Multiple Columns
The DEPT table is registered in the NonStop SQL/MP catalog PERSNL on the disk
volume DISK01 on the node TEST.
Adding Multiple Columns
If you add multiple columns with one ALTER TABLE statement and the statement
contains errors, the results can be different than if the statement were executed using
SQL Server.
Because NonStop SQL/MP does not allow you to add multiple columns with one
statement, the NonStop ODBC Server translates the ALTER TABLE statement to
multiple NonStop SQL/MP ALTER TABLE statements. Therefore, even if one of the
statements contains an error, the other statements will be executed and will add the
specified columns. In SQL Server, if one of the column-name clauses contains an
error, the statement fails and none of the columns are added.
NonStop ODBC Server Compared With SQL Server
When used through the NonStop ODBC Server, ALTER TABLE differs from the SQL
Server implementation in the following ways:
Feature In SQL Server
In Programs Used With the NonStop
ODBC Server
Can ALTER TABLE be
inside a transaction?
No Yes, if the table is audited.
Can you add BIT type
columns?
No Yes. The NonStop ODBC Server maps the
BIT data type to the NonStop SQL/MP
SMALLINT data type.
Maximum sum of the
lengths of all columns for
a table.
1962 bytes The maximum row length allowed in
NonStop SQL/MP, as given in the NonStop
SQL/MP Reference Manual.