[SQL] ah ?! Query the analyzer BUG ?!

When we use the SQL Server Query analyzer to view a table, we can see such a record:

The strange thing is that the "ReceiveTime" field is clearly of the datetime type. How can it be the number "62016004?

How does SQL Server insert such numbers? Even if our program is wrong and we want to insert it into the record, we will get an exception?

We also have experience in data warehousing, which may be a BUG in the query analyzer.

I wrote a query Example Using VBScript and reported every field in this record!

 

Conclusion:

Microsoft's query analyzer is indeed incorrect,In fact, what is stored in the database is correct.,An error occurred while querying the analyzer display.The garbled Content field may have an impact on the query analyzer's "display results by table". If it is "display results by text", there will be no problem ,-_-'''.

Trackback: http://tb.blog.csdn.net/TrackBack.aspx? PostId = 79109