MS sql server table data Export JSON Format -sql clause, screenshot

 

SELECT *  FROM [NORTHWND].[dbo].[Suppliers]     FOR JSON PATH