批量更新SQL Server数据库的用户视图

DECLARE @vName sysname

DECLARE refresh_cursor CURSOR FOR
Select Name from sysobjects Where xtype = 'V' order by crdate
FOR READ ONLY  
OPEN refresh_cursor

FETCH NEXT FROM refresh_cursor
INTO @vName
WHILE @@FETCH_STATUS = 0
BEGIN
  exec sp_refreshview @vName
  PRINT '视图' + @vName + '已更新'
  FETCH NEXT FROM refresh_cursor
     INTO @vName
END
CLOSE refresh_cursor
DEALLOCATE refresh_cursor

上一篇: MSDB 质疑 的恢复与MSDB文件过大的清理
下一篇: Perl/CGI的模块升级方法
文章来自: 本站原创
引用通告: 查看所有引用 | 我要引用此文章
Tags:
相关日志: