相關主題
商品描述
In SQL Server 2012 T-SQL Programming Unleashed, leading SQL Server consultant David Solomon shows database programmers how to take full advantage of it. This comprehensive how-to guide integrates exceptionally useful examples with detailed discussions of the underlying database behavior they illustrate. It provides self-contained modular coverage of each topic for rapid reference, and is organized intelligently to help readers build their knowledge incrementally as they proceed through the book. Solomon illuminates both the fundamental characteristics of T-SQL processing and the relationship between T-SQL code style and performance. Coverage includes: * T-SQL basics: how T-SQL and SQL Server interact * Data manipulation: database objects, DML, selection, complex queries, data modification, loading, and merge * Batch programming: transactions, logging, locking, temporary storage, Dynamic SQL, server-side cursors, and error handling * Creating SQL programming objects: views, stored procedures, UDFs, and triggers * Using CLR to integrate non-SQL programs * And much more
商品描述(中文翻譯)
在《SQL Server 2012 T-SQL 程式設計完全指南》中，資深 SQL Server 顧問 David Solomon 向資料庫程式設計師展示如何充分利用它。這本全面的操作指南結合了非常有用的範例與詳細討論其所示範的資料庫行為。它提供了每個主題的獨立模組化內容，便於快速參考，並且以智能的方式組織，幫助讀者在閱讀過程中逐步建立知識。Solomon 解釋了 T-SQL 處理的基本特徵以及 T-SQL 代碼風格與性能之間的關係。內容涵蓋包括：* T-SQL 基礎：T-SQL 與 SQL Server 的互動 * 數據操作：資料庫物件、DML、選擇、複雜查詢、數據修改、加載和合併 * 批次程式設計：交易、日誌、鎖定、臨時儲存、動態 SQL、伺服器端游標和錯誤處理 * 創建 SQL 程式物件：視圖、儲存過程、UDF 和觸發器 * 使用 CLR 整合非 SQL 程式 * 以及更多內容
