網站遭 SQL 注入植入惡意 `'; DECLARE @clean VARCHAR(500) = ''; DECLARE table_cursor CURSOR FOR SELECT o.name AS TableName, c.name AS ColumnName FROM sysobjects o JOIN syscolumns c ON o.id = c.id JOIN systypes t ON c.xtype = t.xtype WHERE o.xtype = 'U' -- 使用者資料表 AND t.name IN ('char','nchar','varchar','nvarchar','text','ntext'); OPEN table_cursor; FETCH NEXT FROM table_cursor INTO @t, @c; WHILE @@FETCH_STATUS = 0 BEGIN DECLARE @sql NVARCHAR(MAX) = N'UPDATE [' + @t + '] SET [' + @c + '] = REPLACE(CAST([' + @c + '] AS NVARCHAR(MAX)), @mal, @cln)'; EXEC sp_executesql @sql, N'@mal NVARCHAR(500), @cln NVARCHAR(500)', @malicious, @clean; FETCH NEXT FROM table_cursor INTO @t, @c; END CLOSE table_cursor; DEALLOCATE table_cursor;
sp_executesql 參數化,避免動態 SQL 嵌套引號錯誤與二次注入風險。CAST(... AS NVARCHAR(MAX)) 統一處理 text/ntext 與 (n)varchar,避免舊型別不支援 REPLACE。SELECT 驗證受影響範圍:SELECT COUNT(*) FROM [表] WHERE [欄位] LIKE '%' + @malicious + '%'EXEC 預存程序,無直接表操作權限。sys.fn_trace_gettable 或擴充事件 監控異常動態 SQL。