Product Description

This command reference, designed for users of all levels, provides a user-friendly guide to the SQL database programming language. All commands will be listed alphabetically by functional area -- ideal for beginners who can locate commands based on the tasks they are trying to accomplish. In addition, the author has included a "roadmap" listing commands in alphabetical order at the front of the book that is ideal for more advanced users who know the command name and simply need to know a page number. Each command will include a hands-on example. The book reflects the new SQL standard, and should be one of the very first books on the market. Author includes extensive examples for Oracle and Microsoft SQL Server implementations. This 6x9 reference is the perfect companion to Bowman's Practical SQL Handbook and is design to fit on the busy Database Developer's desk.

Product Details

• Amazon Sales Rank: #419155 in Books
• Published on: 2003-11-20
• Original language: English
• Number of items: 1
• Binding: Paperback
• 816 pages

From the Back Cover

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.

About the Author

DEAC LANCASTER has taught high-level programming courses at Sun Microsystems, Remedy Corporation, and University of California, Santa Cruz-extension for the past 13 years. He has over 20 years of computer programming experience.