主页
基础类
应用实例
新技术前沿

数据库表是每天一个，汇总一周数据的问题

zhujinqiang 2007-12-12 09:24:37

一周有7天，我现在是分7次select
把结果insert到中间表保存。

有没有更简便的方法？

...全文

7 条回复

切换为时间正序

请发表友善的回复…

发表回复

yinqi025 2008-01-12

为什么不
insert into 中间表
select * from t1 where 时间in七天内？

回复赞

duanzhi1984 2008-01-11

如果要把表插入到另外的一个数据表，则

insert into 中间表
select * from t1
union all
select * from t2
union all
select * from t3
union all
select * from t4
union all
select * from t5
union all
select * from t6
union all
select * from t7

回复赞

duanzhi1984 2008-01-11

create view TotalTable
as

select * from t1
union all
select * from t2
union all
select * from t3
union all
select * from t4
union all
select * from t5
union all
select * from t6
union all
select * from t7

GO

这七个表的结构必须一致。

以后就直接访问视图TotalTable
就可以了

回复赞

zhujinqiang 2008-01-11

创建视图怎木写？

回复赞

晓风残月0110 2007-12-12

创建视图也可以

回复赞

dawugui 2007-12-12

select * into 中间表 from

(

  select * from t1

  union all

  select * from t2

  union all

  select * from t3

  union all

  select * from t4

  union all

  select * from t5

  union all

  select * from t6

  union all

  select * from t7

) t

回复赞

playwarcraft 2007-12-12

select * from t1
union all
select * from t2
union all
select * from t3
...

回复赞

发动态

发帖子

MS-SQL Server

创建于2007-09-28

加入

3.2w+

社区成员

25.3w+

社区内容

MS-SQL Server相关内容讨论专区

申请成为版主

社区公告

暂无公告