关于数据添加问题
insert into TableName(A,B,C,D,E)
select * from (select '1' a,'2' b,'3' c,'3' d,'4' e
union select '2','2','3','3','4'
union select '3','2','3','3','4'
union select '4','2','3','3','4'
union select '5','2','3','3','4') f
insert into TableName(A,B,C,D,E)
select '1' a,'2' b,'3' c,'3' d,'4' e
union select '2','2','3','3','4'
union select '3','2','3','3','4'
union select '4','2','3','3','4'
union select '5','2','3','3','4'
这两插入的效率是一样的吗?
还有就是sql server 添加数据一条语句插入多少行比较合适?