Eric M Russell (11/5/2014)

---

Hey, I'm always pleasantly surprised to find a thumb drive in my swag bag. It would be kind of neat to have a Halloween themed conference each...

I had trouble getting my head around the "OPENQUERY-1" question a few days back, but found this question a little easier thanks to the research and discussion of that one.

...

The Atlantic article is a fascinating piece on the introduction of "big data" analysis to the HR world, I was interested to read about the use of game apps "Dungeon...

Gary Varga (1/23/2014)

---

OCTom (1/23/2014)

---

...

As far as available choices... everyone has their limit as to when it becomes a problem. Personally, if a restaurant has five choices, I would likely complain...

The question has provided a bit of cultural enlightenment for me too.

I've been seeing lots of email with "Black Friday sales" in my junk tray, and mistakenly thought they...

Samith, discover more fun of combining block comments and in-line comments ... my basic rule, to avoid the error your example raises, always put an inline comment just in front...

Mike Dougherty-384281 (8/5/2013)[hrI have seen incompletely-highlighted code get run. I've been advising code "safety" at lot lately. It looked like an opportunity for someone (clearly not you) who...

Mike Dougherty-384281 (8/5/2013)

---

zerko (8/4/2013)

---

Select * From Employee /*

Update Employee

Set LastName = 'Smith'

--*/

Where LastName = 'Smeith'

So I can now write quite a complex update statement if needed, it's protected in...

Amazing where a bit of collaboration can take an idea - by combining the 'toggle trick' example from 'the-SQList' with Timwell's 'select/update' example, discovered another way of combining the select...

Hi all, and thanks for the positive feedback here. I've not been ignoring these comments, but Murphy's Law meant this article hit the web just as I started some long-awaited...

When I need to write this sort of query, I use "NOT IN" , instead of "<> ALL" - Seems to do the same thing, and easier to understand what...

Coming in late on this topic, and I think most of the debate is done and dusted, but it was fairly apparent to me that the question asked "How many...

Nice question thanks Ron, and good to know that IIF is going to be available in 2012 .. I used to use the syntax a lot in a previous language....

But surely, since ALL of us ALWAYS screen-lock our computers when we are not physically present, and the error message required someone else to type it into the SSMS Messages...

wolfkillj (5/15/2013)

---

I've been bitten by the BETWEEN bug with negative numbers before. Now that I do a fair amount of work with north latitude (0 < n < 90) and...