发布时间:2024-6-21
特价活动:>>>> 用友U8、T6、T+、T3软件产品4折优惠,畅捷通T+cloud、好会计、好业财、好生意云产品6-8折优惠,另有话费赠送。
问题回复:
1、在操作之前请先进行数据备份,以防数据出错后无法恢复!
2、在2020年执行脚本:(注意将UFDATA_002_2020修改为您的问题账套号即可。)
USE [UFDATA_002_2020] GO IF EXISTS (SELECT * FROM sys.indexes WHERE object_id = OBJECT_ID(N'[dbo].[WA_GZData]') AND name = N'aaaaaWA_GZData_PK') ALTER TABLE [dbo].[WA_GZData] DROP CONSTRAINT [aaaaaWA_GZData_PK] GO USE [UFDATA_902_2012] GO ALTER TABLE [dbo].[WA_GZData] ADD CONSTRAINT [aaaaaWA_GZData_PK] PRIMARY KEY NONCLUSTERED ( [cGZGradeNum] ASC, [cPsn_Num] ASC, [cPsn_Name] ASC, [iYear] ASC, [iMonth] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, SORT_IN_TEMPDB = OFF, IGNORE_DUP_KEY = OFF, ONLINE = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON) ON [PRIMARY] GO
截屏,微信识别二维码
客服QQ:5151867
(点击QQ号复制,添加好友)