Для запросов JSON в SQL Server 2016

Question

У меня проблема в SQL Server 2016 с FOR JSON запросы. Вывод вырезан в указанном количестве символов.

например, я использую этот код, и его результат сокращен до 2033 символов:

SELECT  
    [id] as id
    ,[id] as dmn
    ,[engin] as engin
    ,[page] as page
    ,[name] as page_name
    ,[lastedite] as lastedite
    ,[deleted] as deleted
    ,[MimeType] as MimeType
    ,[cache] as cache
    ,[userid] as userid
    ,[ownerid] as ownerid 
FROM  
    test 
FOR JSON PATH