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

×î¼òµ¥µÄ×î¸ßЧµÄ¹ýÂËSQL½Å±¾·À×¢Èë

.errInfo
{
    border:solid 1px #d00;
    background:#F7F0F7;
}
1.URLµØÖ··À×¢È룺
//¹ýÂËURL·Ç·¨SQL×Ö·û
var sUrl=location.search.toLowerCase();
var sQuery=sUrl.substring(sUrl.indexOf("=")+1);
re=/select|update|delete|truncate|join|union|exec|insert|drop|count|’|"|=|;|>|<|%/i;
if(re.test(sQuery))
{
    alert("ÇëÎðÊäÈë·Ç·¨×Ö·û");
    location.href=sUrl.replace(sQuery,"");
}
 
2.ÊäÈëÎı¾¿ò·À×¢È룺
ÒýÈëÒÔÏÂjs
//·ÀÖ¹SQL×¢Èë
function AntiSqlValid(oField )
{
    re= /select|update|delete|exec|count|’|"|=|;|>|<|%/i;
    if ( re.test(oField.value) )
    {
    //alert("ÇëÄú²»ÒªÔÚ²ÎÊýÖÐÊäÈëÌØÊâ×Ö·ûºÍSQL¹Ø¼ü×Ö£¡"); //×¢ÒâÖÐÎÄÂÒÂë
    oField.value = ”;
    oField.className="errInfo";
    oField.focus();
    return false;
    }
 
ÔÚÐèÒª·À×¢ÈëµÄÊäÈëÎı¾¿òÌí¼ÓÈçÏ·½·¨
            txtName.Attributes.Add("onblur", "AntiSqlValid(this)");//·ÀÖ¹Sql½Å±¾×¢Èë


Ïà¹ØÎĵµ£º

SQLÉú³ÉËæ»ú×Ö·û´®

declare @str varchar(50)
 declare   @i   int  
 set @str = ''
   set   @i=0  
   while   @i<50 
   begin  
        set   @str = ......

SQL SERVER×÷Òµ¹ÜÀíÊý¾Ý¿â

×÷Òµ¹ÜÀí
×Ô¶¯´¦ÀíÒ»¸öÈÎÎñµÄµÚÒ»²½ÊÇ´´½¨¶ÔÓ¦µÄ×÷Òµ£¬×÷Òµ¿ÉÒÔʹÓÃÁ½ÖÖ¹¤¾ßÀ´´´½¨£¬¼´´´½¨×÷ÒµÏòµ¼ºÍSQL Server ÆóÒµ¹ÜÀíÆ÷¡£´´½¨×÷Òµ×îÈÝÒ׵ķ½·¨ÊÇʹÓô´½¨×÷ÒµÏòµ¼£¬Ò»°ãÀ´Ëµ£¬Èç¹ûÒª´´½¨×÷Òµ£¬±ØÐëÖ´ÐÐÒÔÏÂÈý¸ö²½Ö裺
(1)¶¨Òå×÷Òµ²½£»
(2)Èç¹û¸Ã×÷Òµ²»ÊÇÓû§Ö¸¶¨Ö´ÐУ¬´´½¨×÷ÒµÖ´Ðеĵ÷¶Èʱ¼ä£»
(3)֪ͨ²Ù×÷Ô±×÷Òµ ......

SQL SERVER¶¨Òå²Ù×÷Ô±Êý¾Ý»Ö¸´

¶¨Òå²Ù×÷Ô±
SQL Server´úÀíÍê³ÉÒ»¸ö×÷Òµºó£¬Í¨Öª²Ù×÷Ô±µÄ·½·¨ÓжàÖÖ¡£
ÀýÈ磬ͨ¹ýÃüÁîϵͳ°ÑÏàÓ¦µÄÏûϢдÈëWindows NTʼþÈÕÖ¾ÖУ¬ÒÔ±ã֪ͨϵͳ¹ÜÀíÔ±·´¸´¶ÁÈ¡´ËÈÕÖ¾¡£
ÁíÍâÒ»ÖÖ¸üºÃµÄÑ¡Ôñ¾ÍÊÇʹÓõç×ÓÓʼþ¡¢´«ºô»ú»òÍøÂç´«ËͰѾ¯±¨ÏûϢ֪ͨ¸ø²Ù×÷Ô±¡£²Ù×÷Ô±ÊÇSQL Server´úÀí·¢ËÍÏûÏ¢µÄ½ÓÊÕÕߣ¬²Ù×÷Ô±¿ÉÒÔÔÚÒ»¸ö×÷ҵ֮ǰ ......

win7 Ï ÅäÖà SQL Server 2005 ÔÊÐíÔ¶³Ì·ÃÎÊ

win7 Ï ÅäÖà SQL Server 2005 ÔÊÐíÔ¶³Ì·ÃÎÊ
2010Äê2ÔÂ2ÈÕ bibiQ
±¾À´Ò»Ö±²»Ô¸ÒâÅäÖÃÔ¶³Ì·ÃÎÊSQL server£¬µ«½ñÌìÒ»ºÝÐİÑËüÅäºÃÁË¡£
²Î¿¼ÁËÍøÉϵÄÌû×Óhttp://www.cnblogs.com/sukiwqy/archive/2009/11/11/1601381.html
step1£º ÅäÖÃSQL Server ÍâΧӦÓÃÅäÖÃÆ÷£¨Îª SQL Server 2005 ÆôÓÃÔ¶³ÌÁ¬½Ó¡¢ÆôÓà SQL Server Brow ......

Sql ServerÖÐʹÓÃnewid()Ëæ»úº¯ÊýÈ¡³öÊý¾Ý

ÕâÖÖÓ÷¨ÏàÐÅÔÚÍøÕ¾Öо­³£Ê¹Óã¬ÈçÒªÔÚ±íÖÐËæ»úÈ¡³ö10Ìõ¼Ç¼£¬Èç¹ûʹÓñà³ÌÓïÑÔ½øÐÐÔËËãµÄ»°»áºÜÂé·³¶øÇÒЧÂʵÍÏ¡£ÔÚSql ServerÖÐ×Ô´øÁËrandom()º¯ÊýÓÃÓÚÉú³ÉËæ»úÊý£¬ÆäʵËü»¹×Ô´øÁËÁíÍâÒ»¸öËæ»úº¯Êýnewid();newid()ÔÚɨÃèÿÌõ¼Ç¼ʱ¶¼»áÉú³ÉÒ»¸öËæ»úµÄÖµ£º
Ö´ÐÐselect newid()£»ÔËÐнá¹û
¿ÉÒÔ¿´µ½Õâ²¢²»ÊÇÒ»¸öËæ»úµÄÊý× ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ