Transact-SQL (TSQL) Migration Guide Planning and Performing TSQL Migration Why Migrate to InterSystems IRIS? Planning your Migration Executing the Plan Writing and Executing TSQL on InterSystems IRIS InterSystems TSQL Constructs Table References Temporary Tables System Tables Transactions Cursor Name Management SYSOBJECTS References InterSystems TSQL Language Elements Literals Variables Identifiers Data Types Operators TSQL Commands Data Definition Language (DDL) Statements Data Management Language (DML) Statements Query Statements Flow of Control Statements Assignment Statements Transaction Statements Procedure Statements Other Statements InterSystems Extensions TSQL Settings DIALECT ANSI_NULLS CASEINSCOMPARE QUOTED_IDENTIFIER Equal Literal Replacement TRACE Data Collation and String Truncation Timestamp and Time Precision Settings for Temporary Databases TSQL Functions ABS ACOS ASCII ASIN ATAN AVG CAST CEILING CHAR CHAR_LENGTH / CHARACTER_LENGTH CHARINDEX COALESCE COL_NAME CONVERT COS COT COUNT CURRENT_DATE CURRENT_TIME CURRENT_TIMESTAMP CURRENT_USER DATALENGTH DATEADD DATEDIFF DATENAME DATEPART DAY DB_NAME DEGREES ERROR_MESSAGE ERROR_NUMBER EXEC EXP FLOOR GETDATE GETUTCDATE HOST_NAME INDEX_COL ISNULL ISNUMERIC LEFT LEN LOG LOG10 LOWER LTRIM MAX MIN MONTH NCHAR NEWID NOW NULLIF OBJECT_ID OBJECT_NAME PATINDEX PI POWER QUOTENAME RADIANS RAND REPLACE REPLICATE REVERSE RIGHT ROUND RTRIM SCOPE_IDENTITY SIGN SIN SPACE SQRT SQUARE STR STUFF SUBSTRING SUM SUSER_NAME SUSER_SNAME TAN TEXTPTR TEXTVALID UNICODE UPPER USER USER_NAME YEAR Unsupported Functions TSQL Variables Local Variables @@ Special Variables TSQL System Stored Procedures sp_addtype sp_droptype sp_procxmode (Sybase only)