declare @day as varchar(8) set @day = convert(varchar(8),getdate(),112) declare @sql as varchar(100) set @sql = 'select * into a' + @day + ' from a' exec(@sql)
dawugui(潇洒老乌龟) 乌龟大哥的是把表和数据都复制过去了。如果只拷贝表结构 declare @day as varchar(8) set @day = convert(varchar(8),getdate(),112) declare @sql as varchar(100) set @sql = 'select * into a' + @day + ' from a where 1<>1' exec(@sql)或者: declare @day as varchar(8) set @day = convert(varchar(8),getdate(),112) declare @sql as varchar(100) set @sql = 'select top 0 * into a' + @day + ' from a' exec(@sql)
来个简单的。create table tab_a as select * from tab_b where 1=2 嘿嘿
declare @day as varchar(8) set @day = convert(varchar(8),getdate(),112) declare @sql as varchar(100) set @sql = 'select * into a' + @day + ' from a' exec(@sql)
我的目的是这样的.我每天要采集大量的数据放到数据库中而且可能需要长期的保存,比如可以查看过去一个月当中情况,不知道应该怎么设计数据库的结构比较好呢? 因为我现在用odbc连接sql server 但是当某个表中数据大到一定程度的时候会大大降低打开,查询的速度,不知道怎么设计比较好
set @day = convert(varchar(8),getdate(),112)
declare @sql as varchar(100)
set @sql = 'select * into a' + @day + ' from a'
exec(@sql)
乌龟大哥的是把表和数据都复制过去了。如果只拷贝表结构
declare @day as varchar(8)
set @day = convert(varchar(8),getdate(),112)
declare @sql as varchar(100)
set @sql = 'select * into a' + @day + ' from a where 1<>1'
exec(@sql)或者:
declare @day as varchar(8)
set @day = convert(varchar(8),getdate(),112)
declare @sql as varchar(100)
set @sql = 'select top 0 * into a' + @day + ' from a'
exec(@sql)
select * from tab_b where 1=2
嘿嘿
set @day = convert(varchar(8),getdate(),112)
declare @sql as varchar(100)
set @sql = 'select * into a' + @day + ' from a'
exec(@sql)
因为我现在用odbc连接sql server 但是当某个表中数据大到一定程度的时候会大大降低打开,查询的速度,不知道怎么设计比较好