+1

(and, thank you,...

Thank for the post, new one to me.

I really had no idea what is this all about, I just referred the help and got the below and then selected the...

Thank you for the post, Dave, very easy one. (at least of me, but the ratio is now almost 50-50).

Seeing the field list in a tool-tip is easy without...

Carlo Romagnano (8/5/2014)

---

A little variation:

-- this runs

DECLARE @i int = 1, @j-2 int = 2;

SET @i += 2;

SELECT @j-2 * @i

GO

-- this raises error

DECLARE @i int = 1, @j-2 int...

Thank you, Hugo, it was very simple and easy, for me. 🙂

(have one sql script written where the variables are assigned this way, so was sure of my choices. I...

SQLRNNR (8/4/2014)

---

Phil Factor (8/4/2014)

---

I'm sorry if it got scored too high, but when I ask this as part of a technical interview, it seems to stump a very large proportion...

barry.mcconnell (8/4/2014)

---

I think the point value was appropriate, not due to the difficulty of the question, but rather the value of knowing the basics well. Knowing some arcane bit of...

thank you for post, simply nice and easy and yet it still fires the curiosity of knowing the answer selected is the correct one. 🙂

William Vach (7/31/2014)

---

Good question on sysobjects table. You could also have added a distinct to the select statement, so I would only get any table having multiple constraints only...

basically and mainly, the usage of the default DB points to "MASTER", as I did the same to.

Are...

This helped and fixed the problem, thank you

(Using... MSSQL 2012 DEV EDT)

Msg...

Thank you for the post, interesting one.

I guessed and got it wrong, didn't had even a nearest clue what I was looking for, but this opened a new door for...

Thanks, Hugo, this explains everything

Hugo Kornelis (7/28/2014)

---

However,...

Thank you for post, really nice one.

I got it right for this reason, but I am not sure or I have not yet checked in the SQL if this is...

Roland C (7/24/2014)

---

Certainly I missed something, but what about http://technet.microsoft.com/en-us/library/ms187638%28v=sql.105%29.aspx ?

In queries that include a correlated subquery (also known as a repeating subquery), the subquery depends on the outer...