ASP.NET模糊搜索
string keyword= context.Request.Form["keyword"];
string sqlText = "select * from [TableName] where PATINDEX('%'+@keyword+'%',title)>0 OR PATINDEX('%'+@keyword+'%',describe)>0 order by timestamp desc";
DataTable reader = sqlconnect.ExecuteDataTable(sqlText, new SqlParameter("@keyword", keyword));