DECLARE@DBCCStringNVARCHAR(1000)DECLARE@TableNameVARCHAR(100)DECLARECur_IndexCURSORFORSELECTNameASTblNameFROMsysobjectsWHERExType=UORDERBYTblNameFORREADONLYOPENCur_IndexFETCHNEXTFROMCur_IndexINTO@TableNameWHILE@@FETCH_STATUS=0BEGINPRINT重建表+@TableName+的索引........Start!SET@DBCCString=DBCCDBREINDEX(@TblName,)WITHNO_INFOMSGSEXECSP_EXECUTESQL@DBCCString,N@TblNameVARCHAR(100),@TableNamePRINT重建表+@TableName+的索引........END!FETCHNEXTFROMCur_IndexINTO@TableNameEND