SqlServer使用insert into一次插入多笔数据

INSERT INTO AOI_DEVICE_PRODUCT_CATEGORY(DEVICE_PRODUCT_CATEGORY_SID,DEVICE,MAKTX,PRODUCT_TYPE,UPDATETIME)
VALUES 
('A2021122111103739456','341904000058','H 100G LR4 TOSA Assembly-M','100G LR4','2021-12-21 11:16:29.310'),
('A2021122111154790128','300101001277','400G DR4-Siph with 0.3SM COS1','400G DR4-Siph F','2021-12-21 11:16:29.310'),
('A2021122111165200760','300101001276','400G DR4-Siph with 0.3SM COS2','400G DR4-Siph L','2021-12-21 11:16:29.310'),
('A2021122111175710549','341111000226 ','400G DR4-Siph-Sub-assembly_2','400G DR4-Siph','2021-12-21 11:16:29.310')

 

上一篇:union all和union的区别


下一篇:Machine Learning in Action 读书笔记---第2章 k-近邻算法