巴布鱼——软件工程师的家园

标题: 刷新数据库中所有视图 [打印本页]
作者: 笒羽    时间: 2016-5-18 20:18
标题: 刷新数据库中所有视图
  1. CREATE PROCEDURE RefreshAllView AS
  2. DECLARE MyCursor CURSOR
  3. FOR select Name from dbo.sysobjects where OBJECTPROPERTY(id, N'IsView') = 1 and (not name in ('sysconstraints','syssegments'))

  5. DECLARE @name varchar(40)
  6. OPEN MyCursor

  8. FETCH NEXT FROM MyCursor INTO @name
  9. WHILE (@@fetch_status <> -1)
  10. BEGIN
  11. IF (@@fetch_status <> -2)
  12. begin
  13. exec sp_refreshview @name
  14. end
  15. FETCH NEXT FROM MyCursor INTO @name
  16. END

  18. CLOSE MyCursor
  19. DEALLOCATE MyCursor
复制代码






欢迎光临 巴布鱼——软件工程师的家园 (http://bbs.babuyu.com/) Powered by Discuz! X3.2