same

also agreed. I don't know anything about JSON but was able to get enough out of documentation to see what the right...

The answer should be No. Open a new window and paste in the following and it works just fine:

with myCTE(n)

as

(select 1

)

select * from myCTE

No semicolons anywhere in the window....

I don't know anything about XML but the following works just fine as well:

CREATE TABLE #Mytest2 (id INT, x XML)

INSERT #mytest2

VALUES

(11, CAST('<customer...

I tried the modified code and it still works for me on SQL Server 2012

Alan.B (5/31/2016)

---

I don't know why you get an error. This code

CREATE TABLE Mytest (id INT, x XML)

INSERT mytest

VALUES

(1, CAST('1200' AS XML))

...

Yep, I want my point please.

TomThomson (4/28/2016)

---

BWFC (4/28/2016)

---

That was surprisingly easy for one of Andy's questions. There weren't any tricks or things that we should have inferred from the position of a comma :cool:....

Luis Cazares (1/29/2016)

---

tom.w.brannon (1/29/2016)

---

I knew that coalesce would return the highest data type but never remember the ordering of that so I thought it was either going to be 10...

I knew that coalesce would return the highest data type but never remember the ordering of that so I thought it was either going to be 10 or divide by...

One reason I miss a lot of these kinds of questions is that I don't do a lot of DBA oriented work such as backups and logins and server set...

patrickmcginnis59 10839 (12/16/2015)

---

I'm...

I don't understand why non-clustered is required. While not a best practice, why couldn't you include the non-key columns in the definition of the clustered index?

I also guessed (wrong) when the answer I was looking...

I don't deal with this level of the db but it seems like a trick question. At https://msdn.microsoft.com/en-us/library/ms190940.aspx it states 'These files are located in <drive>:\Program Files\Microsoft...