如题所述
ä¹ååè¿äºä¸ä¸ªç½ç«ï¼ç±äºæ²¡æ对页é¢åæ°è¿è¡éªè¯ï¼æä¸å»æ²¡å¤é¿æ¶é´å°±è¢«äººæ马äºï¼æ°æ®åºçæ¯ä¸ªè¡¨æ¯ä¸ªå段å 容éé½è¢«æ³¨å ¥äºä¸æ®µä»£ç ï¼ä»ä¹å¨æ°æ®åºä¸è¿æ°å»ºäºèªå·±ç表ï¼çæ¯å¤ªå£å¼ äºï¼ä½æ¯è¿ä¹å¤å 容æ¯ä¸å¯è½æå¨å»å é¤çï¼è§£å³è¿ç¨å¦ä¸
ä¸ãé¦å å é¤æ°æ®åºè¢«æ³¨å ¥ç代ç
å¦ç»ä¸å é¤<script src=http://3b3.org/c.js> </script> ï¼æ¤éç¨äºsql serverï¼
DECLARE hCForEach CURSOR GLOBALFOR
SELECT N'update '+QUOTENAME(o.name)
+N' set '+ QUOTENAME(c.name) + N' = replace(CAST(' + QUOTENAME(c.name) + ' as varchar(8000)),''<script src=http://3b3.org/c.js></script>'','''')'
FROM sysobjects o,syscolumns c,systypes t
WHERE o.id=c.id
AND OBJECTPROPERTY(o.id,N'IsUserTable')=1
AND c.xusertype=t.xusertype
AND (t.name='varchar' or t.name='ntext')
EXEC sp_MSforeach_Worker @command1=N'?'
注æè¿æ ·å é¤ä¹å ntextå段å°è¢«æªææ8000个å符 导è´æ°æ®ä¸¢å¤±ï¼å½ç¶å ¶å®å¨sqlæ³¨å ¥ä¹åè¿ç§å段å±æ§å·²ç»è¢«æªæäºï¼æ以å¨å é¤è¿äºä¹åè¿è¦è¿è¡æ°æ®æ¢å¤ä½æ¯ ç½ç«è¢«æ马å¾å¾æ¯éæºçä¸ç¥éä»ä¹æ¶å æ们å¯è½æ²¡æååæ¶çå¤ä»½ï¼æ æ³æ¢å¤
è¿æ¶åæ们å¯ä»¥èèä»æ°æ®åºæ¥å¿è¿è¡æ¢å¤
1ï¼å¦æ误æä½ä¹ååå¨ä¸ä¸ªå ¨åºå¤ä»½ï¼æå·²æå¤ä¸ªå·®å¼å¤ä»½æå¢éå¤ä»½ï¼ï¼é¦å è¦åçäºå°±æ¯è¿è¿è¡ä¸æ¬¡æ¥å¿å¤ä»½ï¼å¦æ为äºä¸è®©æ¥å¿æ件å大èç½®trunc. log on chkpt.é项为1é£ä½ å°±æ»ç¿äºï¼
backup log dbName to disk='fileName'2ï¼æ¢å¤ä¸ä¸ªå ¨åºå¤ä»½ï¼æ³¨æéè¦ä½¿ç¨with norecoveryï¼å¦æè¿æå ¶ä»å·®å¼æå¢éå¤ä»½ï¼åé个æ¢å¤
restore database dbName from disk='fileName' with norecovery3ï¼æ¢å¤æåä¸ä¸ªæ¥å¿å¤ä»½å³ååçæ¥å¿å¤ä»½ï¼æå®æ¢å¤æ¶é´ç¹å°è¯¯æä½ä¹åçæ¶å»
restore log dbName from disk='fileName'with stopat='date_time'
æåå°±æ¯æç½ç«çæ¼æ´è¡¥ä¸ 对åæ°è¿è¡è¿æ»¤