insert into A values(1,2,3,4,5,6,7,8)
insert into A values(2,2,3,4,5,6,7,8)
insert into A values(3,2,3,4,5,6,7,8)
insert into A values(4,2,3,4,5,6,7,8)
insert into A values(5,2,3,4,5,6,7,8)
insert into A values(6,2,3,4,5,6,7,8)1-8的数字没有任何意义,只是指代数据。不过每条的VALUES的值是不一样。
以上6句SQL能不能够用一句SQL完成。
insert into A values(2,2,3,4,5,6,7,8)
insert into A values(3,2,3,4,5,6,7,8)
insert into A values(4,2,3,4,5,6,7,8)
insert into A values(5,2,3,4,5,6,7,8)
insert into A values(6,2,3,4,5,6,7,8)1-8的数字没有任何意义,只是指代数据。不过每条的VALUES的值是不一样。
以上6句SQL能不能够用一句SQL完成。
select 1,2,3,4,5,6,7,8
union all
select 2,2,3,4,5,6,7,8....
SELECT 1,2,3,4,5,6,7,8 UNION ALL
SELECT 2,2,3,4,5,6,7,8
..........
select 1,2,3,4,5,6,7,8
union all
select 2,2,3,4,5,6,7,8
union all
select 2,2,3,4,5,6,7,8
create table A(id int identity(1,1),n1 int,n2 int )
go
insert into A values(2,3)
go 5select * from A
/*
id n1 n2
----------- ----------- -----------
1 2 3
2 2 3
3 2 3
4 2 3
5 2 3(5 行受影响)
*/
drop table a??
insert into A values(2,2,3,4,5,6,7,8)
insert into A values(3,2,3,4,5,6,7,8)
insert into A values(4,2,3,4,5,6,7,8)
insert into A values(5,2,3,4,5,6,7,8)
insert into A values(6,2,3,4,5,6,7,8) 哈哈 广播体操