No DECLARE @ sqlnvarchar (300 )? DECLAREUpdateStatsForAllDBsCURSORREAD_ONLYFORselectnamefromsysdatabases? DECLARE @ namenvarchar (255) OPENUpdateStatsForAllDBs? FETCHNEXTFROMUpdateStatsForAllDBs
No DECLARE @ SQL nvarchar (300 )? DECLARE UpdateStatsForAllDBs CURSORREAD_ONLYFOR select name from sysdatabases? DECLARE @ name nvarchar (255) OPEN UpdateStatsForAllDBs? Fetch next from UpdateStatsForAllDBs
Update statistics of all database tables in an SQL Server instance
<无>
DECLARE @sql nvarchar(300)?DECLARE UpdateStatsForAllDBs CURSORREAD_ONLYFOR select name from sysdatabases?DECLARE @name nvarchar(255)OPEN UpdateStatsForAllDBs?FETCH NEXT FROM UpdateStatsForAllDBs INTO @nameWHILE (@@fetch_status <> -1)BEGINIF (@@fetch_status <> -2)BEGINSET @sql = N'EXEC ' + QUOTENAME(@name) + N'.sys.sp_updatestats'EXEC sp_executesql @sqlENDFETCH NEXT FROM UpdateStatsForAllDBs INTO @nameEND?CLOSE UpdateStatsForAllDBsDEALLOCATE UpdateStatsForAllDBsGO