æçç¾åº¦ç½çæ¨å¹¿é¾æ¥ï¼è¯·æ¯æä¸
http://yun.baidu.com/disk/beinvited?uk=4195699187
ä¸å谢谢ã
select * from First
select * from Secend
--å é¤å
å«âæºå°¾âæ°æ®çè®°å½
declare
@strdel varchar(20)
set @strdel='æºå°¾'
declare @temp table
(
xh int identity,
tabname varchar(20), --表å
colname varchar(20) --åå
)
insert into @temp(tabname,colname)
select b.name as tabname,a.name as colname
from syscolumns a inner join sysobjects b on a.id=object_id(b.name)
where b.xtype='U'
and b.name not in ('sysdiagrams')--æé¤ç³»ç»è¡¨
order by b.name
declare
@tabname varchar(20),
@colname varchar(20),
@i int,
@rowcount int,
@strsql varchar(100)
set @rowcount=@@ROWCOUNT
set @i=0
while @i<@rowcount
begin
set @i=@i+1
select @tabname=tabname,@colname=colname from @temp where xh=@i
set @strsql='delete ' + @tabname + ' where ' + @colname + ' like ''%' + @strdel + '%'''
exec(@strsql)
end
select * from First
select * from Secend
å é¤å
å«âæºå°¾âçæ°æ®è®°å½ï¼ççä¸é¢çææ
åå¦å»ºäºå
³ç³»å¾ï¼å¤æ§è¡å 次èæ¬å³å¯ã
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/241f95cad1c8a7864dec4a826609c93d71cf5073?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
追é®ä¸ç¨ææºå°¾å
å«çæææ°æ®é½å é¤äºï¼åªå é¤âæºå°¾âäºåå¢ï¼æçæå¡å¨ä¸çæ°æ®åºè¢«äººæ³¨å
¥äºéæ³å符ï¼å ä¹ææ表ç大å¤æ°å段é½è¢«æ³¨å
¥è¯¥ä¿¡æ¯ï¼ææ³ä¸æ¬¡æ§å é¤å®ä»¬ï¼å¦ä¸å¾ï¼
![](https://video.ask-data.xyz/img.php?b=https://iknow-pic.cdn.bcebos.com/bba1cd11728b47106d753a40c2cec3fdfd0323e0?x-bce-process=image%2Fresize%2Cm_lfit%2Cw_600%2Ch_800%2Climit_1%2Fquality%2Cq_85%2Fformat%2Cf_auto)
åé¢çº¢è²æ¡æ¡éé¢çé½æ¯ä¸è¯ä¿¡æ¯ï¼ææ³å é¤ï¼æ±å¸®å¿åï¼ï¼ææ³å°±ç´æ¥å¨sqléé¢æ§è¡å é¤è¯å¥ï¼æ±ä»£ç åï¼å¤§ä¾
追çé£ä½ æreplace就好äºå
æ¿æ¢