Luis Cazares (12/15/2016)

---

TomThomson (12/15/2016)

---

The quasi-BNF for inline TVFs at the CREATE FUNCTION (Transact-SQL) page is quite amusing: it gives you four options for the parentheses: have both, have neither, have...

Yes, the TechNet article is inaccurate. As per the MSDN documentation (https://msdn.microsoft.com/en-us/library/ms186755.aspx), the parentheses are optional.

Koen Verbeeck (12/14/2016)

---

sknox (12/14/2016)

---

Koen Verbeeck (12/14/2016)

---

sknox (12/14/2016)

---

The question is written as "How can you identify any differences?"

However, 3 of the four answers fit that question as written.

The question should...

Koen Verbeeck (12/14/2016)

---

sknox (12/14/2016)

---

The question is written as "How can you identify any differences?"

However, 3 of the four answers fit that question as written.

The question should have been "How...

The question is written as "How can you identify any differences?"

However, 3 of the four answers fit that question as written.

The question should have been "How can you most...

Mikael Eriksson SE (11/24/2016)

---

Actually none since limitations of the data type but number 2 works for more years then number 1...

Toreador (11/15/2016)

---

The answer is right, but the explanation is wrong, as it says the answer is 0,1,2,NULL,NULL

If that had been one of the options I might have got it wrong...

You can use source in the text of your R script to bring in a file. Cf http://stackoverflow.com/questions/3502925/include-files-r

Stewart "Arturius" Campbell (9/30/2016)

---

Nice, easy question to end the week on, thanks Steve.

Just a point of confusion in the options:

a table variable, a table in the table, or a temp...

Thanks, Steve! While I think it's...

Of course, for user-defined periods which are used often, the best thing to do is to add these calculations into the generation of your calendar table ( http://www.sqlservercentral.com/articles/calendar/145206/ )...

Was going to post this. For example, one...

TomThomson (9/9/2016)

---

Since we are not permitted by MS SQL Server to write the literal as .7 instead of as 0.7, we are forced to write at least one digit...

Good question, but the explanation is incomplete. Precision is only half of the story, the other being scale.

1.0 can fit in a number with precision of 1, if the scale...

THIS.

I understand why Andy didn't specify SPARSE, as that...