Sql Server数据批量更新
时间:2021-07-01 10:21:17
帮助过:19人阅读
‘1010‘ AS id,
‘小妹1130946325‘ AS name,
‘2‘ AS sch_id,
‘gril‘ AS sex,
0 AS isOk UNION ALL
SELECT
‘1011‘ AS id,
‘小子1130946325‘ AS name,
‘3‘ AS sch_id,
‘boy‘ AS sex,
1 AS isOk
) T ON T.[id]=S.[id]
Sql Server数据批量更新
标签:批量 sql log blog date server 数据 from select