时间: 2021-08-13 作者:daque
--查问指定的表在那些数据库中生存
declare @tbname sysnameset @tbname='存户材料'
declare @dbname sysname,@sql nvarchar(4000),@re bit,@sql1 varchar(8000)set @sql1=''declare tb cursor for select name from master..sysdatabasesopen tb fetch next from tb into @dbnamewhile @@fetch_status=0begin 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 @dbnameendclose tbdeallocate tbset @sql1=substring(@sql1,12,8000)exec(@sql1)