Microsoft SQL Server 2005 内幕：T-SQL 编程Inside Microsoft SQL Server 2005: T-SQL Programming
点此进入淘宝搜索页搜索分类: 图书,进口原版书,计算机 Computers & Internet ,
作者： Itzik Ben-gan等著
出 版 社： Oversea Publishing House
出版时间： 2006-6-1字数：版次： 1页数： 508印刷时间： 2006/06/01开本： 16开印次： 1纸张： 胶版纸I S B N ： 9780735621978包装： 平装编辑推荐
作者简介：
About the Author
The primary author, Itzik Ben-Gan, is a Principal Mentor and Founder of Solid Quality Learning. A SQL Server Microsoft Most Valuable Professional (MVP) since 1999, Itzik has delivered dozens of training events across the U.S. and Europe focused on T-SQL programming, performance tuning and internals, administration, implementation, data warehousing, and online analytical processing (OLAP. An accomplished author, Itzik has written many articles for SQL Server Magazine as well as articles and white papers for MSDN®. Itzik’s speaking activities have included TechEd, DevWeek, PASS, SQL Server Connections, and SQLU Summits, to name a few.
内容简介
This thorough, hands-on reference for database developers and administrators delivers expert guidance on sophisticated uses of Transact-SQL (T-SQL)#151;one of the most familiar and powerful programming languages for SQL Server. Written by a T-SQL guru, this guide focuses on language features and how they are interpreted and processed by the SQL Server execution engine. You'll get in-depth coverage of the sophisticated uses of T-SQL, including triggers, user-defined functions, exception handling, and more. The book explains and compares solutions to database-development problems in both SQL Server 2000 and SQL Server 2005, discussing the new T-SQL programming features added to SQL Server 2005 in detail. Includes extensive code samples, table examples, and logic puzzles to help database developers and administrators understand the intricacies and help promote mastery of T-SQL.
目录
1 Datatype-related problems, XML, and CLR UDTs
2 Temporary tables and table variables
3 Cursors
4 Dynamic SQL
5 Views
6 User-defined functions
7 Stored procedures
8 Triggers
9 Transactions
10 Exception handling
11 Service broker
Appendix A Companion to CLR routines
