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).
-
T-SQL and NULLs T-SQL and NULL values.
Related Pages
-
Differences between T-SQL, ANSI SQL and other variants used by source types.
-