12 lines
232 B
Transact-SQL
12 lines
232 B
Transact-SQL
--Migration
|
|
DECLARE @sql nvarchar(max) = ''
|
|
|
|
SELECT @sql += 'EXEC sp_refreshview ''dbo.' + [name] + '''' + char(13) + char(10)
|
|
FROM sys.views
|
|
WHERE schema_id = 1 /*dbo*/
|
|
AND [name] like '%_OSSZES'
|
|
|
|
EXEC sp_executesql @sql
|
|
GO
|
|
|