Microsoft T-SQL

T-SQL is the dialect/variant of SQL used by Microsoft SQL Server.

T-SQL expressions and functions can be used on the ETL+ Design Page, and the ETL+ Load Upsert, and ETL+ Load Replace panels.

The SQL statements and syntax used in the Extract SQL Statement panel must work with the SQL syntax supported by the ETL+ Source Driver used to connect to the associated Source Object.

In this section

T-SQL Aggregate Functions — Aggregate functions perform a calculation on a set of values, and returns a single value. MIN, MAX, and SUM are frequently used aggregate functions.

T-SQL MAX Function

T-SQL Date Expressions — Date expressions and functions supported by T-SQL / Microsoft SQL Server.

T-SQL String Constants (String Literals) — ETL+ target tables (tables and columns shown in the ETL Objects panel) only support string constants with single quotation marks, (not double quotation marks).

Related Pages

Differences between T-SQL, ANSI SQL and other variants used by source types.