执行一下SQL脚本
IF object_id('tempdb..#tempString1') is not null
Begin
DROP TABLE #tempString1;
END
--DROP TABLE tmpOrganization
SELECT Name INTO #tempString1 FROM SysObjects Where XType='U' ORDER BY Name
DECLARE @tableName1 varchar(50),@sql VARCHAR(500)
DECLARE My_Cursor1 CURSOR --定义游标
FOR (SELECT Name FROM #tempString1) --查出需要的集合放到游标中
OPEN My_Cursor1; --打开游标
FETCH NEXT FROM My_Cursor1 INTO @tableName1; --读取第一行数据
WHILE @@FETCH_STATUS = 0
BEGIN
SET @sql='CREATE VIEW [dbo].[v_'+@tableName1 +'] AS SELECT * FROM dbo.'+@tableName1 +' WITH (NOLOCK);';
PRINT @sql
EXEC (@sql)
FETCH NEXT FROM My_Cursor1 INTO @tableName1; --读取下一行数据
END
CLOSE My_Cursor1; --关闭游标
DEALLOCATE My_Cursor1; --释放游标