declare @dbname sysname,@sql nvarchar(4000),@re bit,@sql1 varchar(8000) set @sql1=' declare tb cursor for select name from master..sysdatabases open tb fetch next from tb into @dbname while @@fetch_status=0 begin set @sql='set @re=case when exists(select 1 from [' +@dbname+']..sysobjects where xtype='U' and name='' +@tbname+'') then 1 else 0 end' exec sp_executesql @sql,N'@re bit out',@re out if @re=1 set @sql1=@sql1+' union all select ''+@dbname+'' fetch next from tb into @dbname end close tb deallocate tb set @sql1=substring(@sql1,12,8000) exec(@sql1)
注：本站部分文章源于互联网，版权归原作者所有！如有侵权，请原作者与本站联系，本站将立即删除！ 本站文章除特别注明外均可转载，但需注明出处！ [MinTao学以致用网] 
