Building REST API with SQL Server using JSON functions

preview_player
Показать описание
SQL Server 2016 and Azure SQL Database provide built-in functions that enable you to easily transform JSON documents into relational format and vice versa. Exchanging JSON documents between client applications and SQL Database is now easier than ever. In this session you will see how to create REST API using built-in JSON functionalities in SQL Server 2016 and Azure SQL Database.
Рекомендации по теме
Комментарии
Автор

Wow, well done on JSON and REST API with JSON.

eqhome
Автор

can i still use these built-in functionalities if my my sql server is SQL Server 2012 and i am using MS SQL Server Management Studio 2016, or does the server itself has to be of the 2016 version?

ssflip
Автор

in the example, it's never shown how to query the tags column.

jonarse
Автор

Hi can anyone give me the details of JSON functions for MS sql server Query to JSON output. I am on one project which need to create reports from ms sql server tables data into JSON format as per client requirement. and I am trying to do as it is but I need some more help. so please if anyone have json book or json blogs then share it. thank you for the video it's little bit use full for me.

Ptoraskar
Автор

SQL Server is not creating a REST API. It’s just formatting data as Json. How incredibly misleading. Waste of time.

Bruhfinally
Автор

Very bad presentation and you did not tell exactly.

selsoft
join shbcf.ru