which version of Management Studio are you using? I can't get this option, with Sql Server 2012

Good question. Thanks

Nice but simple question: I'm wondering why it worths 2 points

+1

Nice question

I haven't used First_Value() and Last_Value() before, but remembering the OVER syntax has helped me to guess the right answer

interesting question.

Can you explain why the other answers are wrong?

+1

Good question, I've learnt something new

a basic concept but it worth to be remembered

Thanks

I agree, it's easier than it appears

Finally a question for my level.

Thanks

Thanks for the question

I've missed something about synonym. I need to review the subject

I've never thought about insert data in a CTE

Nice question to start the weekend

Thanks

I need to study more about USER_NAME() and SUSER_SNAME() functions

Thanks

Nice question, good way to think about bit data type