use UFDATA_036_2018 DECLARE @TbName VARCHAR(80) DECLARE FindErrTable SCROLL CURSOR FOR select name from UFDATA_036_2018.dbo.sysobjects where xtype=''u'' order by name OPEN FindErrTable FETCH FindErrTable INTO @TbName WHILE @@FETCH_STATUS<>-1 BEGIN print @TbName exec( ''select top 1 * from '' + @TbName) FETCH FindErrTable INTO @TbName END PRINT ''Scan ComplateɨÃèÍê³É¡'' CLOSE FindErrTable DEALLOCATE FindErrTable
ÒÔÉÏΪ²é´í±í
¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª¡ª
USE UFDATA_036_2018 DECLARE @TableName varchar(255) DECLARE TableCursor CURSOR FOR
SELECT Table_Schema+''.''+Table_Name FROM information_schema.tables WHERE table_type = ''base table''
OPEN TableCursor
FETCH NEXT FROM TableCursor INTO @TableName
WHILE @@FETCH_STATUS = 0 BEGIN
DBCC DBREINDEX(@TableName,'' '',90)
FETCH NEXT FROM TableCursor INTO @TableName END
CLOSE TableCursor DEALLOCATE TableCursor |