【问】分店数据下传到会员信息报错? | ||
【适用版本】烘焙之星8 | 【模块】基础业务 | 【点击数】111 |
【知识编号】Z2012121700076 | ||
【问题描述】 |
use issbakev7_branch
go
if exists (select * from dbo.sysindexes where name = N’i_rm_vip_info’ and id = object_id(N'[dbo].[t_rm_vip_info]’))
drop index [dbo].[t_rm_vip_info].[i_rm_vip_info]
GO
CREATE INDEX [i_rm_vip_info] ON [dbo].[t_rm_vip_info]([vip_name]) ON [PRIMARY]
GOif exists (select * from dbo.sysindexes where name = N’i_rm_vip_info_2′ and id = object_id(N'[dbo].[t_rm_vip_info]’))
drop index [dbo].[t_rm_vip_info].[i_rm_vip_info_2]
GO
CREATE INDEX [i_rm_vip_info_2] ON [dbo].[t_rm_vip_info]([social_id]) ON [PRIMARY]
GO2、如果以上方法仍然不行,请检测数据库是否损坏。