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