问题现象: | |
问题原因: | |
解决方案: | 您好! 1、合肥通用 步骤一: ALTER TABLE [dbo].[Rpt_FltDEF] ADD CONSTRAINT [DF__rpt_fltde__iPage__0EB9D630] DEFAULT ((0)) FOR [iPage] GO 步骤二: BEGIN TRANSACTION SET QUOTED_IDENTIFIER ON SET ARITHABORT ON SET NUMERIC_ROUNDABORT OFF SET CONCAT_NULL_YIELDS_NULL ON SET ANSI_NULLS ON SET ANSI_PADDING ON SET ANSI_WARNINGS ON COMMIT BEGIN TRANSACTION GO CREATE TABLE dbo.Tmp_Rpt_FldDEF ( id_field int NOT NULL IDENTITY (1, 1), ID int NULL, Name varchar(255) NULL, Expression varchar(255) NULL, Condition varchar(255) NULL, ModeEx int NULL, OrderEx int NULL, TopEx int NULL, LeftEx int NULL, Width int NULL, Height int NULL, Visible int NULL, Note varchar(32) NULL, nameForeign varchar(255) NULL, iColSize int NULL, FormatEx varchar(20) NULL, iAlignStyle int NULL, iSize int NULL ) ON [PRIMARY] GO SET IDENTITY_INSERT dbo.Tmp_Rpt_FldDEF ON GO IF EXISTS(SELECT * FROM dbo.Rpt_FldDEF) EXEC('INSERT INTO dbo.Tmp_Rpt_FldDEF (id_field, ID, Name, Expression, Condition, ModeEx, OrderEx, TopEx, LeftEx, Width, Height, Visible, Note, nameForeign, iColSize, FormatEx, iAlignStyle, iSize) SELECT id_field, ID, Name, Expression, Condition, ModeEx, OrderEx, TopEx, LeftEx, Width, Height, Visible, Note, nameForeign, iColSize, FormatEx, iAlignStyle, iSize FROM dbo.Rpt_FldDEF WITH (HOLDLOCK TABLOCKX)') GO SET IDENTITY_INSERT dbo.Tmp_Rpt_FldDEF OFF GO DROP TABLE dbo.Rpt_FldDEF GO EXECUTE sp_rename N'dbo.Tmp_Rpt_FldDEF', N'Rpt_FldDEF', 'OBJECT' GO COMMIT 1、苏州华越 步骤一:执行网站问题附件中的脚本NB_Sql.sql 步骤二:再执行如下脚本: If not COLUMNPROPERTY(OBJECT_ID('NB_UserAuthority'),'cUserId','PRECISION') IS NULL ALTER TABLE NB_UserAuthority ALTER COLUMN cUserId varchar(20) NOT NULL 如有问题,请及时反馈! U8/CRM/PLM |
相关补丁: | |
版本: | 8.90 |
模块: | 系统管理 |
产品: | 公共平台 |
问题名称: | 数据无法升级 |
最后更新: | 2012-02-27 23:24:04 |