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

mssql ¶Ì·ÅжÏÄÜʵÏÖÂð

cÓïÑÔÖеÄ&ºÍ&&£¬ÆäÖÐ&&¾ßÓжÌ·ÅжϹ¦ÄÜ£¬ÔÚmssqlÖÐÓжÌ·ÅжÏÂÎÒÓÃand²»ÐУ¬°Ñand»»³É&&±¨´íÁË
MSSQLÖÐûÓÐ&&

½«nvarchar Öµ '1g' ת»»ÎªÊý¾ÝÀàÐÍΪ int µÄÁÐʱ·¢ÉúÓï·¨´íÎó£¬Äܲ»ÄÜÈÃÕâ¸öÌø¹ý£¬¾ÍÊÇ˵²éÕÒµ½²»ÄÜת»»µÄ¾Í²»¹ÜËüÁË


Õâ¸ö£¬Ó¦¸ÃÊÇ¿ÉÒÔÓбä֮ͨ·¨µÄ

ÒýÓÃ
½«nvarchar Öµ '1g' ת»»ÎªÊý¾ÝÀàÐÍΪ int µÄÁÐʱ·¢ÉúÓï·¨´íÎó£¬Äܲ»ÄÜÈÃÕâ¸öÌø¹ý£¬¾ÍÊÇ˵²éÕÒµ½²»ÄÜת»»µÄ¾Í²»¹ÜËüÁË


ÕâÖÖ¶¼ÊÇÓÃwhereÌõ¼þ¹ýÂ˵ôµÄ£¬¾ÍÏñ2Â¥Ëù˵µÄwhere isnumeric(×Ö¶Î)=1


Ïà¹ØÎÊ´ð£º

MSSQL ת»» MYSQL

ÈçºÎ½«MSSQLÊý¾Ý¿âת»»ÎªMYSQL
ÔÚÍøÉÏÕÒÁ˺ܶà ˵µÄºÜÂÒ ÇëÎÊÓиßÊÖ¿ÉÒÔ½ÌÏÂÂð ллÁË
ûÓÐʲôºÃ°ì·¨¡£Á½ÕßÖ®¼ä»¹ÊÇÓÐЩ²îÒìµÄ¡£

Êý¾ÝÀàÐÍ£¬´æ´¢¹ý³ÌÓï·¨¡£

Èç¹ûÖ»ÊDZíºÍ¼Ç¼£¬Ôò¿ÉÒÔ°²×°Ò»¸öMYS ......

¹ØÓÚACCESSºÍMSSQLµÄÎÊÌâ - Web ¿ª·¢ / ASP

ÓÐÒ»¸öÊý¾Ý¿âÀïÖ»ÓÐ2WÌõÊý¾Ý²»µ½£¬È´ÓÐ500MÄÇô´ó,Ôõô»ØÊ°¡£¿ÊÇACCESSµÄÊý¾Ý¿â¡£ºóÀ´ÎÒ°ÑACCESSµ¼Èëµ½MSSQLÖУ¬Ò²Õ¼ÓÃÁË500M×óÓҵĿռ䣬Èç¹ûѹËõÊý¾Ý¿âÄØ£¿Çë¸ßÊÖÖ¸µã
ѹËõÊý¾Ý¿â£¿ÄÜ×öµ½Ã´...
ÆÚ´ý¸ßÈËÖ¸µã ÎÒ ......

ÔÚMSSQLÖÐдһ¸ö´¥·¢Æ÷

±íµÄ½á¹¹ÈçÏ£º

±í1£ºtb_big
×ֶΣºfalseid Öµ£º1£¬2£¬
×ֶΣºbigtype Öµ£ºA£¬B£¨ÓëfalseidµÄÖµµÄλÖÃÒ»Ò»¶ÔÓ¦£¬¼´1¶ÔÓ¦A£¬2¶ÔÓ¦B£©

±í2£ºtb_small
×ֶΣºfalseid£¨Óëtb_bigµÄfalseid_1¹ØÁªµ ......

MSSQLÊý¾Ý¿âDayHits×Ô¶¯ÇåÁã

ÈçÌ⣬ÈçºÎÈÃÊý¾Ý¿âÖÐÿÈյĵã»÷Êý¼Ç¼ÔÚ24£º00×Ô¶¯ÇåÁ㣬²»ÓÃSQL¼Æ»®ÈÎÎñʵÏÖ£¬ÒòΪÎÒÎÞ·¨¹ÜÀíSQL·þÎñÆ÷£¬ÎÒÏëͨ¹ýGlobal.ascxʵÏÖ£¬¾ßÌå²»ÖªµÀÔõô×ö¡£
ÎÊÌâÓеãÄÑ


using System.Timers;

private s ......

Á¬½ÓMSSQLµÄÎÊÌâ

ÎÒµÄjava³ÌÐòÒªÁ¬½ÓÔ¶³ÌµÄÊý¾Ý¿âMSSQL£¬µ«ÊÇÔ¶³Ì·þÎñÆ÷£¬Ã»Óпª1433¶Ë¿Ú£¬ÓÐʲô°ì·¨ÄÜÈÃÎÒµÄjava³ÌÐòÁ¬½ÓÔ¶³ÌÊý¾Ý¿â
ÊÇ˵mysqlÂð£¿


ÎÒÒ²Óöµ½ÁËÕâ¸öÎÊÌ⣬ÎÒÒ²ÏëÇó½â¾ö£¬ºÇºÇ£¬°ïÄã¶¥¶¥£¡

MSSQL,¾ÍÊÇ΢Èí ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ