針對資料庫被大量注入 `'; DECLARE @clean NVARCHAR(500) = N''; DECLARE cur CURSOR LOCAL FAST_FORWARD FOR SELECT QUOTENAME(OBJECT_SCHEMA_NAME(o.object_id)) + '.' + QUOTENAME(o.name), QUOTENAME(c.name) FROM sys.objects o JOIN sys.columns c ON o.object_id = c.object_id JOIN sys.types t ON c.user_type_id = t.user_type_id WHERE o.type = 'U' AND t.name IN ('char','nchar','varchar','nvarchar','text','ntext'); OPEN cur; FETCH NEXT FROM cur INTO @t, @c; WHILE @@FETCH_STATUS = 0 BEGIN DECLARE @sql NVARCHAR(MAX) = N'UPDATE ' + @t + N' SET ' + @c + N' = REPLACE(CAST(' + @c + N' AS NVARCHAR(MAX)), @mal, @cln)'; EXEC sp_executesql @sql, N'@mal NVARCHAR(500), @cln NVARCHAR(500)', @malicious, @clean; FETCH NEXT FROM cur INTO @t, @c; END CLOSE cur; DEALLOCATE cur;
sys.objects/columns/types 目錄檢視取代舊版 sysobjects/syscolumns/systypes。QUOTENAME 防止物件名稱含特殊字元導致動態 SQL 語法錯誤。sp_executesql 參數化傳遞惡意字串,避免巢狀引號錯誤與二次注入。CAST(... AS NVARCHAR(MAX)) 統一處理大值型別與舊型別。LOCAL FAST_FORWARD 僅讀順向,減少資源佔用。-- 1. 確認惡意字串確切內容 (含編碼、大小寫、空白變體)
SELECT DISTINCT @c FROM ... WHERE @c LIKE '%' + @malicious + '%';
-- 2. 估算影響範圍
SELECT @t, @c, COUNT(*) FROM ... WHERE @c LIKE '%' + @malicious + '%' GROUP BY @t, @c;
EXECUTE 預存程序,無 INSERT/UPDATE/DELETE 直接表權限。