查询指定的表在那些数据库中存在

2024-07-21 02:11:16

字体：大中小

来源：转载

供稿：网友

本文来源于网页设计爱好者web开发社区http://www.html.org.cn收集整理，欢迎访问。

--查询指定的表在那些数据库中存在

declare @tbname sysname
set @tbname='客户资料'

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 ['
[email protected]+']..sysobjects where xtype=''u'' and name='''
[email protected]+''') then 1 else 0 end'
exec sp_executesql @sql,n'@re bit out',@re out
if @re=1 set @[email protected]+' union all select '''[email protected]+''''
fetch next from tb into @dbname
end
close tb
deallocate tb
set @sql1=substring(@sql1,12,8000)
exec(@sql1)

上一篇：EAServer 新手上路----JaguarCts开发者必读

下一篇：PowerDesigner脚本：设置实体快捷方式的颜色