create table employ1(
id [bigint] identity(1,1) not null,
l1d [int] null,
name [nvarchar](20) not null,
age [int] not null
)create table employ2(
id [bigint] identity(1,1) not null,
l2d [int] null,
name [nvarchar](20) not null,
age [int] not null
)create table employ3(
id [bigint] identity(1,1) not null,
l3d [int] null,
name [nvarchar](20) not null,
department [nvarchar](50) not null
)
go
declare @json nvarchar(max)=N'[{"TableName":"Employ1"，"INSJson":{"l1d": 1, "Name":"Alice", "Age": 30}},
{"TableName":"Employ2","INSJson": { "l2d":2,"Name":"Bob", "Age":25}},
{"TableName":"Employ3","INSJson":{"l3d": 3, "Name":"Charlie","Department":"IT"}}
