基本信息出版社：Microsoft Press
页码：544 页
出版日期：2006年06月
ISBN：0735621977
条形码：9780735621978
装帧：平装
正文语种：英语
丛书名：Pro-Developer
外文书名：Microsoft SQL Server 2005 内幕: T-SQL 编程

内容简介 在线阅读本书

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 language—solving 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 
作者简介 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.

Lubor Kollar is a program manager on the SQL Server team at Microsoft Corporation who focuses on optimization.

Dejan Sarka is a Solid Quality Learning Associate Mentor.