Open1
SQLServerでテーブルの各レコードをJSONとして取得する方法
SELECT (
SELECT t.*
FOR JSON PATH,
WITHOUT_ARRAY_WRAPPER
) AS record
FROM your_table AS t
SELECT (
SELECT t.*
FOR JSON PATH,
WITHOUT_ARRAY_WRAPPER
) AS record
FROM your_table AS t