I came to the discussion before answering in hopes that someone would have said the correct answer, but alas my search was quite unfruitful, so I had to end up...

Hugo Kornelis (9/5/2014)

---

One more reason why I hope that the semicolon will become mandatory in a future version is this snippet that my boss five job changes back used when...

Toreador (7/7/2014)

---

BWFC (7/7/2014)

---

I'm sure I'm missing something very basic here but I was under the impression that because there is no ordering automatically on a table, the row returned by...

Nice question, thanks!

I got lucky with my answer, I thought the error would be trying to insert a duplicate value in an identity column. In retrospect, I see there's no...

Here's the link to the previous question[/url], for anyone who got curious like me but doesn't want to go through the QotD pages. 😛

I'm guessing it was supposed to have 4 options...

George M Parker (10/18/2013)

---

Same here, wasn't familiar with the...

Sorry if it's a stupid question (English is not my native language), but what does WEF stand for?

I love how sassy that option is, though.

zerko (8/4/2013)

---

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

sknox (9/19/2013)

---

(...)

Consider, for example, the following:

DECLARE @Start datetime = getdate();

SELECT * FROM v_SeveralMinutesToExecuteView;

DECLARE @End datetime = getdate();

SELECT DATEDIFF(ms,@Start,@End) as TimeToExecute;

If values were set during parse time, @Start and @End would...

L' Eomot Inversé (8/1/2012)

---

Peter Kryszak (2/6/2006)

---

I agree with your point that the "permissions options" are valid issues especially when best practices were mentioned.

I think the point of the...

L' Eomot Inversé (9/11/2013)

---

Revenant (9/11/2013)

---

L' Eomot Inversé (9/11/2013)

---

Primo Dang (9/11/2013)

---

L' Eomot Inversé (9/11/2013)

---

isaquedejair (9/11/2013)

---

Discordo do resultado ser "2", pelo fato de que no momento de gerar o insert ocorre um...

L' Eomot Inversé (9/11/2013)

---

isaquedejair (9/11/2013)

---

Discordo do resultado ser "2", pelo fato de que no momento de gerar o insert ocorre um erro

"String or binary data would be truncated.", o...

Knut Boehnert (8/15/2013)

---

MikeSpike (8/15/2013)

---

But why is the result (0, 1) eliminated?

Does the engine first pick cp.pkey=0 from row 1 and 2 then looks at row 3-4 to check if up.pkey...