Contents
Chapter 1: 
Overview
 
  • 1.1 Getting Started
  • 1.2 TSQL Language Implementation
    • Chapter 2: 
    Caché TSQL Constructs
     
  • 2.1 Current Limitations
  • 2.2 Commonly Used Constructs
  • 2.2.1 Local Temporary Tables
  • 2.2.2 SQL Expressions in ObjectScript Context
  • 2.2.3 Error Handling
  • 2.2.4 Transactions
  • 2.2.5 Cursor Name Management
  • 2.2.6 Table References
  • 2.2.7 Generalized Queries
  • 2.2.8 EXEC Statement
  • 2.2.9 Data Types
  • 2.2.10 Comments, Blank Lines, and Semicolons
  • 2.2.11 System Tables
    • Chapter 3: 
    TSQL Commands
     
  • 3.1 Data Definition (DDL) Statements
  • 3.1.1 CREATE TABLE
  • 3.1.2 DROP TABLE
  • 3.1.3 CREATE INDEX
  • 3.2 Data Management Statements
  • 3.2.1 DELETE
  • 3.2.2 INSERT
  • 3.2.3 UPDATE
  • 3.2.4 TRUNCATE TABLE
  • 3.3 Query Statements
  • 3.3.1 SELECT
  • 3.3.2 FETCH Cursor
  • 3.3.3 UPDATE STATISTICS
  • 3.4 Control Flow Statements
  • 3.4.1 GOTO and Labels
  • 3.5 Assignment Statements
  • 3.5.1 DECLARE
  • 3.5.2 SET
  • 3.6 Transaction Statements
  • 3.6.1 SET TRANSACTION ISOLATION LEVEL
  • 3.6.2 BEGIN TRANSACTION
  • 3.6.3 COMMIT TRANSACTION
  • 3.6.4 ROLLBACK TRANSACTION
  • 3.6.5 CHECKPOINT
  • 3.7 Other Statements
  • 3.7.1 CREATE PROCEDURE / CREATE FUNCTION
  • 3.7.2 DROP PROCEDURE
  • 3.7.3 EXECUTE
  • 3.7.4 GRANT
  • 3.7.5 PRINT
  • 3.7.6 USE database
  • 3.8 InterSystems Extensions
  • 3.8.1 CACHE
  • 3.8.2 IMPORTASQUERY
  • 3.8.3 SETTINGS
    • Chapter 4: 
    TSQL Functions
     
  • 4.1 Supported Functions
  • 4.1.1 ABS
  • 4.1.2 ASCII
  • 4.1.3 CAST
  • 4.1.4 CEILING
  • 4.1.5 CHAR
  • 4.1.6 CHARINDEX
  • 4.1.7 CONVERT
  • 4.1.8 CURRENT_TIMESTAMP
  • 4.1.9 CURRENT_USER
  • 4.1.10 DATALENGTH
  • 4.1.11 DATEADD
  • 4.1.12 DATEDIFF
  • 4.1.13 DATENAME
  • 4.1.14 DAY
  • 4.1.15 DB_NAME
  • 4.1.16 FLOOR
  • 4.1.17 GETDATE
  • 4.1.18 HOST_NAME
  • 4.1.19 ISNULL
  • 4.1.20 ISNUMERIC
  • 4.1.21 LEFT
  • 4.1.22 LEN
  • 4.1.23 LOG
  • 4.1.24 LOWER
  • 4.1.25 LTRIM
  • 4.1.26 MONTH
  • 4.1.27 NULLIF
  • 4.1.28 OBJECT_ID
  • 4.1.29 PATINDEX
  • 4.1.30 POWER
  • 4.1.31 RAND
  • 4.1.32 RAISERROR
  • 4.1.33 REPLACE
  • 4.1.34 REPLICATE
  • 4.1.35 REVERSE
  • 4.1.36 RIGHT
  • 4.1.37 ROUND
  • 4.1.38 RTRIM
  • 4.1.39 SCOPE_IDENTITY
  • 4.1.40 SIGN
  • 4.1.41 SPACE
  • 4.1.42 STR
  • 4.1.43 STUFF
  • 4.1.44 SUBSTRING
  • 4.1.45 SUSER_NAME
  • 4.1.46 UPPER
  • 4.1.47 USER
  • 4.1.48 USER_ID
  • 4.1.49 USER_NAME
  • 4.1.50 YEAR
  • 4.2 Unsupported Functions
    • Chapter 5: 
    TSQL Variables
     
  • 5.1 Host Variables and Literals
  • 5.2 Special Variables
  • 5.2.1 @@DATEFIRST
  • 5.2.2 @@ERROR
  • 5.2.3 @@FETCH_STATUS
  • 5.2.4 @@IDENTITY
  • 5.2.5 @@ROWCOUNT
  • 5.2.6 @@SPID
  • 5.2.7 @@SQLSTATUS
  • 5.2.8 @@TRANSCOUNT
  • 5.2.9 @@VERSION
    • Chapter 6: 
    Using the TSQL Shell
     
  • 6.1 Getting Started
  • 6.1.1 Compiling a Table Definition
  • 6.1.2 Using the GENRAW Setting
  • 6.1.3 TSQL Shell Help
  • 6.1.4 Exiting the TSQL Shell
  • 6.2 Qualifiers
  • 6.3 Settings
    • Copyright  © 1997-2006, InterSystems Corp. Build: Caché v5.2 (290U-290U) Last updated: 2006-03-22 10:03:07 Source: GTSQ.xml