Caché Transact-SQL (TSQL) Migration Guide

• About This Book
• Overview
• Migrating Existing TSQL Applications
• Writing and Executing TSQL on Caché
• Caché TSQL Constructs
• Table References
• Temporary Tables
• System Tables
• Transactions
• Cursor Name Management
• SYSOBJECTS References
• Caché TSQL Language Elements
• Literals
• 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
• TRACE
• TSQL Functions
• Supported Functions
• Unsupported Functions
• TSQL Variables
• Local Variables
• @@ Special Variables