ODBC Server Reference Manual

Summary of Support for SQL Server Features

HP NonStop ODBC Server Reference Manual—429151-002

B-3

Browse Mode

The NonStop ODBC Server does not support browse mode. The FOR BROWSE

clause is an unsupported clause of the SELECT statement.

For detailed information on the SELECT statement, see SELECT on page 4-82.

Comments

The NonStop ODBC Server supports user-written comments. The syntax is the same

as in SQL Server. Nested comments, however, are not supported.

For detailed information on comments, see Comments on page 4-35.

COMPUTE BY Clause

The NonStop ODBC Server does not support the COMPUTE BY clause, which is a

clause of the SELECT statement.

For detailed information on the SELECT statement, see SELECT on page 4-82.

Data Types

The NonStop ODBC Server supports most SQL Server data types. When you create

objects and data, however, the NonStop ODBC Server maps the data to a HP NonStop

SQL/MP data type.

Table B-1 summarizes the SQL Server data types and the corresponding NonStop

SQL/MP data types.

Table B-1. Conversion of SQL Server Data Types to NonStop SQL/MP Data

Types (page 1 of 2)

SQL Server

Data Type

NonStop ODBC

Server Support Corresponding NonStop SQL/MP Data Type

BINARY – –

BIT x SMALLINT

CHAR x CHAR

DATETIME x DATETIME year to fraction (3)

FLOAT x DOUBLE PRECISION

IMAGE – –

INT x INTEGER

MONEY x DOUBLE PRECISION

x Indicates a supported data type

– Indicates an unsupported data type