说说数据复制USE [NEWNEW] DECLARE @name SYSNAME DECLARE userDB CURSORFORselectnamefrom master.dbo.sysdatabases WHERE SID <> 0x01 OPEN userDB FETCHNEXTFROM userDB INTO @name WHILE (@@FETCH_STATUS = 0) BEGIN EXEC(use [ + @name + ] IF (EXISTS(SELECT 1 FROM dbo.sysobjects o WHERE o.NAME = Customer AND o.xtype = U)) BEGIN PRINT + @name + END) FETCHNEXTFROM userDB INTO @name END CLOSE userDB DEALLOCATE userDB 1.2.3.4.5.6.7.8.9.10.11.12.