JSON2SQL JSON and T-SQL in MS SQL 2012 and newer Have a look at the ProcessJSONExample for sample procedure. Sample JSON: '[{"LosID":"023220711000","VariantenID":182}, {"LosID":"109230914400","VariantenID":473}]