Caché Transact-SQL (TSQL) Migration Guide
Contents
[Home]  [Next]
InterSystems: The power behind what matters   
Class Reference   
Search:    

Preface : 
 
 
Chapter 1: 
 
1.1 Getting Started
1.2 TSQL Language Implementation
Chapter 2: 
 
2.1 Commonly Used Constructs
Chapter 3: 
 
3.1 Literals
       3.1.1 String Literals
       3.1.2 Empty Strings
       3.1.3 NULL
       3.1.4 Hexadecimal
       3.1.5 Reserved Words
       3.1.6 Comments, Blank Lines, and Semicolons
3.2 Identifiers
3.3 Data Types
3.4 Operators
Chapter 4: 
 
4.1 Data Definition Language (DDL) Statements
       4.1.1 CREATE TABLE
       4.1.2 ALTER TABLE
       4.1.3 DROP TABLE
       4.1.4 CREATE INDEX
       4.1.5 DROP INDEX
       4.1.6 CREATE TRIGGER
       4.1.7 DROP TRIGGER
       4.1.8 CREATE VIEW
       4.1.9 DROP VIEW
       4.1.10 CREATE DATABASE
       4.1.11 DROP DATABASE
4.2 Data Management Language (DML) Statements
       4.2.1 DELETE
       4.2.2 INSERT
       4.2.3 UPDATE
       4.2.4 READTEXT, UDATETEXT, WRITETEXT
       4.2.5 TRUNCATE TABLE
4.3 Query Statements
       4.3.1 SELECT
       4.3.2 JOIN
       4.3.3 UNION
       4.3.4 FETCH Cursor
       4.3.5 UPDATE STATISTICS
4.4 Flow of Control Statements
       4.4.1 IF
       4.4.2 WHILE
       4.4.3 CASE
       4.4.4 GOTO and Labels
       4.4.5 WAITFOR
4.5 Assignment Statements
       4.5.1 DECLARE
       4.5.2 SET
4.6 Transaction Statements
4.7 Procedure Statements
       4.7.1 CREATE PROCEDURE / CREATE FUNCTION
       4.7.2 ALTER FUNCTION
       4.7.3 DROP FUNCTION
       4.7.4 DROP PROCEDURE
       4.7.5 RETURN
       4.7.6 EXECUTE
       4.7.7 CALL
4.8 Other Statements
       4.8.1 CREATE USER
       4.8.2 CREATE ROLE
       4.8.3 GRANT and REVOKE
       4.8.4 PRINT
       4.8.5 RAISERROR
       4.8.6 UPDATE STATISTICS
       4.8.7 USE database
4.9 InterSystems Extensions
       4.9.1 CACHE
       4.9.2 IMPORTASQUERY
Chapter 5: 
 
5.1 DIALECT
5.2 ANSI_NULLS
5.3 CASEINSCOMPARE
5.4 QUOTED_IDENTIFIER
5.5 TRACE
Chapter 6: 
 
6.1 Supported Functions
       6.1.1 ABS
       6.1.2 ACOS
       6.1.3 ASCII
       6.1.4 ASIN
       6.1.5 ATAN
       6.1.6 AVG
       6.1.7 CAST
       6.1.8 CEILING
       6.1.9 CHAR
       6.1.10 CHAR_LENGTH / CHARACTER_LENGTH
       6.1.11 CHARINDEX
       6.1.12 COALESCE
       6.1.13 COL_NAME
       6.1.14 CONVERT
       6.1.15 COS
       6.1.16 COT
       6.1.17 COUNT
       6.1.18 CURRENT_DATE
       6.1.19 CURRENT_TIME
       6.1.20 CURRENT_TIMESTAMP
       6.1.21 CURRENT_USER
       6.1.22 DATALENGTH
       6.1.23 DATEADD
       6.1.24 DATEDIFF
       6.1.25 DATENAME
       6.1.26 DATEPART
       6.1.27 DAY
       6.1.28 DB_NAME
       6.1.29 DEGREES
       6.1.30 ERROR_MESSAGE
       6.1.31 ERROR_NUMBER
       6.1.32 EXEC
       6.1.33 EXP
       6.1.34 FLOOR
       6.1.35 GETDATE
       6.1.36 GETUTCDATE
       6.1.37 HOST_NAME
       6.1.38 INDEX_COL
       6.1.39 ISNULL
       6.1.40 ISNUMERIC
       6.1.41 LEFT
       6.1.42 LEN
       6.1.43 LOG
       6.1.44 LOG10
       6.1.45 LOWER
       6.1.46 LTRIM
       6.1.47 MAX
       6.1.48 MIN
       6.1.49 MONTH
       6.1.50 NCHAR
       6.1.51 NEWID
       6.1.52 NOW
       6.1.53 NULLIF
       6.1.54 OBJECT_ID
       6.1.55 OBJECT_NAME
       6.1.56 PATINDEX
       6.1.57 PI
       6.1.58 POWER
       6.1.59 QUOTENAME
       6.1.60 RADIANS
       6.1.61 RAND
       6.1.62 REPLACE
       6.1.63 REPLICATE
       6.1.64 REVERSE
       6.1.65 RIGHT
       6.1.66 ROUND
       6.1.67 RTRIM
       6.1.68 SCOPE_IDENTITY
       6.1.69 SIGN
       6.1.70 SIN
       6.1.71 SPACE
       6.1.72 SQRT
       6.1.73 SQUARE
       6.1.74 STR
       6.1.75 STUFF
       6.1.76 SUBSTRING
       6.1.77 SUM
       6.1.78 SUSER_NAME
       6.1.79 SUSER_SNAME
       6.1.80 TAN
       6.1.81 TEXTPTR
       6.1.82 TEXTVALID
       6.1.83 UNICODE
       6.1.84 UPPER
       6.1.85 USER
       6.1.86 USER_NAME
       6.1.87 YEAR
6.2 Unsupported Functions
Chapter 7: 
 
7.1 Local Variables
7.2 @@ Special Variables
       7.2.1 @@ERROR
       7.2.2 @@FETCH_STATUS
       7.2.3 @@IDENTITY
       7.2.4 @@LOCK_TIMEOUT
       7.2.5 @@NESTLEVEL
       7.2.6 @@ROWCOUNT
       7.2.7 @@SERVERNAME
       7.2.8 @@SPID
       7.2.9 @@SQLSTATUS
       7.2.10 @@TRANCOUNT
       7.2.11 @@VERSION
Chapter 8: 
 
8.1 Other Ways to Execute Transact-SQL Code