GitHub

xml-format-files-sql-server.md

SQL Server 2019 provides an XML schema that defines syntax for writing XML format files to use for bulk importing data into a SQL Server table. XML format files are self-describing, making them easy ...
GitHub

format-query-results-as-json-with-for-json-sql-server.md

description: Format query results as JSON, or export data from SQL Server as JSON, by adding the FOR JSON clause to a SELECT statement. [!INCLUDE [sql-asdbmi-asa ...
Ars Technica

SQL Server - specifying date format

This should be simple but for some reason I can't find it anywhere... <br><br> -- View image here: http://arstechnica.infopop.net/infopop/emoticons/icon_confused.gif ...
Ars Technica

(SQL) How To Select Based On DateTime Format

Everything else with SQL and DateTime seems to work so well. i.e. it just works I can declare a DateTime in C# and it will drop straight into SQL with no problems or anything.<BR><BR>However, getting ...