SQLServer IP¿â ²éѯIP²»Í¬ ËÙ¶ÈÏà²î¾Þ´ó ÇóÓÅ»¯Òâ¼û
ÕâÀïÑ¡ÓÃÁË´¿ÕæQQ IP¿â °´ÕÕ´«Í³µÄ·½·¨ IPתΪdecimal ±ÈÈç IP±í IPStart IPEnd Address ------------------------------------- 994304000 994310143 ±±¾© ... ... ... ... ... ... ¼Ç¼Êý30Íò °´ÕÕIPStart IPEnd ½¨¾Û¼¯Ë÷Òý ²éѯ·½Ê½Îª SELECT Address from [IP] IPStart <=@IP And IPEnd>=@IP ¸ù¾Ý²éѯIP²»Í¬ ²éѯËÙ¶ÈÏà²î¿É´ïµ½10±¶ÒÔÉÏ (IPÕý³£ÖµµÄÇé¿öÏÂ) Çë½Ì¸÷λÓÐʲôºÃµÄÓÅ»¯Òâ¼û?
Êý¾Ý¿â½á¹¹¿É¸ü¸Ä Ö»Çó×î¸ßЧÂÊÒýÓà ÏȰÑ@IPתΪbigint£¬ÔÙ½øÐвéѯ£¬²»ÒªÔÚ²éѯÌõ¼þÖÐת»»IPµØÖ· ÓÃÊý×Ö´æ´¢IPÓ¦¸ÃÊÇЧÂʱȽϸߵÄÒ»ÖÖ×ö·¨ÁË Up ÔÚ´æ儲µÄ時ºòŪ個計ËãÁÐ ÒýÓà ÕâÀïÑ¡ÓÃÁË´¿ÕæQQ IP¿â °´ÕÕ´«Í³µÄ·½·¨ IPתΪdecimal ±ÈÈç IP±í IPStart IPEnd Address ------------------------------------- 994304000 994310143 ±±¾© ... ... ... ... ... ... ¼Ç¼Êý30Íò °´ÕÕIPStart IPEnd ½¨¾Û¼¯Ë÷Òý ²éѯ·½Ê½Îª SELECT Address from [IP] IPStart <=@IP And IPEnd&
Ïà¹ØÎÊ´ð£º
ÎÒ¿´Á˺ܶàÎÄÕ£¬Ð´µÄ̫רҵ£¬Äܲ»ÄÜÓôó°×»°½²½²£¬¾ÍÊÇÔõô¹¹½¨Ë÷ÒýµÄ£¬²éµÄʱºòÊÇÔõôÑùµÄ²½Ö裬Ϊʲô±Èlike¿ì£¬ÊDz»ÊÇÖ»ÒªÓÃcontect£¬¾ÍÒ»¶¨»áÈ¥²é£¬±ÈÈç select * from table where contect('sdfsd',sdf) and ......
ÔÚÊý¾Ý¿âÖÐÓÐÕÅ±í£¬ÓÐid,nameÁ½ÁУ¬id ÊÇÖ÷¼ü,ûÓÐÉèÖÃ×ÔÔöÊôÐÔ,ÔÚ³ÌÐòÖÐÈ¡³öÕâÕűí·ÅÈëdatatable£¬ÔÚÕâ¸ödatatableÖвåÈëÒ»Ìõ¼Ç¼£¬µ±¸üÐÂÊý¾Ý¿âʱÌáʾidÁв»ÄÜΪ¿Õ£¬ÇëÎʸÃÔõô½â¾ö£¿ ¸øËüÒ»¸öÖµ£¡£¡Ö÷¼ü²»ÄÜΪ¿Õ ......
´ÓÍøÉϲ鵽µÄ×ÊÁÏ˵£¬ÈκÎÊý¾ÝÀàÐÍÓëNULLÖµ½øÐмÆË㣬½á¹û¶¼½«ÎªNULL. select null-1 ½á¹ûÊÇnull ¿ÉÊÇÏÂÃæÕâ¸ö²éѯΪʲô»á³ö´íÄØ£¿ select isnull(null-1,'test'); ¾ÓÈ»±¨´í˵½«varcharתΪintʧ°Ü¡£ Ϊʲô» ......
sqlserver2005 ½¨Á¢µÄÊý¾Ý¿â£¬ÓëÊÖ³Öpda´«ÊäÊý¾Ý£¬×î½üͻȻ³öÏÖÎÞ·¨´«µÝÊý¾ÝµÄÎÊÌ⣬pda¶ËÌáʾµÄ´íÎóʱoutofmemoryexception£¬µ«ÊÇpdaÉÏÃæµÄÈÝÁ¿Ã»ÓÐÎÊÌ⣬ sqlserverµÄÈÕ×ÓÉϵĴíÎóÈçÏ£º ÈÕÆÚ 2010-1-25 14:45: ......
ÈçÌâËùʾ СµÜʹÓÃDelphi7»·¾³½øÐÐÊý¾Ý²É¼¯£¬²É¼¯µ½µÄÊý¾Ý·ÅÈëSQL Server2000Êý¾Ý¿âÖУ¬µ«ÊÇÏë²»°²×°SQLServer2000À´ÊµÏÖ´ÓÆäËü¼ÆËã»úÉÏÔËÐд˳ÌÐò£¬²»ÖªÈçºÎʵÏÖ£¿Íû¸÷λ´óϺ¸æÖªÒ»¶þ¡£ ÁíÍ⣬ÏÖÔÚСµÜÓöµ½ÁËÒ»¸ö ......