MS SQLServer

supported

Notes

General:

DB engine as service

y

own authentication

y

Trusted authentication

y

Connection:

OLE DB

y

ODBC

y

ODBC connection-string issues

Select Method=Cursor

must be applied

JDBC

y

MF used init. Statements

none

MF used final. Statements

none

SQL:

DB-object-name qualification

[] or ""

support for DB-schemas

y

identity support

y

MF: read back identity value

@@IDENTITY

sub select support

y

JOIN support

y

MF: upper function

UPPER()

SQL-Execution:

exec. multiple-stat. in one

y

command separator

';' or 'GO'

special error handling

n

retrieve parameter types

y

with limits

special issues when using ?

y

DATETIME datatype not supported when using ODBC

Transactions:

Flat transactions supported

y

Start flat-transaction via execution of SQL-command

y

a MUST when using nested transactions. Mixing API-transaction handling and SQL-transaction-commands is not possible

Nested transactions supported

y

via SAVEPOINTS

set transaction isolation

y

MF: begin transaction

BEGIN TRANSACTION

MF: commit transaction

COMMIT TRANSACTION

MF: rollback transaction

ROLLBACK TRANSACTION

MF: set save point

SAVEPOINT

MF: rollback to save point

ROLLBACK TO

MF used init. Statements

none