Quick Reference Guide to SQL

The Standard Relational Database Language

John L. Viescas

Publisher: Microsoft Press, 1989, 103 pages

ISBN: 1-55615-198-5

Keywords: Databases

Last modified: June 6, 2021, 11:48 a.m.

At last! Here is a handy guide for anyone using a database management system that supports the industry-standard SQL. Included are concise descriptions and notes on the statements, major clauses, and subfunctions for the SQL's main components:

  • Data Manipulation Language (DML)
  • Data Control Language (DCL)
  • Data Definition Language (DDL)

Entries are arranged alphabetically within each section to make information immediately accessible. And scores of great examples — for both interactive users and programmers — offer practical insights into common SQL usage. In addition, you'll find a convenient appendix that describes common data types, arithmetic operators, and reserved words used in SQL.

  • Data Manipulation Language
    • BEGIN DECLARE SECTION Statement
    • CLOSE Statement
    • DECLARE CURSOR Statement
    • DECLARE CURSOR Statement (Dynamic SQL)
    • DELETE Statement
    • DELETE … WHERE CURRENT OF Statement
    • DESCRIBE Statement (Dynamic SQL)
    • END DECLARE SECTION Statement
    • END-EXEC Statement terminator
    • EXEC-SQL Statement Prefix
    • EXECUTE Statement (Dynamic SQL)
    • Expressions
    • FETCH Statement
    • FETCH Statement (Dynamic SQL)
    • Function: AVG
    • Function: COUNT
    • Function: MAX
    • Function: MIN
    • Function: SUM
    • FROM Clause
    • GROUP BY Clause
    • HAVING Clause
    • INCLUDE Directive
    • INSERT Statement
    • INTERSECT Query Operator
    • Joins
    • MINUS Query Operator
    • OPEN Statement
    • OPEN Statement (Dynamic SQL)
    • ORDER BY Clause
    • Predicate: BETWEEN
    • Predicate: Comparison
    • Predicate: EXISTS
    • Predicate: IN
    • Predicate: LIKE
    • Predicate: NULL
    • Predicate: Quantified (SOME, ANY, ALL)
    • PREPARE Statement (Dynamic SQL)
    • Search-condition
    • SELECT Statement
    • SELECT … INTO Statement
    • subSELECT Clause
    • UNION Query Operator
    • UPDATE Statement
    • UPDATE … WHERE CURRENT OF Statement
    • WHENEVER Directive
    • WHERE Clause
  • Data Definition Language
    • ALTER TABLE Statement
    • COMMENT ON Statement
    • CREATE INDEX Statement
    • CREATE SYNONYM Statement
    • CREATE TABLE Statement
    • CREATE VIEW Statement
    • DROP INDEX Statement
    • DROP SYNONYM Statement
    • DROP TABLE Statement
    • DROP VIEW Statement
    • UPDATE STATISTICS Statement
  • Data Control Language
    • COMMIT Statement
    • GRANT Statement
    • LOCK TABLE Statement
    • REVOKE Statement
    • ROLLBACK Statement
  • Appendixes
    • Common Data types
    • Arithmetic Operators
    • Reserved Words

Reviews

Quick Reference Guide to SQL

Reviewed by Roland Buresund

Disappointing *** (3 out of 10)

Last modified: May 21, 2007, 3:20 a.m.

This one wasn't complete even in 1989, when it was written.

Comments

There are currently no comments

New Comment

required

required (not published)

optional

required

captcha

required