It depends. It only works if Joe (or anyone else with default schema 'HumanResources') would create the...

TomThomson (8/27/2014)Neither do I understand why people are claiming that two separate statements are a single query; queries are, properly speaking, dml statements but maybe it's fair enough to count...

Not sure I see 4 correct answers (taking the "only" part of the first answer strict, so that any size other than 116 would not work), but 3 correct answers...

Easy one, but just because I installed many SQL Servers that needed Kerberos Authentication.

That is more or less what I was thinking, but in that...

For me the way how SQL Server handles the declaration of the variables is a bit strange.

This piece of code doesn't return an error, even though the declaration of

Definitely way too easy.

Still easy, but if table B would have the values 1 and 2, then at least you could have explained something about the different join types.

Sean Pearce (6/20/2014)

The default collation is based on the Windows system locale but none of the defaults are case sensitive. Find the paragraph [Default Collations in SQL Server Setup] in...

Raghavendra Mudugal (6/20/2014)

---

Well... the exchange of thoughts on collation is been going on from very long back, but at the end we all kind of nodded that if the mention...

Definitions

- "On-site": taking place or situated on a particular site or premises.

- "Off-site": taking place or situated away from a particular site or premises.

So not on-site is off-site. This could...

[Monday morning issue... remark was useless]

Easy one, but the most easy way of doing this was not an option:

SET @boolean = @TrueFalse

+1

Missed the "(select 2)".

Not really happy with the wording of the answers.

I left the first option out, because the second option seemed "supersede" the first option.

Koen Verbeeck (5/16/2014)

---

Am I the only one who thought the question was worded a bit strange?

Anyway, as stated...