create proc 刷新视图
as
declare @name nvarchar(max)
DECLARE vcursor CURSOR FOR
SELECT name from sys.views order by create_date asc
OPEN vcursor
FETCH NEXT FROM vcursor INTO @name
WHILE @@FETCH_STATUS = 0
BEGIN
begin try
exec sp_refreshview @name
end try
begin catch
print '视图:'+@name;
throw
end catch
FETCH NEXT FROM vcursor INTO @name
END
CLOSE vcursor
DEALLOCATE vcursor