sqlserver刷新视图,
sqlserver用于刷新视图的存储过程
create procedure dbo.proc_refreshview as begin declare @viewname varchar(100) declare cur_view cursor for select [name] from sysobjects where [type]='V' open cur_view fetch next from cur_view into @viewname while(@@FETCH_STATUS=0) begin exec sp_refreshview @viewname fetch next from cur_view into @viewname end close cur_view deallocate cur_view end
本站文章为和通数据库网友分享或者投稿,欢迎任何形式的转载,但请务必注明出处.
同时文章内容如有侵犯了您的权益,请联系QQ:970679559,我们会在尽快处理。