问题现象: | 升级u861到u890,2008年度升级失败,提示:数据库名: UFDATA_181_2008 D:U8SOFTAdminSQLFILE8710MainUfdataStructureData_PRV_GL_mix_NL.sql 错误信息: -2147217900 第 4 行: 'max' 附近有语法错误。 执行如下语句时出错: CREATE PROC GL_P_AllItemName AS begin declare @mysql varchar(max) declare @cclass varchar(2) IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = OBJECT_ID(N'[dbo].[GL_AllItemName]') and objectproperty(id,N'IsView')=1) DROP VIEW [dbo].[GL_AllItemName] set @mysql='create view GL_AllItemName as select ''ch'' as citem_class,cInvCode as citemcode,cInvName as citemname from inventory ' declare rstTemp cursor forward_only for select citem_class from fitem where citem_class<>'ch' open rstTemp fetch next from rstTemp into @cclass while @@fetch_status=0 begin SET @mysql=@mysql+' union SELECT '''+@cclass+''' as citem_class,citemcode,citemname FROM fitemss'+@cclass fetch next from rstTemp into @cclass end close rstTemp deallocate rstTemp exec (@mysql) end 从升级成功账套生成GL_P_AllItemName脚本执行后再升级,还是提示这个错误。 |
问题原因: | |
解决方案: | 您好,此问题已出补丁解决,请使用补丁更新工具下载安装最新的系统管理补丁。 如有问题,请及时反馈! |
相关补丁: | |
版本: | 8.90 |
模块: | 系统管理 |
产品: | 公共平台 |
问题名称: | U861升级U890失败 |
最后更新: | 2011-06-22 23:20:27 |