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 O’Reilly online learning.

O’Reilly members experience live online training, plus books, videos, and digital content from 200+ publishers.