Very interesting topic....

Hm... Interesting solution. May be enough to make a data validation?...

Good post. If we read description about datetime: "Values with the datetime data type are stored internally by Microsoft SQL Server as two 4-byte integers. The first 4 bytes store the number of days before or after the base date, January 1, 1900. The b...

You shouldn't use sp_ in SQL Server unless you really mean it. If you wanna naming stored your procedures like "sp_" add prefix "i" or "u" before and you will get "isp_"(internal sp) or "usp_"(user sp)....