Tuesday, July 12, 2016

JSON Support in SQL Server 2016

--JSON Support  in SQL Server 2016
Example:=

Select top(1) TrnNo,Amount
from Sale
For JSON  PATH, ROOT('TrnNo')

Output:=

{"TrnNo":[{"TrnNo":1,"Amount":100}]}

No comments: