買這商品的人也買了...
-
$199$169 -
$350$277 -
$880$695 -
$540$427 -
$650$514 -
$650$507 -
$780$663 -
$680$537 -
$1,880$1,786 -
$520$411 -
$620$490 -
$650$507 -
$680$537 -
$550$435 -
$520$411 -
$880$695 -
$750$593 -
$680$537 -
$450$356 -
$620$527 -
$780$616 -
$720$569 -
$380$300 -
$1,100$1,078 -
$299$236
相關主題
商品描述
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
商品描述(中文翻譯)
**描述**
**深入了解專家提供的 T-SQL 語言進階特性及其架構洞察。**
透過這本全面的程式設計參考書,深入了解 T-SQL 的內部架構。資料庫開發人員和管理員可以獲得最佳實踐、專家技術和程式碼範例,以掌握這種程式語言的複雜性—用真實世界的解決方案來解決複雜問題。
發現如何:
- 理解何時應用基於集合的程式設計技術
- 設計和實作與日期和時間相關的 XML 和 CLR 資料類型
- 使用臨時物件,包括臨時表、表變數和表達式
- 使用 T-SQL 和 CLR 自定義函數、儲存過程和觸發器
- 支援基於使用者輸入的查詢和變數資料的動態執行
- 處理交易和新的例外處理結構
- 應用並發模型以支援同時使用者
- 使用 Service Broker 進行資料庫應用程式中的受控非同步處理