Andrew Watson-478275 (6/23/2011)
You don't even need the WHERE clause. I've just done an SSIS step where I needed a single row returned, but didn't care about the contents, so I used
and it worked fine.
I think the concept the question was testing is;
"Do you need a From clause to use a where clause?"
I hope we all understand that a where clause is not needed for a SELECT statement.
i.e. SELECT @ParameterName = @@Version