更新sqlserver实例中所有数据库表的统计信息 无 declare @sql nvarchar(300)?declare updatestatsforalldbs cursorread_onlyfor select name from sysdatabases?declare @name nvarchar(255)open updatestatsforalldbs?fetch next from updatestatsforalldbs
更新sql server实例中所有数据库表的统计信息 
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)begin if (@@fetch_status -2) begin set @sql = n'exec ' + quotename(@name) + n'.sys.sp_updatestats' exec sp_executesql @sql end fetch next from updatestatsforalldbs into @nameend?close updatestatsforalldbsdeallocate updatestatsforalldbsgo