Question

SQL server存储过程实现JSON数据解析，然后插入数据库表？求高手指点

[{"employee_number_backup":"AC100000","employee_name_backup":"接口测试"},{"employee_number_backup":"CB222222","employee_name_backup":"接口"},{"employee_number_backup":"AB333333","employee_name_backup":"测试3"},{"employee_number_backup":"AB444444","employee_name_backup":"测试4"},{"employee_number_backup":"AB026395","employee_name_backup":"测试11"},{"employee_number_backup":"AB026396","employee_name_backup":"测试333"},
JSON 数据怎么用存储过程解析，然后插入数据表！

Answer 1

两种方式
1、SQL有个charindex 函数，可以用这个函数配合substr实现 split功能实现循环插入
2、sql 2008以上存储过程支持表值参数，json反序列化在程序里更方便，所以反序列化之后通过表值参数传递

追问

麻烦您能给写个简单的例子吗？我不是很熟SQL SERVER。

追答

加QQ群吧,15864834