Sunday, May 8, 2016

Difference between #Table and @Table in sql server





Json String in Sql Server

In this post i will show how to display/Convert Table Rows to JSON String.

Continuing the previous Post Create Temp Table in Sql Server

OutPut:

{
                "Data": [{
                                "id": 1,
                                "name": "Kiran",
                                "active": 1
                }, {
                                "id": 2,
                                "name": "Ravi",
                                "active": 1
                }]

}