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.1.1 Configuring TSQL
1.1.2 Migrating Source Code
1.1.3 Migrating the Data
1.2 TSQL Language Implementation
Chapter 2: 
  2.1 Commonly Used Constructs
2.1.1 Table References
2.1.2 Temporary Tables
2.1.3 Transactions
2.1.4 Cursor Name Management
2.1.5 System Stored Procedures
2.1.6 System Tables
2.1.7 SYSOBJECTS References
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.2.1 Delimited and Quoted Identifiers
3.3 Data Types
3.4 Operators
3.4.1 Arithmetic and Equality Operators
3.4.2 Concatenation Operator
3.4.3 Comparison Operators
3.4.4 NOT Logical Operator
3.4.5 Bitwise Logical 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.6.1 SET TRANSACTION ISOLATION LEVEL
4.6.2 BEGIN TRANSACTION
4.6.3 COMMIT TRANSACTION
4.6.4 ROLLBACK TRANSACTION
4.6.5 CHECKPOINT
4.6.6 LOCK TABLE
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.1.1 Declaring a Local Variable
7.1.2 Setting a Local Variable
7.1.3 Initial and Default Values
7.1.4 Plain 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