SQL Server T-SQL Recipes, 4/e (Paperback)

SQL Server T-SQL Recipes is an example-based guide to the Transact-SQL language that is at the core of SQL Server. This edition has been lightly updated for SQL Server 2014 and provides ready-to-implement solutions to common programming and database administration tasks. Learn to create databases, create in-memory tables and stored procedures, insert and update data, generate reports, secure your data, and more. Tasks and their solutions are broken down into a problem/solution format that is quick and easy to read so that you can get the job done fast when the pressure is on.

Solutions in this book are divided into chapters by problem domain. Each chapter is a collection of solutions around a single facet of the language such as writing queries, managing indexes, error handling, and query performance. Each solution is presented code-first, giving you a working code example to copy from and implement immediately in your own environment. Following each example is an in-depth description of how and why the given solution works. Tradeoffs and alternative approaches are also discussed.

• Focused on solutions: Look up what you need to do. Learn how to do it. Do it.
• Current: Lightly updated for SQL Server 2014
• Comprehensive: Covers all common T-SQL problem domains

What you’ll learn

• Create databases, tables, and indexes
• Query and manipulate data
• Move business logic into the database
• Build reports that matter to your business.
• Perform common backup and recovery tasks
• Take advantage of window functions in your SQL

Who this book is for

SQL Server T-SQL Recipes is aimed at technically-oriented users of SQL Server desiring to extract the full power of the platform through it's powerful, built-in programming and scripting language. Target readers include developers who use SQL Server as their back–end database platform, and the database administrators who create, manage, and secure those databases.

Table of Contents

1. Getting Started with SELECT

2. Elementary Programming

3. Working with NULLS

4. Combining Data from Multiple Tables

5. Aggregations and Grouping

6. Advanced SELECT Techniques

7. Windowing

8. Inserting, Updating, Deleting

9. Working with Strings

10. Working with Dates

11. Working with Numbers

12. Transactions, Locking, Blocking, Deadlockin

13. Managing Tables

14. Managing Views

15. Managing Indexes

16. Managing Large Tables

17. Stored Procedures

18. User-Defined Functions

19. In-Memory T-SQL

20. Triggers

21. Error Handling

22. Query Performance

23. Hints

24. Index Tuning and Statistics

25. XML

26. Files, Filegroups, and Integrity

27. Backup

28. Recovery

29. Principals and Users

30. Securables and Permissions

31. Objects and Dependencies

《SQL Server T-SQL Recipes》是一本以範例為基礎的指南，介紹了 SQL Server 核心的 Transact-SQL 語言。這本書已經輕微更新以適應 SQL Server 2014，並提供了可立即實施的常見程式設計和資料庫管理任務的解決方案。學習如何建立資料庫、建立記憶體中的表格和儲存過程、插入和更新資料、生成報表、保護資料等等。這本書將任務及其解決方案按照問題/解決方案的格式分解，讓您在壓力下能夠快速閱讀並完成工作。

本書的解決方案按照問題領域分為章節。每個章節都是關於語言的一個方面的解決方案集合，例如撰寫查詢、管理索引、錯誤處理和查詢效能。每個解決方案都是以程式碼為先，提供一個可複製並立即在您自己的環境中實施的工作程式碼範例。在每個範例之後，還有對給定解決方案的深入描述，解釋該解決方案的工作原理和原因。同時還討論了權衡和替代方法。

本書的特點：
- 專注於解決方案：查找您需要做的事情。學習如何做。做。
- 最新：輕微更新以適應 SQL Server 2014
- 全面：涵蓋所有常見的 T-SQL 問題領域

您將學到的內容：
- 建立資料庫、表格和索引
- 查詢和操作資料
- 將業務邏輯移入資料庫
- 建立對您業務有意義的報表
- 執行常見的備份和還原任務
- 在 SQL 中利用窗口函數
- 等等

本書的目標讀者：
《SQL Server T-SQL Recipes》針對希望通過內建的強大程式設計和腳本語言充分發揮 SQL Server 平台功能的技術導向使用者。目標讀者包括將 SQL Server 作為後端資料庫平台的開發人員，以及創建、管理和保護這些資料庫的資料庫管理員。

目錄：
1. 開始使用 SELECT
2. 基本程式設計
3. 處理 NULL 值
4. 結合多個表格的資料
5. 聚合和分組
6. 進階 SELECT 技巧
7. 窗口函數
8. 插入、更新、刪除
9. 處理字串
10. 處理日期
11. 處理數字
12. 交易、鎖定、阻塞、死結
13. 管理表格
14. 管理檢視
15. 管理索引
16. 管理大型表格
17. 儲存過程
18. 使用者定義函數
19. 記憶體中的 T-SQL
20. 觸發器
21. 錯誤處理
22. 查詢效能
23. 提示
24. 索引調整和統計資料
25. XML
26. 檔案、檔案群組和完整性
27. 備份
28. 還原
29. 主體和使用者
30. 安全性和權限
31. 物件和相依性