SQL Instant Reference

Name: SQL Instant Reference
Price: 3.61 USD
Availability: InStock
ISBN: 9780782125399

ISBN-10: 0782125395

ISBN-13: 9780782125399

Edition: 2nd 2000 (Revised)

Authors: Martin Gruber

List price: $32.50

30 day, 100% satisfaction guarantee!

Marketplace

3 new & used from $3.61

what's this?

Rush Rewards U
Members Receive:

You have reached 400 XP and carrot coins. That is the daily max!

Description:

Completely updated, this edition offers programmers or administrators with a quick-reference guide that deals with SQL code.

Book details

List price: $32.50
Edition: 2nd
Copyright year: 2000
Publisher: John Wiley & Sons, Incorporated
Publication date: 3/30/2000
Binding: Paperback
Pages: 388
Size: 4.75" wide x 8.00" long x 1.00" tall
Weight: 0.682
Language: English



Introduction



Introduction to SQL


SQL: An Overview


The Fundamentals of SQL and Relational Databases


A Relational Database Primer


Joining Tables


Basics of the SQL Language


Overview of the SQL Standards


Notable Features of Standard SQL



SQL Statement Reference


Allocate Cursor


Allocate Descriptor


Alter Domain


Alter Table


Close


Commit Work


Connect


Create Assertion


Create Character Set


Create Collation


Create Domain


Create Schema


Create Table


Create Translation


Create View


Deallocate Descriptor


Deallocate Prepare


Declare Cursor


Declare Local Temporary Table


Delete


Describe


Disconnect


Drop Assertion


Drop Character Set


Drop Collation


Drop Domain


Drop Schema


Drop Table


Drop Translation


Drop View


Execute


Execute Immediate


Fetch


Get Descriptor


Get Diagnostics


Grant


Insert


Open


Prepare


Revoke


Rollback


Select


Set Catalog


Set Connection


Set Constraints Mode


Set Descriptor


Set Names


Set Schema


Set Session Authorization


Set Time Zone


Set Transaction


Update



Common Elements


Aggregate Functions


Authorization IDs


CASE Expressions


CAST Expressions


Collations


Constraints


Datatypes


Datetime Value Functions


Descriptor Areas


Numeric Value Functions


Predicates


Row and Table Value Constructors


String Value Functions


Subqueries


Value Expressions






SQL99: An Overview


The Structure of the Standard andConformance Levels


New Types of Data


Extensions to SQL Statements


Programmatic Extensions to SQL


A Quick Overview of Object-OrientedConcepts


Integrating Objects into the RelationalWorld


Summary



Core SQL99


What Is Core? Distinct User-Defined Datatypes (UDTs)


Summary



Mapping SQL to Other Lanuages


Ada


C/C++


COBOL


Fortran


MUMPS


Pascal


PL/I



Specification of the Module Language


Overview


Syntax



Specification of Dynamic SQL



SQL Linguistic Definitions and Conventions


Identifiers


SQL Keywords



Upgrade Path from SQL92 to Core SQL99


Core SQL99 Features



Error Codes


Sqlcode


Sqlstate



Glossary


Index