Great question on ghost records that are not as commonly mentioned about.

Thank you.

Great question. The Union will eliminate the duplicates as has been demonstrated. Thanks.

That's a good question and one that is important especially for a beginner when one may require input data from another table's results of a simple query. Thanks

Great question and I like that it touches the ROLLBACK concept.

Nice and interesting question.

Nice and easy question that should result to same answer regardless due to the use of the SELECT DISTINCT. Thanks.

Nice question on the COALASCE function that ignores the data type and size hence returning the entire string. Thanks

Nice question and takes us back to basics. Thanks.

Pretty straight-forward question if one understond the question right. Thanks.

Good tricky question and yes, duplicates are possible to occur though depending on their intended purposes, it may usually not be recommended and therefore different sequential numbers ranges are used...

Thank you for the question.

Nice question and resources on the rounding. Thanks.

Great question and pick on the data types. It reminds that by default '1' is assigned to non-defined variable declaration for the char & varchar data types.

Thanks.

Nice question. Learnt more on the Round() and that it always returns a numeric value. Thanks. 🙂

Interesting question on the TempDB. Back to basics and the url below under the 'Restrictions' states all the facts too.

URL: http://msdn.microsoft.com/en-us/library/ms190768.aspx

Thanks