--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}]}
Example:=
Select top(1) TrnNo,Amount
from Sale
For JSON PATH, ROOT('TrnNo')
Output:=
{"TrnNo":[{"TrnNo":1,"Amount":100}]}
No comments:
Post a Comment