Microsoft SQL Server 2005 内幕：T-SQL 编程Inside Microsoft SQL Server 2005: T-SQL Programming pmlz 电子版 pdf docx 网盘 kindle azw3 下载

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

暂无相关内容，正在全力查找中

暂无出版社相关信息，正在全力查找中！

暂无相关书籍摘录，正在全力查找中！

在线阅读地址：Microsoft SQL Server 2005 内幕：T-SQL 编程Inside Microsoft SQL Server 2005: T-SQL Programming在线阅读

在线听书地址：Microsoft SQL Server 2005 内幕：T-SQL 编程Inside Microsoft SQL Server 2005: T-SQL Programming在线收听

在线购买地址：Microsoft SQL Server 2005 内幕：T-SQL 编程Inside Microsoft SQL Server 2005: T-SQL Programming在线购买

暂无原文赏析，正在全力查找中！

编辑推荐

作者简介：

　　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 Tech·Ed, DevWeek, PASS, SQL Server Connections, and SQLU Summits, to name a few.

书籍介绍

在线阅读本书

Get a detailed look at the internal architecture of T-SQL with this comprehensive programming reference. Database developers and administrators get best practices, expert techniques, and code samples to master the intricacies of the programming languagesolving complex problems with real-world solutions. Discover how to: Understand when to apply set-based programming techniques Design and implement date and time-related XML and CLR datatypes Use temporary objects, including temporary tables, table variables, and table expressions Work with T-SQL and CLR user-defined functions, stored procedures, and triggers Support user input-based queries and variable data with dynamic execution Work with transactions and new exception handling constructs Apply a concurrency model to support simultaneous users Use Service Broker for controlled asynchronous processing in database applications This book includes code samples on the Web