SQL SERVER – Information Related to DATETIME and DATETIME2

I recently received interesting comment on the blog regarding workaround to overcome the precision issue while dealing with DATETIME and DATETIME2.I have written over this subject earlier over here. SQL SERVER – Difference Between GETDATE and SYSDATETIMESQL SERVER – Difference Between DATETIME and DATETIME2 – WITH GETDATESQL SERVER – Difference Between DATETIME and DATETIME2SQL Expert Jing Sheng