SQL Server T-SQL Recipes, Fourth Edition

Introduction

Sometimes all one wants is a good example.

T-SQL is fundamental to working with SQL Server. Almost everything you do, from querying a table to creating indexes to backing up and recovering, ultimately comes down to T-SQL statements being issued and executed. Sometimes a utility executes statements on your behalf; other times you must write them yourself.

And when you have to write them yourself, you’re probably going to be in a hurry. Information technology is like that. It’s a field full of stress and deadlines, and don’t we all just want to get home for dinner with our families?

We sure do want to be home for dinner, and that brings us full circle to the example-based format you’ll find in this book. If you have a job to do that’s ...