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')

 

posted on 2021-12-21 11:22  写个笔记  阅读(595)  评论(0编辑  收藏  举报

导航