Sean Lange (1/16/2015)

---

TomThomson (1/16/2015)

---

Sean Lange (1/16/2015)

---

TomThomson (1/15/2015)

---

Sean Lange (1/14/2015)

---

Koen Verbeeck (1/14/2015)

---

Nope, I'm control freak enough to change it to SELECT 1. I even do it in the scripts generated by SSMS.

I might need some help...

If we ever work together we may never finish anything since we will just keep changing * to 1 and 1 to *. I am reminded of the Sneetches story by Dr. Suess. 😛

I guess I'm not as consistent as you guys. I generally use select 1 but sometimes select *, probably depending on what I've been looking at recently. But I always use count(*), never count(1). wouldn't bother to change it if I found it, though.

Not sure I would call it consistency, more like anal retentive.

But to call it anal retentive you would have to admit that the version you want to keep is shit. So perhaps that's not the best description. :w00t:

I nearly spit out my coffee Tom. :-D:-D:-D