Book description
This is the SQL reference you'll reach for first, every time!
If you're an SQL programmer, you can easily picture how useful a comprehensive, single-volume Transact-SQL command reference manual would be in streamlining your work. And if that book was rich in examples, was written with users of all levels of expertise in mind, and was even designed to fit comfortably on your desktop, you'd probably buy it right away, wouldn't you? Well, look no further—Transact-SQL Desk Reference, by noted programming instructor Deac Lancaster, is exactly the book you need.
As it turns out, Transact-SQL Desk Reference is just the book Deac himself was looking for. The problem was, no such book existed, so he saved programmers everywhere a lot of trouble and he wrote it himself! The book answers the question, "How exactly do I write a statement to do a particular job?" by providing the full syntax of each command along with examples showing each command in action. Then, to assist you in making your code more portable, Transact-SQL Desk Reference shows where Transact-SQL diverges from the ANSI SQL standard. The commands are arranged by functional area and are well indexed and cross-referenced, making it as easy as possible to find what you're looking for-even if you don't know the command's name. Inside, you'll find:
SQL commands grouped logically by purpose and function, plus an index so you can jump right to the command
Definitions that give the full syntax of each command, along with examples of each command in use plus tips on maximizing portability
Additional chapters covering RDBMS concepts, details of Transact-SQL, and advanced SELECT queries!
This book is intended for programmers of all levels working with Microsoft SQL Server.
Table of contents
- Copyright
- Preface
- About Prentice Hall Professional Technical Reference
- Acknowledgments
- RDBMS Concepts — A Primer
- SQL Building Blocks and Server Settings
- Data Definition Language and Security
- Data Manipulation Language—INSERT, UPDATE, DELETE, SELECT
- Transaction Control, Backup and Restore and Transact-SQL Programming
- Transact-SQL Keywords and System Stored Procedures
- Select—Advanced Queries
- Bibliography
- Index
Product information
- Title: Transact-SQL Desk Reference
- Author(s):
- Release date: November 2003
- Publisher(s): Pearson
- ISBN: 0130293393
You might also like
book
Microsoft® SQL Server® 2008 Step by Step
Teach yourself SQL Server 2008—one step at a time. Get the practical guidance you need to …
book
Microsoft® SQL Server® 2008 Bible
Harness the power of SQL Server, Microsoft’s high-performance database and data analysis software package, by accesing …
book
Visual Basic 2015 Unleashed
Using Visual Basic 2015, developers can build cutting-edge applications that run practically anywhere: on Windows desktops, …
book
Beginning Transact-SQL with SQL Server 2000 and 2005
Beginning Transact-SQL with SQL Server 2000 and 2005 Transact-SQL is a powerful implementation of the ANSI …