如题请高手指点 附升级日志:
w(y#{!%+ 其中 wbs_fullcode 是什么?因该是列名吧?
W/U_:^[- @@@@@@@@@@@@@@@@@@@@@@@
r%QnV0L^ CREATE procedure KB_Tur_equipment(@project_names varchar(8000))
@_O,0d
g AS
vE9M2[TJA frYPC
Irj declare @epstype varchar(50)
0Q
]p#; declare @projectid varchar(30)
WLb*\ declare @sql varchar(8000)
>-~2:d\M3 if object_id('tempdb.dbo.#t') is not null
`F#<qZSR drop table #t
%/^kr ZD create table #t( seq int IDENTITY (1, 1) NOT NULL,equiparea varchar(100) null ,equipcode varchar(100),equipname VARCHAR(100),wbs_fullcode varchar(150) )
E
rf$WPA set @sql = ' alter table #t add '
~+y0UEtq7 declare cur_ cursor for select epstype,project_id from rec_querylink where funcname like '汽管相关设备工程量%'
R/yOy^< open cur_
Tz=YSQy$9 fetch cur_ into @epstype,@projectid
*L%i-Wg" while @@fetch_status = 0
.Y.{j4[LQ begin
O$> <E8q set @sql = @sql + ' ['+@epstype + '] float null,'
i>Cxi ZT ~N i#xa fetch cur_ into @epstype,@projectid
-V'`;zE6 end
u#+p6%?k close cur_
KAR XC,z deallocate cur_
5 i1T? set @sql = substring(@sql,1,len(@sql)-1)
JJvf!] print (@sql)
0I.9m[<Fc if right(@sql,2)<>'ad'
bw@DcT&, exec (@sql)
~IHjj1s set @sql = ' alter table #t add 总重 float '
,_66U;T --exec (@sql)
ZKGS?z insert #t(equiparea,equipcode,equipname,wbs_fullcode)
2p( M`@ select distinct equiparea,equipcode,equipname,wbs_fullcode from view_tur_sum_equip
q\q V~G` 6~b~[gA declare cur_ cursor for select epstype,project_id from rec_querylink where funcname like '汽管相关设备工程量%'
26fm}QV open cur_
7'[C+/: fetch cur_ into @epstype,@projectid
0Fw0#eE while @@fetch_status = 0
Mk=;UBb$X begin
wHW";3w2~ set @sql = 'update #t set ['+@epstype+']=isnull(['+@epstype+'],0)+a.num from (select project_id, equiparea,equipcode,equipname,wbs_fullcode,sum(isnull(weight,0)) as num '
\?,'i/c- set @sql = @sql + ' from view_tur_sum_equip '
9Z0(e!b4S set @sql = @sql + ' where
project_id='''+@projectid+''' group by project_id, equiparea,equipcode,equipname,wbs_fullcode ) a '
eSynw$F2N +' where #t.equiparea=a.equiparea and #t.equipcode=a.equipcode and #t.equipname=a.equipname and #t.wbs_fullcode=a.wbs_fullcode '
(/&IBd- exec (@sql)
'676\2. fetch cur_ into @epstype,@projectid
j+3~ end
QZBXI3%#s close cur_
oZ1#.o{ deallocate cur_
9.|+KIRb select * from #t
NyD[9R? 错误信息:
7N^9D
H{` 列名 'wbs_fullcode' 无效。
XD`QU m h<.G^c) 升级失败,还原老版本的数据库成功!2009-1-4 18:59:05
8T'=lTJ