Practical SQL Queries for Microsoft SQL Server 2008 R2 (Paperback)

400+ ready-to-use, powerful SQL queries

Learn powerful techniques for surfacing and delivering actionable business intelligence using SQL. Practical SQL Queries for Microsoft SQL Server 2008 R2 contains more than 400 downloadable SQL queries you can use to extract meaningful insights from large amounts of data. The application, syntax, and results of each query are described in detail. The book emphasizes SQL for use in SSMS, but the queries also apply to SSRS, WinForms, WebForms, and many other applications.

• Enter, maintain, and retrieve database data
• Search records using the Where clause
• Sort SQL query results with the Order By clause
• Create tables and perform joins on tables
• Perform set operations using Union, Intersect, and Except
• Group data and produce totals with the Group By clause
• Manipulate and transform data using built-in functions
• Create reusable views and user-defined functions
• Use stored procedures to change SQL dynamically based on conditional factors
• Create, maintain, and secure database objects with DDL and DCL
• Deliver SQL query results to end users

400+ 個現成可用的強大 SQL 查詢
使用 SQL 學習揭示和提供可行的商業智能的強大技巧。《Practical SQL Queries for Microsoft SQL Server 2008 R2》包含超過 400 個可下載的 SQL 查詢，您可以使用這些查詢從大量數據中提取有意義的見解。詳細描述了每個查詢的應用、語法和結果。本書強調在 SSMS 中使用 SQL，但這些查詢也適用於 SSRS、WinForms、WebForms 和許多其他應用程序。

• 輸入、維護和檢索數據庫數據
  


• 使用 Where 子句搜索記錄
  


• 使用 Order By 子句對 SQL 查詢結果進行排序
  


• 創建表並在表上執行連接操作
  


• 使用 Union、Intersect 和 Except 執行集合操作
  


• 使用 Group By 子句對數據進行分組並生成總計
  


• 使用內置函數操作和轉換數據
  


• 創建可重用的視圖和用戶定義函數
  


• 使用存儲過程根據條件因素動態更改 SQL
  


• 使用 DDL 和 DCL 創建、維護和保護數據庫對象
  


• 將 SQL 查詢結果交付給最終用戶