SQL Server Management Studio (SSMS ... You can copy and paste the values into a query pane in SSMS, but you’ll still need to manually navigate through each value and add a comma to them.

With SQL Server 2016, you can store JSON objects in your rows. Here’s how ... IsPremium', 'false') You can also add a new object to JSON arrays by adding the "append" keyword in front of your path.