oooppsss did not look at the null value, answered to fast !

end of sequence for good answers !

really nice question thanks

I am on a really good sequence 🙂

five good answers on a range !

🙂

Nice and easy basic question

Really, you like to think complicated ...!

This was a nice question with an essential point on nested transactions,which clarify for beginners this point

expert advices finally lead to never more understand...

nice question thanks

got 1 point, but was not really sure to understand meaning of the question

Found the answer by logical deduction as Server Database Engine purpose is to store, process and secure...

easy one point

thank's

nice question thank's

did not know but google did !

+1

Thanks

easy one

Distinct uses null values normally

count() eliminates them as well as all the other arrgegates functions

Never used it, looked at technet, found the announce too!

bad guess alas!

easy one, do not use self-referencing every day but knowed this was the only one case where truncate table worked nice

+1

obviously i forgot everything about filestream shoul read a bit

Update works well in CTE for updating underlayed table too.

Nice and easy questions Thanks.

really easy as there is NO transparent CR/LF invisible caracters ! 🙂