如何在Sql Injection中找出受影响的表。 [英] How to find out the affected tables in Sql Injection.

问题描述

亲爱的朋友们，



有人在我的数据库表格中输入的数据很少。这是一个SQL注入。现在我想找出多少个表格收到的数据是

Dear Friends,

Some one have entered few data in my tables in my DB.It is a SQL Injection.Now I want to find out how many tables are affected with the particular.The data received was

<title><style fontsize:10px>

推荐答案

要做的第一件事是确保您的代码不能再次允许它！但假设你已经这样做了......

如果你的意思是你需要找到包含该特定文本的所有行和列，你可以在WHERE中使用CONTAINS子句， 如果你的表是全文索引的。 ：

The first thing to do is make sure your code can't allow it again! But assuming that you have done that...
If you mean you need to find all the rows and columns containing that specific text, you can use the CONTAINS clause in your WHERE, provided your table is full text indexed.:

SELECT * FROM MyTable WHERE CONTAINS((Column1, Column2), '<title><style fontsize:10px>')

如果不是，则必须专门对每列使用LIKE子句。

If it isn't, then you will have to use a LIKE clause on each column specifically.

以下内容可能对您有所帮助< br $>


http://stackoverflow.com/questions/15757263/find-a-string-by-searching-all-tables-in-sql-server-management-studio -2008

The below may be of help to you

http://stackoverflow.com/questions/15757263/find-a-string-by-searching-all-tables-in-sql-server-management-studio-2008

我想，你想在数据库表中搜索这个字符串。

Plz看到这个帖子
-of-a-sqll-server-db [ ^ ]

I think,you want to search this string in your database tables.
Plz see this thread
http://stackoverflow.com/questions/591853/search-for-a-string-in-an-all-the-tables-rows-and-columns-of-a-sqll-server-db[^]

这篇关于如何在Sql Injection中找出受影响的表。的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！