Transact-SQL Programming

Kevin Kline administrates well over 100 SQL Server installations across the country for Deloitte & Touche LLP. When he's not pulling out his hair, he likes to spend time with his wife and kids, play classical guitar, restore his '66 Chevy truck, and write screenplays. Kevin is also the author of Oracle CDE: Reference & User's Guide (Butterworth-Heinemann) and a coauthor of Professional SQL Server 6.5 Admin (WROX Press). Kevin is also an instructor at Ziff-Davis University (www.zdu.com). He can be reached at kekline@compuserve.com. Lee Gould is a principal consultant with Sybase Professional Services in New York where she works mainly in the financial services industry on Wall Street. She has been working with SQL Server since 1992 and has been involved in the computer industry for over ten years. She has published numerous articles in Microsoft SQL Server Professional (Pinnacle Publishing) and presented on a variety of topics at the International Sybase User Group and Powersoft conferences. Lee was born in Liverpool, England. She grew up in Johannesburg, South Africa, where she attended the University of Witwatersrand and received her bachelors of commerce in business information systems. Lee immigrated to America four years ago and is currently pursuing an MBA at Seton Hall University in New Jersey. Lee lives in the suburb of North Brunswick, New Jersey, with her two cats, Lady and Paganini. She can often be seen running, cycling, swimming, and horseriding while she trains for marathons and ultra triathlon events. When not immersed in sport, Lee is an avid fan of classical music, good wine, the piano, science fiction and Terminator II. Her motto on life is "carpe diem," which she endeavors to follow regardless of where it leads her. Lee can be contacted at lee_k_gould@yahoo.com. Andrew Zanevsky, an independent consultant and founder and president of AZ Databases, Inc., has been working with SQL Server since 1992. He writes a monthly column "Super Administrator," for Microsoft SQL Server Professional (Pinnacle Publishing) and has published more than a hundred technical articles throughout his career. He immigrated to the United States from Minsk, Belarus in 1991. He started programming in 1982 and holds a degree from the Belarus State University of Informatics and Radioelectronics (equivalent to an M.S. in computer science). Andrew lives in a suburb of Chicago with his wife Katrin, son Anthony, and stepdaughter Esther. Katrin is also a SQL Server consultant. They work on some projects together and can talk about Transact-SQL at dinner. Andrew's daughter Nikkie lives in New York, wants to be a writer, and has won numerous awards in art contests. Andrew was the president of the Great Lakes SQL Server Users Group in Chicago from 1994 through 1997. He can be reached at zanevsky@azdatabases.com.

PART I: The Basics: Programming in Transact-SQL 1. Introduction to Transact-SQL 2. Matching Business Rules 3. SQL Primer 4. Transact-SQL Fundamentals 5. Format and Style PART II: The Building Blocks: Transact-SQL Language Elements 6. Datatypes and Variables 7. Conditional Processing 8. Row Processing with Cursors 9. Error Handling 10. Temporary Objects 11. Transactions and Logging PART III: Functions and Extensions 12. Functions 13. CASE Expressions and Transact-SQL Extensions PART IV: Programming Transact-SQL Objects 14. Stored Procedures and Modular Design 15. Triggers 16. Views 17. System and Extended Stored Procedures and BCP PART V: Performance Tuning and Optimization 18. Transact-SQL Code Design 19. Code Maintenance in the SQL Server 20. Transact-SQL Optimization and Tuning 21. Debugging Transact-SQL Programs PART VI: Appendixes A. System Tables B. What's New for Transact-SQL in Microsoft SQL Server 7.0? C. BCP The book comes with a CD-ROM containing an extensive set of examples from the book and complete programs that illustrate the power of the language.