Return JSON from a SQL Query

added by DotNetKicks
7/7/2020 3:39:36 PM

591 Views

Do you know, you can return JSON data from a SQL query? It is very useful in writing REST or GraphQL API on the top of a SQL Server Database. Let us say you have two tables as shown below, And an emp table as below, You can query employees with their departments as below,...


0 comments