Inside Microsoft SQL Server 2005: T-SQL Programming

Itzik Ben-gan, Dejan Sarka, Roger Wolter

  • 出版商: MicroSoft
  • 出版日期: 2006-06-14
  • 售價: $1,840
  • 貴賓價: 9.5$1,748
  • 語言: 英文
  • 頁數: 544
  • 裝訂: Paperback
  • ISBN: 0735621977
  • ISBN-13: 9780735621978
  • 相關分類: MSSQLSQL
  • 已絕版

買這商品的人也買了...

商品描述

Description

Exploit advanced T-SQL language features with in-depth architectural insights from the experts.

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