ODBC Server Reference Manual

Transact-SQL Language
HP NonStop ODBC Server Reference Manual—429151-002
4-78
NonStop ODBC Server Compared With SQL Server
NonStop ODBC Server Compared With SQL Server
When used through the NonStop ODBC Server, INSERT differs from the SQL Server
implementation in the following ways:
NonStop ODBC Server Compared With NonStop SQL/MP
The corresponding NonStop SQL/MP statement is INSERT.
When used through the NonStop ODBC Server, INSERT differs from the NonStop
SQL/MP implementation in the following ways:
Feature In SQL Server
In Programs Used With the
NonStop ODBC Server
Can you insert rows into a
view that references more
than one table?
Yes, if the columns being
inserted belong to only one
table.
No, even if the columns being
inserted belong to only one table.
Locking mode used Exclusive The NonStop SQL/MP
REPEATABLE ACCESS mode,
which is functionally similar to the
SQL Server default of exclusive
mode.
Rules the SELECT
statement must follow
SQL Server rules These NonStop SQL/MP rules:
The select-list must contain
an element for each column that
you specify in the column-name
list.
A subquery cannot refer to a
table, view, or underlying table of
the view into which rows are
being inserted.
Feature In NonStop SQL/MP
In Programs Used With the
NonStop ODBC Server
Can you specify the locking
mode?
Yes No, unless you use pass-through
mode.
Default locking mode STABLE ACCESS REPEATABLE ACCESS