SqlServer2008R2 如何插入多条数据

列id 为自增列

insert into Websites2
values('Google','https://www.google.cm/','USA',1),
('淘宝','https://www.taobao.com/','CN',13),
('菜鸟教程','http://www.runoob.com/','CN',4689),
('微博','http://weibo.com/','CN',20),
('Facebook','https://www.facebook.com/','USA',3)

 

posted @ 2016-10-25 18:58  婧児  Views(608)  Comments(0Edit  收藏  举报