Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

·Àsql×¢ÈëÀà

 using System;
using System.Text.RegularExpressions;
using System.Web;
namespace FSqlKeyWord
{
/**//**//**//// <summary>
/// SqlKey µÄժҪ˵Ã÷¡£
/// </summary>
public class SqlKey
{
private HttpRequest request;
//private const string StrKeyWord = @"select|insert|delete|from|count(|drop table|update|truncate|asc(|mid(|char(|xp_cmdshell|exec master|netlocalgroup administrators|:|net user|""|or|and";

//string StrKeyWord1 = @"(like|and|exec|insert|select|delete|update|chr|mid|master|or|truncate|char|declare|join)".Replace("|",")|(");
private const string StrKeyWord = @"( like | and | exec |insert|select|delete|update|chr|mid|master| or |truncate|char|declare|join|exec master|xp_cmdshell|net user|systypes|sysobjects)";
//private const string StrRegex = @"([-|;|,|/|(|)|[|]|}|{|%|@|*|!|'])";
private const string StrRegex = @"--|'|@|!";
public SqlKey(System.Web.HttpRequest _request)
{
//
// TODO: ÔÚ´Ë´¦Ìí¼Ó¹¹Ô캯ÊýÂß¼­
//
this.request = _request;
}
public SqlKey()
{
//
// TODO: ÔÚ´Ë´¦Ìí¼Ó¹¹Ô캯ÊýÂß¼­
//
//this.request = _request;
}
/**//**//**//// <summary>
/// Ö»¶ÁÊôÐÔ SQL¹Ø¼ü×Ö
/// </summary>
public static string KeyWord
{
get
{
return StrKeyWord;
}
}
/**//**//**//// <summary>
/// Ö»¶ÁÊôÐÔ¹ýÂËÌØÊâ×Ö·û
/// </summary>
public static string RegexString
{
get
{
return StrRegex;
}
}
/**//**//**//// <summary>
/// ¼ì²éURL²ÎÊýÖÐÊÇ·ñ´øÓÐSQL×¢Èë¿ÉÄܹؼü×Ö¡£
/// </summary>
/// <param na


Ïà¹ØÎĵµ£º

MS Sql ServerÊý¾Ý¿â·ÖÇø

ʲôÊÇÊý¾Ý¿â·ÖÇø£¿
Êý¾Ý¿â·ÖÇøÊÇÒ»ÖÖ¶Ô±íµÄºáÏò·Ö¸î£¬Sql server 2005ÆóÒµ°æºÍÖ®ºóµÄSql server°æ±¾²ÅÌṩÕâÖÖ¼¼Êõ£¬ÕâÖÖ¶Ô±íµÄºáÏò·Ö¸î²»Í¬ÓÚ2000Öеıí·Ö¸î£¬Ëü¶Ô·ÃÎÊÓû§ÊÇ͸Ã÷µÄ£¬Óû§²¢²»»á¸Ð¾õµÄ±í±»ºáÏò·Ö¸îÁË¡££¨2000ÖеıíºáÏò·Ö¸îÊǽ¨n¸ö±íÀýÈ簴ʱ¼ä½¨±íÿÔÂÒ»¸ö±í£¬±íÃû²»Í¬£¬×îºóÐèÒª×öÒ»¸ö´óÊÓͼ£©
Ϊʲ ......

±àдSQL²éѯµÄ¹Ø¼ü—SQLÓï¾äµÄÖ´ÐÐ˳Ðò


¡¾ÎÄÕ±êÌâ¡¿±àд
SQL
²éѯµÄ¹Ø¼ü—
SQL
Óï¾äµÄÖ´ÐÐ˳Ðò
¡¾ÎÄÕÂ×÷Õß¡¿Ôø½¡Éú
¡¾×÷ÕßÓÊÏä¡¿
zengjiansheng1@126.com
¡¾×÷Õß
QQ
¡¿
190678908
¡¾×÷Õß
MSN
¡¿
zengjiansheng1@hotmail.com
¡¾×÷Õß²©¿Í¡¿
blog.csdn.net/newjueqi
 
*********************************************************** ......

SQL ʹÓÃ

¶ÔÎÊÌâµÄÀí½âÊǽâ¾öÎÊÌâµÄǰÌᣬ½ñÌìÓöµ½Ò»¸öÏîÄ¿ÖеÄÎÊÌâÈÃÎÒÉî¿ÌµÄÌå»áµ½ÕâÒ»µã¡£
Á½¸ö±í£º
T1
Term Domain WithAncestor
car    x.com     ?
bike  y.com     ?
car    a.x.com  ?
T2
Parent    Domain
x.com ......

SQL Server 2000µÄ°²È«ÅäÖÃ

 
SQL Server 2000µÄ°²È«ÅäÖÃ
¡¡
¡¡SQL Server 2000µÄ°²È«ÅäÖÃÔÚ½øÐÐSQL Server
2000Êý¾Ý¿âµÄ°²È«ÅäÖÃ֮ǰ£¬Ê×ÏÈÄã±ØÐë¶Ô²Ù×÷ϵͳ½øÐа²È«ÅäÖ㬱£Ö¤ÄãµÄ²Ù×÷ϵͳ´¦ÓÚ°²È«×´Ì¬¡£È»ºó¶ÔÄãҪʹÓõIJÙ×÷Êý¾Ý¿âÈí¼þ£¨³ÌÐò£©½øÐбØÒªµÄ°²
È«ÉóºË£¬±ÈÈç¶ÔASP¡¢PHPµÈ½Å±¾£¬ÕâÊǺܶà»ùÓÚÊý¾Ý¿âµÄWEBÓ¦Óó£³öÏֵݲȫÒþ»¼£ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ