Home TQL statement for inserting json integer array to table rows
Reply: 0

TQL statement for inserting json integer array to table rows

user357
1#
user357 Published in August 16, 2018, 6:17 am

How do I insert a JSON integer array to a table column in SQL server. Suppose I have the following json variable:

declare @jsonArray as varchar(max);
set @jsonArray = '[1,2,3,4]';

How do I insert the integer values into a table's integer type column using some of the SQL server JSON statements/functions?

You need to login account before you can post.

About| Privacy statement| Terms of Service| Advertising| Contact us| Help| Sitemap|
Processed in 0.245807 second(s) , Gzip On .

© 2016 Powered by mzan.com design MATCHINFO