Skip to Main Content
SQL All-in-One For Dummies, 4th Edition
book

SQL All-in-One For Dummies, 4th Edition

by Allen G. Taylor, Richard Blum
April 2024
Intermediate to advanced content levelIntermediate to advanced
800 pages
18h 34m
English
For Dummies
Content preview from SQL All-in-One For Dummies, 4th Edition

Chapter 6

Understanding SQL’s Procedural Capabilities

IN THIS CHAPTER

Bullet Using embedded SQL statements

Bullet Working with compound statements

Bullet Creating flow of control statements

Bullet Working with stored procedures

Bullet Executing SQL statements with triggers

Bullet Taking advantage of stored functions

Bullet Granting privileges

Bullet Upping the stakes with stored modules

In its original incarnation, SQL was conceived as a data sublanguage, the only purpose of which was to interact with relational databases. It was considered acceptable to embed SQL statements within procedural language code written in some full-featured language to create a fully functional database application. For a long time, however, users wanted SQL ...

Become an O’Reilly member and get unlimited access to this title plus top books and audiobooks from O’Reilly and nearly 200 top publishers, thousands of courses curated by job role, 150+ live events each month,
and much more.
Start your free trial

You might also like

SQL All-In-One For Dummies, 3rd Edition

SQL All-In-One For Dummies, 3rd Edition

Allen G. Taylor
SQL Essentials For Dummies

SQL Essentials For Dummies

Richard Blum, Allen G. Taylor
SQL in a Nutshell, 4th Edition

SQL in a Nutshell, 4th Edition

Kevin Kline, Regina O. Obe, Leo S. Hsu

Publisher Resources

ISBN: 9781394242290Purchase Link