Caché Transact-SQL (TSQL) Migration Guide
Contents
 
   
Server:docs1
Instance:LATEST
User:UnknownUser
 
-
Go to:
Search:    

 
Contents

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