如何查找数据库中某一字段值？并显示其所在的表名

[lostwaterfish]

如题！！

[lostwaterfish]

忘记补充了，是在MS SQLSERVER2000中！

[九斤半]

[ZT]查找数据库中包含某一字符的表(遍历表和字段)

DECLARE @table_name varchar(200),@col_name varchar(200)

declare tutest_1 cursor for

select a.name, c.name from sysobjects a
join sysindexes b on a.id=b.id
right join syscolumns c on c.id=b.id
--求字段的类型
join systypes d on d.xusertype=c.xusertype
where b.indid in (0,1)
and a.xtype='U'
and b.rows>100
and d.name like'%char%'


OPEN tutest_1

FETCH NEXT FROM tutest_1
INTO @table_name, @col_name

WHILE @@FETCH_STATUS = 0
begin
declare @sql varchar(8000)

set @sql=''


set @sql=+@sql+ 'select * from '+@table_name +' where '+ @col_name +' = ''kkkkkk'''

--exec(@sql)
-- 也可以把语句打出来
if @@rowcount>0
print(@sql)


FETCH NEXT FROM tutest_1 INTO @table_name, @col_name
end
CLOSE tutest_1
DEALLOCATE tutest_1

[lostwaterfish]

能描述下，如何查找么？ 我是新手，谢谢！！

[九斤半]

你在查询分析器里运行一下看看就知道了，

这段是查找包含字符串'kkkkkk'

[lostwaterfish]

我做过替换了，之后出现：
select * from SYS_PRIV_ALLOC where EFF_ALL = '长裤'
select * from SYS_PRIV_ALLOC where ROLE_ID = '长裤'
select * from SYS_PRIV_ALLOC where PRIV_ID = '长裤'
select * from SYS_PRSNL where PRSNL_NUM = '长裤'
select * from SYS_PRSNL where SURNAME = '长裤'
select * from SYS_PRSNL where GIVENNAME = '长裤'
select * from SYS_PRSNL where FULL_NAME = '长裤'
select * from SYS_PRSNL where INPUT_CODE = '长裤'
select * from SYS_PRSNL where GENDER = '长裤'
select * from SYS_PRSNL where ID_TYPE = '长裤'
select * from SYS_PRSNL where ID_NUM = '长裤'
select * from SYS_PRSNL where OFFICE_NUM = '长裤'


并无结果，万请赐教！！谢谢！

[lostwaterfish]

想知道为什么呢！！大家帮帮