--云星空重建索引SQLDECLARE@sqlNVARCHAR(1000)='DBCCDBREINDEX(@TABLE_NAME)WITHNO_INFOMSGS';DECLARE@tblNVARCHAR(1000)=''DECLAREtblcurCURSORFORSELECT[NAME]FROMsys.tablesWHERE[NAME]NOTLIKE'TMP%'AND[NAME]NOTLIKE'Z[_]%'ORDERBY1FORREADONLYOPENtblcurFETCHNEXTFROMtblcurINTO@tblWHILE@@FETCH_STATUS=0BEGI...

时间:2024-09-24 03:55栏目:K3 Cloud