drew.allen (9/27/2016)
Okay, is it just me? I've seen two different people post sample data where the datetime data is given in hex and converted to datetime. It's not like the datetime data is sensitive, and it certainly isn't human legible.Drew
if you use the SSMS GUI for "generate scripts" and "schema and data".....MS used to script as such...cant remember which version it changed on though
in SQL 2016 it scripts as CAST(N'2016-08-20T22:25:00.000' AS DateTime)
________________________________________________________________
you can lead a user to data....but you cannot make them think
and remember....every day is a school day