Extensions to ANSI SQL
To illustrate the use of these SQL extensions to create actual programming logic, we are using Sybase and Microsoft SQL Server's Transact-SQL language. It contains most of the constructs found in third-generation languages (procedural programming languages such as C), as well as some SQL Server–specific features that turn out to be very handy tools for the database programmer. (Other manufacturers' extensions contain many of these features and more.)
Who Uses Transact-SQL?
Everyone reading this book can use Transact-SQL—including casual relational database programmers who occasionally write queries as well as developers who write applications and create objects such as triggers and stored procedures.
Note
Users of Sybase ...
Get Sams Teach Yourself SQL in 21 Days, Fourth Edition now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.
