执行查询出错,修复语句

exec sp_dboption 'ufdy2012zx','single user','true' 

declare @tabname varchar(50)

set @tabname='YearPeriod'
  
DBCC CHECKTABLE (@tabname,REPAIR_FAST)

DBCC CHECKTABLE (@tabname,repair_rebuild)  

DBCC CHECKTABLE (@tabname,REPAIR_ALLOW_DATA_LOSS)---这条语句执行后会导致数据丢失,其余方法都不好使的情况下才考虑h

exec sp_dboption 'ufdy2012zx','single user','false'

--s-elect * from  masterbill

--select * from ProductInOut