Publisher's Synopsis
Sams Teach Yourself Microsoft SQL Server T-SQL in 10 Minutes offers straightforward, practical answers when you need fast results. By working through the book's 30 lessons of 10 minutes or less, you'll learn what you need to know to take advantage of Microsoft SQL Server's T-SQL language.
This handy pocket guide starts with simple data retrieval and moves on to more complex topics, including the use of joins, subqueries, full text-based searches, functions and stored procedures, cursors, triggers, table constraints,
XML, JSON, and much more.
Learn how to…
- Use T-SQL in the Microsoft SQL Server environment
- Construct complex T-SQL statements using multiple clauses and operators
- Filter data so you get the information you need quickly
- Retrieve, sort, and format database contents
- Join two or more related tables
- Make SQL Server work for you with globalization and localization
- Create subqueries to pinpoint your data
- Automate your workload with triggers
- Create and alter database tables
- Work with views, stored procedures, and more
1 Understanding SQL
2 Introducing SQL Server
3 Working with SQL Server
4 Retrieving Data
5 Sorting Retrieved Data
6 Filtering Data
7 Advanced Data Filtering
8 Using Wildcard Filtering
9 Creating Calculated Fields
10 Using Data Manipulation Functions
11 Summarizing Data
12 Grouping Data
13 Working with Subqueries
14 Joining Tables
15 Creating Advanced Joins
16 Combining Queries
17 Full-Text Searching
18 Inserting Data
19 Updating and Deleting Data
20 Creating and Manipulating Tables
21 Using Views
22 Programming with T-SQL
23 Working with Stored Procedures
24 Using Cursors
25 Using Triggers
26 Managing Transaction Processing
27 Working with XML and JSON
28 Globalization and Localization
29 Managing Security
30 Improving Performance
A The Example Tables
B T-SQL Statement Syntax
C T-SQL Datatypes
D T-SQL Reserved Words
