利用跟踪.....如果“品海鲍鱼火锅”是数据库字段的话,则可以查询 select *from syscolumns where name='品海鲍鱼火锅'
select b.name from syscolumns a join sysobjects b on a.id=b.id where a.name='品海鲍鱼火锅'
1.找到存放这个标题的表 假如为 tb 2.找到存放标题的字段 假如为 title 3.请问是你要把所有的 为“品海鲍鱼火锅”都修改呢,还是只修改某一条 3. update tb set title='要修改的名称' where title='品海鲍鱼火锅' --全部修改 update tb set title='要修改的名称' where title='品海鲍鱼火锅' and id='' --修改一条
-- 只能构造语句遍历整个数据库declare @sql varchar(max); set @sql=''; select @sql=@sql+'if exists (select * from '+o.[name]+' where '+c.[name]+' like ''%品海鲍鱼火锅%'') select '''+o.[name]+''' tabname,'''+c.[name]+''' colname ; ' from sys.columns c join sys.objects o on c.[object_id]=o.[object_id] where (max_length>=4 or max_length=-1) and system_type_id in (35,99,168,175,231,239,241) and o.[type]='U'print @sql;
select *from syscolumns where name='品海鲍鱼火锅'
where a.name='品海鲍鱼火锅'
2.找到存放标题的字段 假如为 title
3.请问是你要把所有的 为“品海鲍鱼火锅”都修改呢,还是只修改某一条
3.
update tb set title='要修改的名称' where title='品海鲍鱼火锅' --全部修改
update tb set title='要修改的名称' where title='品海鲍鱼火锅' and id='' --修改一条
set @sql='';
select @sql=@sql+'if exists (select * from '+o.[name]+' where '+c.[name]+' like ''%品海鲍鱼火锅%'')
select '''+o.[name]+''' tabname,'''+c.[name]+''' colname ; '
from sys.columns c join sys.objects o on c.[object_id]=o.[object_id]
where (max_length>=4 or max_length=-1)
and system_type_id in (35,99,168,175,231,239,241)
and o.[type]='U'print @sql;