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