T+13.0 数据库损坏，升级失败

数据库损坏，升级失败。

问题回复：

备份账套，执行以下语句，再升级账套！ 

insert into AA_BusiType(code,name,disabled,issystem) values('GL1001','销项税发票',0,1) insert into AA_BusiType(code,name,disabled,issystem) values('GL1002','进项税发票',0,1) select * into a from AA_BusiType drop table AA_BusiType CREATE TABLE [dbo].[AA_BusiType]( [code] [nvarchar](32) NULL, [name] [nvarchar](200) NULL, [disabled] [tinyint] NULL, [ts] [timestamp] NULL, [updatedBy] [nvarchar](32) NULL, [isSystem] [tinyint] NULL, [ExpressionName] [nvarchar](60) NULL, [id] [int] IDENTITY(1,1) NOT NULL, [idrdStyleIn] [int] NULL, [idrdStyleOut] [int] NULL, [businessVoucher] [int] NULL, [madeDate] [datetime] NULL, [updated] [datetime] NULL, [createdTime] [datetime] NULL ) ON [PRIMARY] insert into[AA_BusiType]( [code], [name], [disabled], [updatedBy], [isSystem], [ExpressionName], [idrdStyleIn], [idrdStyleOut], [businessVoucher], [madeDate], [updated], [createdTime] ) select [code], [name], [disabled], [updatedBy], [isSystem], [ExpressionName], [idrdStyleIn], [idrdStyleOut], [businessVoucher], [madeDate], [updated], [createdTime] from a CREATE CLUSTERED INDEX [i_AA_BusiType_cluster] ON [dbo].[AA_BusiType] ( [code] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY] GO CREATE NONCLUSTERED INDEX [IDX_AA_BusiType_idrdstylein] ON [dbo].[AA_BusiType] ( [idrdStyleIn] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY] GO CREATE NONCLUSTERED INDEX [IDX_AA_BusiType_idrdstyleout] ON [dbo].[AA_BusiType] ( [idrdStyleOut] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY] GO CREATE NONCLUSTERED INDEX [ix_AA_BusiType_2] ON [dbo].[AA_BusiType] ( [name] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY] GO CREATE UNIQUE NONCLUSTERED INDEX [ix_AA_BusiType_ID] ON [dbo].[AA_BusiType] ( [id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, DROP_EXISTING = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, FILLFACTOR = 90) ON [PRIMARY] GO drop table a