我的库里有15个表,table1,table2,......table15,每个表的字段都是一样的,只是内容不同,我怎样通过SQL语句将其合并到一个表单table中呢。
table1
code name id zj
000001 zj 111110 100.00
000002 mw 111111 200.00table2
code name id zj
000234 wxg 222222 690.00
222444 zlg 234780 3400.00................table15
code name id zj
111234 ert 345689 450.00
123234 uie 234672 340.00希望得到下面的结果
table
code name id zj
000001 zj 111110 100.00
000002 mw 111111 200.00
000234 wxg 222222 690.00
222444 zlg 234780 3400.00
....................................
111234 ert 345689 450.00
123234 uie 234672 340.00谢谢。
table1
code name id zj
000001 zj 111110 100.00
000002 mw 111111 200.00table2
code name id zj
000234 wxg 222222 690.00
222444 zlg 234780 3400.00................table15
code name id zj
111234 ert 345689 450.00
123234 uie 234672 340.00希望得到下面的结果
table
code name id zj
000001 zj 111110 100.00
000002 mw 111111 200.00
000234 wxg 222222 690.00
222444 zlg 234780 3400.00
....................................
111234 ert 345689 450.00
123234 uie 234672 340.00谢谢。
解决方案 »
- 问一个关于数据库名的问题
- 高手帮我看看这条语句错在哪里?
- 我想对3个表的内容进行联合查询 请问怎么办?
- 各位老大,请帮忙看看,一个很容易的问题,关于asp调用sql存储过程的返回值。
- 在c语言中查询sqlite数据库,不支持%_通配符查询。
- 怪现象:com.microsoft.sqlserver.jdbc.SQLServerException: 用户 'sa' 登录失败。
- 邹建请进!!
- 求助??我的数据库很大,达到2G
- sql server2000中是否有级联删除功能,若有,如下写为何不对?
- 有时间的朋友就来看看,太难了,不要耽误大家的时间了。
- web服务器访问sqlserver2008数据库服务器需要开启哪些端口?
- 如何将表里面的数按照排列组合取出来????????????????????????????????????????????
UNION ALL
SELECT * FROM tb2
UNION ALL
SELECT * FROM tb3
...
...
UNION ALL
SELECT * FROM tb15
SELECT * FROM tb1
UNION ALL
SELECT * FROM tb2
UNION ALL
SELECT * FROM tb3
...
...
UNION ALL
SELECT * FROM tb15
union all
select * from table2
union all
select * from table3
....
@command=N'
INSERT tb
SELECT *
FROM [?]
'
@whereand=N' and o.name LIKE N''tb%'''
@command=N'
IF OBJECT_ID(N''tb'') IS NULL
SELECT * INTO tb FROM [?]
ELSE
INSERT tb SELECT * FROM [?]
'
@whereand=N' and o.name LIKE N''tb%'''
select * into [Table] from table2;
......
select * into [Table] from t1
union all
select * from t2
union all
select * from t3
...
...
union all
select * from t15
SELECT * FROM tb1
UNION ALL
SELECT * FROM tb2
UNION ALL
SELECT * FROM tb3
...
...
UNION ALL
SELECT * FROM tb15重复记录会只留一条INSERT tb
SELECT * FROM tb1
UNION
SELECT * FROM tb2
UNION
SELECT * FROM tb3
...
...
UNION
SELECT * FROM tb15
INSERT tb
SELECT * FROM tb1
UNION ALL
SELECT * FROM tb2
UNION ALL
SELECT * FROM tb3
...
...
UNION ALL
SELECT * FROM tb15重复记录会只留一条 SQL code
INSERT tb
SELECT * FROM tb1
UNION
SELECT * FROM tb2
UNION
SELECT * FROM tb3
...
...
UNION
SELECT * FROM tb15
insert into [table]
select * from [table1]
union all
select * from [table2]
union all
select * from [table3]
union all
select * from [table4]
union all
select * from [table5]
union all
select * from [table6]
union all
select * from [table7]
union all
select * from [table8]
union all
select * from [table9]
union all
select * from [table10]
union all
select * from [table11]
union all
select * from [table12]
union all
select * from [table13]
union all
select * from [table14]
union all
select * from [table15]
declare @sql nvarchar(max),@i int
set @sql = 'insert [table] select * from [table1] '
set @i = 1
while @i < 15
begin
set @i = @i + 1
set @sql = @sql + ' union all select * from [table'+cast(@i as nvarchar(2))+'] '
end
exec(@sql)