Simple, yet good question, thank you Steve.

Not familiar with this particular feature as never had to use it before, that`s why must do some R&D before answering.

Thomas Abraham (1/9/2014)

---

Let's try to simplify:

"Option 3 will always return an integer value for @Result" is false, as it is not GUARANTEED to provide a specific value for @Result ...

Hmm, another controversial question!

Very easy one, actually it took me 2 sec to read the options and answer. 😀

That`s similar to the previous CHECKIDENT question last week, but any way nice question.

Thanks.

Very nice tricky question.

Definitely learnt something new today, thanks Diana.

Hany

Had to do some R&D to figure this out, as I tried to test it myself, found that I can register CMS with both Windows or SQL Authentication, so I...

NBSteve (12/26/2013)

---

Good question, but the explanation should really mention that DBCC CHECKIDENT has two different behaviors based on whether or not there have been prior (non-truncated) rows present. I...

Easy one, thanx.

For some places in the world, this type of questions is totally unfamiliar!

If it`s going to make you dig `n` search, then it`s a good question (most probably).

Thanks Steve.

sestell1 (12/20/2013)

---

LAG works for a fixed number of rows before the current row.

For all the rows prior to the current row, wouldn't you use something like ROWS BETWEEN UNBOUNDED PRECEDING...

Nice & easy question, can be simply answered by just excluding the non-logic answers.