CODEWITHSUNDEEP
sqljsonsql-serverpowershellinvoke-sqlcmd
NewbieHere
NewbieHere

Reputation: 144

JSON data in SQL Server table column getting truncated on extraction

We are using SQL Server 2019. We have databases in SQL Server. In one column (Events) of a table, the data is stored in JSON format and data type of that column is - nvarchar(MAX).

Every night, a job runs to extract the data from the table to JSON file. The issue that we are facing is that the data of Events column is truncated in the json file. It is only taking first 4000 characters from the table column to the JSON file.

We are using Invoke-Sqlcmd powershell command to get the data from database.

Kindly let me know how to avoid data truncation for the Events column.

Upvotes: 0

Views: 44

Answers (0)

Related Questions