ODBC Server Reference Manual

Transact-SQL Language
HP NonStop ODBC Server Reference Manual—429151-002
4-35
Comments
Comments
User-written comments annotate SQL statements and statement blocks.
The syntax of a comment is as follows:
Comments in the NonStop ODBC Server work the same as comments in
Transact-SQL except that comments in the NonStop ODBC Server cannot be nested.
Summary of Statements
The SQL statements you can use with the NonStop ODBC Server are a subset of the
SQL Server Transact-SQL statements. This section lists the Transact-SQL statements
and summarizes how each supported statement differs when used with the NonStop
ODBC Server. The statements are divided into the following categories:
•
SQL statements
•
Control-of-flow statements
•
Defaults, rules, and triggers
•
Stored procedures
•
Storage allocation
•
Transaction logging
•
Miscellaneous statements
Ordinarily, if you use an unsupported statement with the NonStop ODBC Server, an
error message is generated. You can establish a user profile option, however, to ignore
errors from unsupported features. This could be useful when running an application
that uses a feature whose action is not required, such as GRANT and REVOKE.
Table 4-13. The Order in Which NULL Values Are Displayed
Clause In Transact-SQL
When Executed Using the
NonStop ODBC Server
GROUP BY NULL values form their own
group.
Same as Transact-SQL
ORDER BY NULL values come before all
others.
NULL values come after all
others.
SELECT statement 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 Transact-SQL
/* text-of-the-comment */