CHAPTER 11

image

The SELECT Statement

You will use the SELECT statement more than any other T-SQL statement in your database career. This is an axiom that applies to DBAs as much as it does to developers. SELECT is your friend, your assistant, your sidekick. Whenever you have a question about your database, chances are SELECT will give you the answer. That said, SELECT in the wrong hands can be evil. Evil! It’s easier to make SELECT give you the wrong data than the right data (much easier, usually). Let’s see if we can keep SELECT on the side of the good guys.

What Is the SELECT Statement For?

The SELECT statement can be used for a number of purposes, ...

Get Introducing SQL Server now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.