在SQL SERVER里面怎么用命令查包含某字段的表

use UFDATA_999_2008
select [name] from sysobjects where [id] in (select[id] from syscolumns where [name] = '某字段')

/* 以下代码SQL 2000及以上版本适用 */
--借助临时表生成一个从0起始的1000连续数据的序列
declare @dtlst table (id int identity(0,1), dt datetime)
insert into @dtlst
select top 1000 null as dt from sysobjects a,syscolumns b
-- 数据的日期范围
declare @dtbgn datetime, @dtend datetime
select @dtbgn = min(rq), @dtend = max(rq) from tb
-- 全部的日期列表
update @dtlst set dt = @dtbgn + id
delete @dtlst where dt > @dtend
-- 列出遗漏的日期
select dt from @dtlst a where not exists (select 1 from tb where tb.rq = a.dt)