2013年3月26日
刷新SQLserver 视图
摘要： View Code CREATE PROCEDURE RefreshAllView ASDECLARE MyCursor CURSORFOR select Name from dbo.sysobjects where OBJECTPROPERTY(id, N'IsView') = 1 and (not name in ('sysconstraints','syssegments'))DECLARE @name varchar(40)OPEN MyCursorFETCH NEXT FROM MyCursor INTO @nameWHILE (@@f 阅读全文
posted @ 2013-03-26 10:01 IT-民工 阅读(192) 评论(0) 推荐(0)