ODBC Server Reference Manual

Summary of Support for SQL Server Features
HP NonStop ODBC Server Reference Manual—429151-002
B-10
NULL Values
The following table summarizes NonStop ODBC Server support of the SQL Server join
operators.
NULL Values
The NonStop ODBC Server supports NULL values. The only difference between NULL
values in SQL Server and NULL values in the NonStop ODBC Server is the order in
which data is displayed.
The following table summarizes how NULL values affect the order in which data is
displayed in SQL Server and in statements executed using the NonStop ODBC Server.
Parameters
The NonStop ODBC Server supports both input parameters and input/output
parameters, values supplied to stored procedures at the time of invocation.
Operator NonStop ODBC Server Support
=x
>x
<x
>= x
<= x
!= x
!> x
!< x
*= x
=* x
x Indicates a supported operator
Clause In SQL Server
When Executed Using the
NonStop ODBC Server
GROUP BY NULL values form their own
group
Same as SQL Server
ORDER BY NULL values come before all
others.
NULL values come after all
others.
SELECT clause with the
DISTINCT keyword
NULL values are considered
duplicates of each other. Only
one NULL is selected, no matter
how many are encountered.
Same as SQL Server