SQL server will accept datetime strings in more or less any sensible format for the purposes of comparison.<BR><BR>select * from employee<BR>where hire_date='1993-08-19'<BR><BR>select * from ...

Ok, is there a setting in SQL Server 2000 that changes the date format from DD/MM/YYYY to MM/DD/YYYY. What happened was that on a customers sql server it is showing that date format and is ...

However, SQL Server 2016 also fully supports the rowset-to-JSON query scenario when you write a regular T-SQL query and then map results to JSON objects via the FOR JSON clause. For more information ...

So, with these non-SQL formats, potentially any data in any existing format, ie unstructured, can be provided with a structure – schema-on-read – as data is queried.