Is a SELECT statement always executed?

In today’s blog posting I want to talk about a quite simple question in SQL Server: is a SELECT statement always executed? The question itself seems to be quite easy, but the answer to it isn’t that simple. Let’s look at the following example: SELECT * FROM Person.Person As you can see this is a …

Is a SELECT statement always executed? + read more