Hugo Kornelis (8/3/2010)

---

mtillman-921105 (8/3/2010)

---

Third, us humans don't think this way typically I don't believe (thus, the good main question here). Since SQL is our tool, we should dictate how...

Oleg Netchaev (8/3/2010)

---

I would...

I think that this "feature" should be changed. Just because two numbers are integers, why assume the answer should also be an integer? :angry:

That would be terrific. We may still have some leftover BBQ in December...

Not that I'm aware of. But most people rave about Interstate BBQ (my favorite),...

I'm with Alvin! Yes, come on over here to Memphis and we'll show you what terrific BBQ's all about. 😀

I would consider adding a column that, in effct, marks the record for deletion. It could be as simple as a BIT column. Foxprow's used that before (although...

I believe this boils down to how much anxiety is created by witnessing experts. A little anxiety's good, but too much is counter-productive. Remember that it just depends...

I appreciate that UMG Developer. You know exactly why I chose that question. 😎

Yes, the answer could have been more specific. ...

Good points blandry.

I'm also worried about people playing computer games nonstop. I play them myself at times, but since I play a strategy game, I try to tell myself...

Interesting question - thanks.

The explanation led me to wonder what other character CAST() would return with 0. I've found two:

select cast('+' as smallint)

select cast('-' as smallint)

But why should a...

I rely on this site and buy books on SQLS.

Thank you SQLServerCentral!

Phil Brammer (4/13/2010)

---

mtillman-921105 (4/13/2010) OK, fair enough. Then how do you handle the nulls in your numeric fields where you want to add and you want the nulls to...

Hugo Kornelis (4/13/2010)

---

mtillman-921105 (4/13/2010)

---

But I still wish that SQL would use it as a zero since in the real world when we add 5 + NULL we want to see...