Which correct answer? There are three of them:

a) Query 1 will run successfully [true]

b) Query 2 will run successfully [also true]

c) Both...

Yes, I agree this seemed fairly obvious, but the fact that there are three correct answers (the first three options are all true) and I'm only permitted to choose one...

Apparently, while variable declaration occurs at compile time, inline assignment does not. Good to know.

ron

That was it. I didn't think to specify a column list in that part of the statement. (So yes, I was doing something stupid.) Thank you so...

Just to pre-emptively answer a couple of likely questions...

1. I've confirmed that the column list in that statement matches the complete list in the SecuritySettings table, and in the correct...

Stewart "Arturius" Campbell (3/11/2014)

---

ronmoses (3/11/2014)

---

The answers appear to suggest that the following is true:

"The columns in new_table are created in the order specified by the select list."

However, http://technet.microsoft.com/en-us/library/ms188029.aspx says...

"Specifying an...

The answers appear to suggest that the following is true:

"The columns in new_table are created in the order specified by the select list."

However, http://technet.microsoft.com/en-us/library/ms188029.aspx says...

"Specifying an ORDER BY clause does...

Richard Warr (3/6/2014)

---

It's anything but logical behaviour and you can only get the question correct if you know that caveat on the REPLACE function (or if you just run the...

Some service I know nothing about. I've brought it to the attention of the appropriate folks.

thanks!

ron

Hmmm... it is...

At this...

Thank you John. I was basically looking for any answer other than, "Oh my no, something's definitely wrong." And you provided it! 🙂

thanks,

ron

I figured a half-hour of research on this question was more than enough. I accept my fail. At least I didn't cheat! 😀

And since I've never reset an...

You didn't say it had to be complicated, so...

SELECT ROW_NUMBER() OVER (PARTITION BY x ORDER BY y) AS RowNum, x, y

FROM tTable

ORDER BY RowNum;

ron

Luis Cazares (12/2/2013)

---

Blast it, I read this whole thing wrong....