docs.intersystems.com
Caché Transact-SQL (TSQL) Migration Guide
Contents
[Home]  [Next]
InterSystems: The power behind what matters   
Search:    

Preface : 
 
 
Chapter 1: 
 
1.1 Migrating Existing TSQL Applications
1.2 Writing and Executing TSQL on Caché
Chapter 2: 
 
2.1 Table References
2.2 Temporary Tables
2.3 System Tables
2.4 Transactions
2.5 Cursor Name Management
2.6 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.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


Send us comments on this page
Copyright © 1997-2019 InterSystems Corporation, Cambridge, MA