ODBC Server Reference Manual

Summary of Support for SQL Server Features
HP NonStop ODBC Server Reference Manual—429151-002
B-2
Aggregates
Aggregates
The NonStop ODBC Server supports all of the SQL Server aggregate functions:
•
AVG
•
COUNT
•
MAX
•
MIN
•
SUM
The primary differences between aggregate functions in SQL Server and in the
NonStop ODBC Server are the following:
For detailed information on aggregates, see Aggregates
on page 4-31.
The NonStop ODBC Server supports batch queries.
The following table summarizes how batches differ in SQL Server and the NonStop
ODBC Server.
Feature In SQL Server In the NonStop ODBC Server
Data type of the results of
AVG, COUNT, and SUM
Depends on the
expression being
evaluated.
Always floating point
Data type of the results of
MAX and MIN
Depends on the
expression being
evaluated.
Depends on the expression
being evaluated. An INT
expression returns a floating
point value.
What is the default if the
DISTINCT clause is omitted
from the COUNT function?
All rows are counted Only distinct rows are counted.
Are aggregates and row
aggregates distinguished?
Yes No, because the row
aggregates are part of the
SQL Server COMPUTE BY
clause, which is not supported
by the NonStop ODBC Server.
Feature In SQL Server In the NonStop ODBC Server
Executing USE DATABASE
inside a batch
Does not take effect until
the batch is executed
Takes effect immediately
Are Control-of-Flow
statements supported?
Yes No