SQLSERVER 过滤所有权的代码

--数据库的名字，建议加上[]做名字包含USE [0379]

DECLARE tnames_cursor CURSORFOR   SELECT TABLE_NAME    FROM INFORMATION_SCHEMA.TABLESOPEN tnames_cursorDECLARE @tablename sysname

--SET @tablename = 'authors'FETCH NEXT FROM tnames_cursor INTO @tablename

WHILE (@@FETCH_STATUS <> -1)BEGIN   IF (@@FETCH_STATUS <> -2)   BEGIN    --'源对象名称.'      SELECT @tablename = '0379_f.'+RTRIM(@tablename)      -- EXEC ('SELECT '''+'0379_f.' +@tablename + ''' = count(*) FROM '  + @tablename )     -- PRINT ' 'exec sp_changeobjectowner  @tablename ,'dbo'print ' '+@tablename   END   FETCH NEXT FROM tnames_cursor INTO @tablenameENDCLOSE tnames_cursorDEALLOCATE tnames_cursor

转载于:https://www.cnblogs.com/Mygirl/archive/2011/10/11/2206796.html

相关资源：JAVA上百实例源码以及开源项目