PHYData DBA (8/18/2014)

---

Or you could just do lots of testing to make sure using NOLOCK is not affecting your queries results adversely and move on.

Why waste time, money,...

That's the wrong question to...

It's been like that for a long time already. In some places, the QotD author is presented with the correct author. In other places, it is presented with the author...

Thanks, all, for the nice words! 😉

Sektor / Iulian: Yes, this is indeed different from C#, which (as far as I know - probably not very far) uses multiple-pass compilation....

TomThomson (8/6/2014)

---

Hugo Kornelis (8/5/2014)

---

I see that Tom already posted an explanation. I think he is correct, but I will phrase it simpler - my explanation is that a variable is...

And to conclude my rapidfire of messages - thanks all for the kind messages.

This question was indeed easier than some of my others. My goal with this question (and the...

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...

I am not surprised by...

Raghavendra Mudugal (8/5/2014)

---

I executed the script in 2008R2, and I re-read the question and see there is no R2, but still went with the gut feeling that this must work,...

Thans for the addition, Koen!

I only realise now (after reading your message and another on the same topic)...

Correct. SQL Server will parse and compile the entire batch (and the compiling part includes generating...

See my post above (which I started...

Mighty (7/30/2014)

---

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

Roland C (7/27/2014)

---

I am sorry, but I don't agree 🙂

I executed the script in SSMS (SQL Server 2012). It returned "10 row(s) affected", the csv file was created, but was...

I realized that #Employee would not be available in the context of the bcp command, but had to do some digging to predict whether that would result in an empty...