Contents

List of Tables

Title and Copyright Information

Preface

• Intended Audience
• Documentation Accessibility
• What You Should Already Know
• Related Documents
• Conventions
• Third-Party License Information

1 Overview

• 1.1 Introduction
• 1.2 Product Description
• 1.3 Features
• 1.4 Glossary

2 Microsoft SQL Server, Sybase Adaptive Server, and Oracle Compared

• 2.1 Schema Migration
  • 2.1.1 Schema Object Similarities
  • 2.1.2 Schema Object Names
  • 2.1.3 Table Design Considerations
    • 2.1.3.1 Data Types
    • 2.1.3.2 Entity Integrity Constraints
    • 2.1.3.3 Referential Integrity Constraints
    • 2.1.3.4 Unique Key Constraints
    • 2.1.3.5 Check Constraints
• 2.2 Data Types
  • 2.2.1 Data Types Table
• 2.3 Data Storage Concepts
  • 2.3.1 Data Storage Concepts Table
• 2.4 Data Manipulation Language
  • 2.4.1 Connecting to the Database
  • 2.4.2 SELECT Statement
    • 2.4.2.1 SELECT Statements without FROM Clauses:
    • 2.4.2.2 SELECT INTO Statement:
    • 2.4.2.3 Column Aliases:
    • 2.4.2.4 Table Aliases:
    • 2.4.2.5 Compute:
  • 2.4.3 SELECT with GROUP BY Statement
  • 2.4.4 INSERT Statement
  • 2.4.5 UPDATE Statement
    • 2.4.5.1 Method 1 - Convert UPDATE statements with FROM clauses:
    • 2.4.5.2 Method 2 - Convert UPDATE statements with FROM clauses:
  • 2.4.6 DELETE Statement
    • 2.4.6.1 Remove Second FROM Clause:
  • 2.4.7 Operators
    • 2.4.7.1 Comparison Operators
    • 2.4.7.2 Arithmetic Operators
    • 2.4.7.3 String Operators
    • 2.4.7.4 Set Operators
    • 2.4.7.5 Bit Operators
  • 2.4.8 Built-In Functions
    • 2.4.8.1 Character Functions
    • 2.4.8.2 Miscellaneous Functions
    • 2.4.8.3 Date Functions
    • 2.4.8.4 Mathematical Functions
  • 2.4.9 Locking Concepts and Data Concurrency Issues
    • 2.4.9.1 Locking
    • 2.4.9.2 Row-Level Versus Page-Level Locking
    • 2.4.9.3 Read Consistency
    • 2.4.9.4 Logical Transaction Handling

3 Triggers and Stored Procedures

• 3.1 Triggers
• 3.2 Stored Procedures
  • 3.2.1 Individual SQL Statements
    • 3.2.1.1 Microsoft SQL Server or Sybase Adaptive Server:
    • 3.2.1.2 Oracle:
    • 3.2.1.3 Microsoft SQL Server or Sybase Adaptive Server:
    • 3.2.1.4 Oracle:
  • 3.2.2 Logical Transaction Handling
    • 3.2.2.1 Transaction-Handling Statements
  • 3.2.3 Error Handling Within the Stored Procedure
    • 3.2.3.1 RAISERROR Statement
    • 3.2.3.2 Customized Error Messages
• 3.3 Data Types
  • 3.3.1 Local Variable
  • 3.3.2 Server Data Types
  • 3.3.3 Composite Data Types
• 3.4 Schema Objects
  • 3.4.1 Procedure
    • 3.4.1.1 Create
    • 3.4.1.2 Drop
    • 3.4.1.3 Execute
    • 3.4.1.4 Alter
  • 3.4.2 Function
    • 3.4.2.1 Create
    • 3.4.2.2 Drop
    • 3.4.2.3 Execute
    • 3.4.2.4 Alter
  • 3.4.3 Package
    • 3.4.3.1 Create
    • 3.4.3.2 Drop
    • 3.4.3.3 Alter
  • 3.4.4 Package Body
    • 3.4.4.1 Create
    • 3.4.4.2 Drop
    • 3.4.4.3 Alter
• 3.5 T/SQL Versus PL/SQL Constructs
  • 3.5.1 CREATE PROCEDURE Statement
  • 3.5.2 Parameter Passing
  • 3.5.3 DECLARE Statement
  • 3.5.4 IF Statement
  • 3.5.5 RETURN Statement
  • 3.5.6 RAISERROR Statement
  • 3.5.7 EXECUTE Statement
  • 3.5.8 WHILE Statement
  • 3.5.9 GOTO Statement
  • 3.5.10 @@Rowcount and @@Error Variables
  • 3.5.11 ASSIGNMENT Statement
  • 3.5.12 SELECT Statement
  • 3.5.13 SELECT Statement with GROUP BY Clause
  • 3.5.14 Column Aliases
  • 3.5.15 UPDATE with FROM Statement
  • 3.5.16 DELETE with FROM Statement
  • 3.5.17 Temporary Tables
  • 3.5.18 Cursor Handling
• 3.6 T/SQL and PL/SQL Language Elements
  • 3.6.1 Transaction Handling Semantics
    • 3.6.1.1 Conversion Preparation Recommendations
  • 3.6.2 Exception-Handling and Error-Handling Semantics
  • 3.6.3 Special Global Variables
  • 3.6.4 Operators
  • 3.6.5 Built-in Functions
  • 3.6.6 DDL Constructs within Microsoft SQL Server or Sybase Adaptive Server Stored Procedures

4 Distributed Environments

• 4.1 Distributed Environments
  • 4.1.1 Accessing Remote Databases in a Distributed Environment
    • 4.1.1.1 Oracle and Remote Objects
  • 4.1.2 Microsoft SQL Server or Sybase Adaptive Server and Remote Objects
  • 4.1.3 Replication
• 4.2 Application Development Tools

5 Disconnected Source Model Loading

• 5.1 Generating Database Metadata Flat Files
  • 5.1.1 Flat File Generation Scripts
    • 5.1.1.1 Running the Scripts

Index