34,590
社区成员
发帖
与我相关
我的任务
分享请发表友善的回复…
发表回复
BEN_717_GG 2006-12-17
- 打赏
- 举报
delete from data_all
declare @sqlcmd varchar(8000)
set @sqlcmd=''
select @sqlcmd=@sqlcmd + 'insert into [data_all] select * from [' + name + '];' from sysobjects where xtype='u' and name<>'data_all' and name<>'dtproperties'
exec (@sqlcmd)
declare @sqlcmd varchar(8000)
set @sqlcmd=''
select @sqlcmd=@sqlcmd + 'insert into [data_all] select * from [' + name + '];' from sysobjects where xtype='u' and name<>'data_all' and name<>'dtproperties'
exec (@sqlcmd)
marco08 2006-12-17
- 打赏
- 举报
请楼主把方法贴出来，好让我学习一下
babywywy 2006-12-17
- 打赏
- 举报
再复杂的情况就不好说了，比如存储过程中有case when和动态列表，再用union就不好连接了！
studenthj 2006-12-17
- 打赏
- 举报
学习
中国风 2006-12-17
- 打赏
- 举报
select * from table1
union all
select * from table2
union all
.............
union all
select * from table2
union all
.............
yesyesyes 2006-12-17
- 打赏
- 举报
union all
BEN_717_GG 2006-12-16
- 打赏
- 举报
结贴，谢谢参与，以找到方法
jackydeng 2006-12-16
- 打赏
- 举报
select ..into
