Description: SQL Server tips, help, news, and more!
maintenance (6121) sql server (656) json (321) stored procedure (7) data types (6) sql server help (1) modified date (1) nested select (1) sub query (1) kill connections (1)
SQL Server Help And Tips
In SQL Server 2016 they are added support for outputting your query results in JSON. When you serialize your data to JSON using the FOR JSON clause, a data type conversion happens. The data types are converted from SQL Server data types to JSON supported data types.
For more information on how to convert your result set to JSON: www.sqlserver.info/syntax/json-in-sql-server/