DECLARE UpdateStatisticsTables CURSOR READ_ONLY FOR |
03 | Schema_name(sst.schema_id) |
06 | DECLARE @ name VARCHAR (80), |
09 | OPEN UpdateStatisticsTables |
11 | FETCH NEXT FROM UpdateStatisticsTables INTO @ name , @ schema |
13 | WHILE ( @@FETCH_STATUS <> -1 ) |
15 | IF ( @@FETCH_STATUS <> -2 ) |
17 | DECLARE @sql NVARCHAR(1024) |
18 | SET @sql= 'UPDATE STATISTICS ' + Quotename(@ schema ) |
20 | '.' + Quotename(@ name ) |
21 | EXEC Sp_executesql @sql |
24 | FETCH NEXT FROM UpdateStatisticsTables INTO @ name , @ schema |
27 | CLOSE UpdateStatisticsTables |
29 | DEALLOCATE UpdateStatisticsTables |
转载于:https://www.cnblogs.com/kevinGao/p/3175981.html