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 Supported Functions Unsupported Functions TSQL Variables Local Variables @@ Special Variables TSQL System Stored Procedures sp_addtype sp_droptype sp_procxmode (Sybase only)
