Hugo Kornelis (5/18/2013)

---

I would consider not including the end point to be counter-intuitive (and not including the begin point even more so - and please don't ask me how to...

Mike Dougherty-384281 (5/18/2013)

---

We shouldn't use English as a reference for language implementation. Almost nothing is self-evident.

"Between Baltimore and Boston, which is your favorite city?"

- you have two enumerated options,...

Hugo Kornelis (5/18/2013)

---

However, with other data types than integer values, there is indeed amibiguity in the English use of "between". On a numeric (non-integer) scale, when a value is between...

SQLRNNR (5/15/2013)

---

The Windows 7 interface is sort of there under the covers. You can switch back and forth. That aside, there are some quirks with Windows 8 (like...

I'm not...

Nice question, good explanation. No SQL weirdness like that in yesterday's question, so much easier.

Hugo Kornelis (5/15/2013)

---

Dave62 (5/15/2013)

---

A minor typo in the explanation.

"... As soon as one evaluates...

Ouch. I got this one wrong because I had forgotten how far SQL diverged from its original aim of providing queries that meant what they looked as if they meant....

Hugo Kornelis (5/15/2013)

---

There are lots of other products that I do not love. Some Microsoft, some not. Some regularly used by me, some not. Try to find evidence on the...

srienstr (5/15/2013)

---

Hugo Kornelis (5/15/2013)

---

(and if you go out in the street and ask people if -5 is between -1 and -10, I'm willing to bet that 99% of all people...

Nice question and good find of yet another error in BOL.

But the only reason I've ever grouped by an identity column was to find duplicates when some not very bright...

Nice straightforward question.

Same sort of topic as last Friday's, but one big difference: this time BOL documents the behaviour.

Well, with something like this there are six possibilities only:

1. You know it because you had to find out before and remember the results

2. You run some code...

Hmmm. Interesting idea.

Maybe combine it with Honey Accounts: as well as the real accounts, you have lot of accounts which have insufficient privilege to do anything...

I think your problem is this line:

SELECT @LinkTable= @LinkTable FROM [ABC].[dbo].[MyTable] WHERE TableID=7

Try changing it...

I've seen a lot of ranting about how the different UI in Windows 8 makes it very difficult for someone used to older versions of Windows to use it, so...