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
- 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
- TSQL Variables
- TSQL System Stored Procedures