ODBC Server Reference Manual

Transact-SQL Language
HP NonStop ODBC Server Reference Manual—429151-002
4-31
Aggregates
LIKE Operator—Differences From SQL Server
When used through the NonStop ODBC Server, the behavior of the LIKE operator
differs from its behavior in SQL Server in the following ways:
For more information, see the following documents:
Aggregates
The NonStop ODBC Server supports all of the Transact-SQL aggregate functions
(AVG, COUNT, MAX, MIN, and SUM).
Table 4-11 summarizes the primary differences between using aggregate functions
with SQL Server and using them with the NonStop ODBC Server.
AVG
The AVG aggregate function has the following syntax:
Feature In SQL Server In the NonStop ODBC Server
Are trailing blanks significant? No Yes
Do character comparisons distinguish
between uppercase and lowercase?
No Yes
For Information On See
Expressions Microsoft SQL Server Transact-SQL Reference
Boolean expressions Microsoft SQL Server Transact-SQL Reference
Table 4-11. NonStop ODBC Server Support of Aggregate Functions
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 COUNT?
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 Transact-SQL COMPUTE BY clause,
which is not supported by the NonStop
ODBC Server.
AVG ( [ DISTINCT ] expression )