if(@NUM<7)
begin
set @NO=@num
--------这里从新修改---偏于精确到当前日期,在该周的百分比
select ID,Name,Model into Temp8 from @Duration
union all
select ID,Name,Model from @Duration
end
else
begin
select ID,Name,Model into #Temp8 from @Duration
where MfgWeek >=1 and MfgWeek<=@MfgWeek
end
select * from #Temp8
执行完后提示
(5295 行受影响)
消息 2714,级别 16,状态 6,第 62 行
There is already an object named 'Temp8' in the database.我是在sql 判断,
最终,我需要用到的,是Temp8表#Temp8 在其他处,还有用
set @tbname='t'
exec('select * from '+@tbname)
set @tbname='t'
exec('select * from '+@tbname)
在同一个程序的if else 之中,不能 into 到同一个临时表中去,你的程序要修改.
大大流氓出现 害我直接COPY错了
begin
set @NO=@num
--------这里从新修改---偏于精确到当前日期,在该周的百分比
INSERT INTO Temp8 --插入数据
select ID,Name,Model from @Duration
union all
select ID,Name,Model from @Duration
end
else
begin
INSERT INTO Temp8 --插入数据
select ID,Name,Model from @Duration
where MfgWeek >=1 and MfgWeek<=@MfgWeek
end
select * from #Temp8
begin
set @NO=@num
--------这里从新修改---偏于精确到当前日期,在该周的百分比
insert into #temp8 select ID,Name,Model from @Duration
union all
select ID,Name,Model from @Duration
end
else
begin
insert into #temp8 select ID,Name,Model into #Temp8 from @Duration
where MfgWeek >=1 and MfgWeek<=@MfgWeek
end
select * from #Temp8
declare @tbname varchar(50)
set @tbname='t'
exec('insert #Temp8 select ID,Name,Model from '+@tbname)
select * from #Temp8
select ID,Name,Model into Temp8 from @Duration where 1=0
这个话的意思,是什么
@Duration 是我的另外一个表
我直接扫描了一下 没写,然后就COPY了