curt_coker (9/15/2015)

---

A programming language should work in an intuitive way and/or hide needless complexity. Really, 0.999 and 1.999 should both evaluate to a common data type and therefore be...

David Harder (9/3/2015)

---

The question is valid. The BOL reference is valid. The comment about understanding how a function works is valid. But the reason the result of the query is...

Steve Jones - SSC Editor (9/2/2015)

---

The sixth one should have had brackets. That's been corrected. However, I missed a few since there could be no joiner (=/AS) in there, so...

Steve Jones - SSC Editor (8/4/2015)

---

And as a side note, I didn't try this from memory, or fail to test it. I changed the names of my logical files on...

rmechaber (7/28/2015)

---

Here's a nice, straightforward -- but perhaps fuller -- explanation of what's going on here if you're still puzzled:

https://www.simple-talk.com/sql/t-sql-programming/ten-common-sql-programming-mistakes/[/url]

EDIT: URL corrected for the web-friendly version of the page instead...

Jeff Moden (5/7/2015)

---

... I would have expected an article on "Advanced T-SQL" to better explain what cursors should be used for, why they should generally be avoided, and...

Eric M Russell (2/10/2012)

---

Another scenario is where the developer includes un-needed table joins and returns additional columns that are never referenced by the application or reporting tool. I've even seen...

That sounds painful. 😉

ronmoses (4/17/2015)

---

I'm not sure it's accurate to say "all need to be of the same data type." I believe all need to be able to be implicitly converted to the...

I picked #4, but I can see the case for #2 being the more correct answer. At least I came close.

Good...

TomThomson (3/27/2015)[

But I had looked quickly and gone with "sometimes" before I made the above reasoning - careless of me, I should have gone with "yes" and lost the point...

sestell1 (3/26/2015)

---

I think whether the file gets created depends on if the syntax error causes the package to fail validation or not. I think the second question also depends...

Thanks for this article. I had created views to do something similar for several tables. But your solutions are simpler than what I did.

Now I'm hoping to...

gmmastros (3/23/2015)

---

An undocumented procedure is a procedure that is distributed along with the database engine, but is undocumented. Since it is undocumented, there is no guarantee that Microsoft will...