set@column_name='BlackOutFromDate'--table name select@sql=@sql+'union all select '''+ name +''' as DB_Name ,object_name(object_id) as table_name from ['+ name +'].sys.columns where name = '''+@column_name+''''
from sys.sysdatabases where sid <>0x01and version <>0;
set@sql=right(@sql,len(@sql)-9);
exec(@sql);
posted on
2008-11-28 10:21vitamin
阅读(129)
评论(0)
编辑收藏举报