SQL SERVER – SELECT 1 vs SELECT * – An Interesting Observation | Journey to SQL Authority with Pinal Dave

Many times I have seen issue of SELECT 1 vs SELECT * discussed in terms of performance or readability while checking for existence of rows in table. I ran quick 4 tests about this observed that I am getting same result when used SELECT 1 and SELECT *. I think smart readers of this blog… Continue Reading...

Source: SQL SERVER – SELECT 1 vs SELECT * – An Interesting Observation | Journey to SQL Authority with Pinal Dave