Skip to content

Latest commit

 

History

History
20 lines (18 loc) · 1.21 KB

File metadata and controls

20 lines (18 loc) · 1.21 KB
title Escape Sequences
description Escape Sequences
author David-Engel
ms.author davidengel
ms.date 01/19/2017
ms.service sql
ms.subservice connectivity
ms.topic conceptual
helpviewer_keywords
SQL statements [ODBC], interoperability
escape sequences [ODBC], determining if supported
interoperability of SQL statements [ODBC], escape sequences

Escape Sequences

ODBC defines escape sequences containing standard grammar for date, time, timestamp, and datetime interval literals, scalar function calls, LIKE predicate escape characters, outer joins, and procedure calls. Interoperable applications should use these sequences whenever possible.

To determine if a driver supports the escape sequences for date, time, timestamp, or datetime interval literals, an application calls SQLGetTypeInfo. If the data source supports a date, time, timestamp, or datetime interval data type, it must also support the corresponding escape sequence. To determine whether the other escape sequences are supported, an application calls SQLGetInfo.

For more information, see Escape Sequences in ODBC, later in this section.