insert into students([name],number,phone)
select 'zhangsan','1001','11' union
select 'lisi','1002','22' union
select 'wangwu','1003','33' ;
sql server 一次插入多条数据(2005版本的数据库)
最新推荐文章于 2024-02-24 00:39:22 发布
insert into students([name],number,phone)
select 'zhangsan','1001','11' union
select 'lisi','1002','22' union
select 'wangwu','1003','33' ;