mssql ¶Ì·ÅжÏÄÜʵÏÖÂð
    
	
	cÓïÑÔÖеÄ&ºÍ&&£¬ÆäÖÐ&&¾ßÓжÌ·ÅжϹ¦ÄÜ£¬ÔÚmssqlÖÐÓжÌ·ÅжÏÂÎÒÓÃand²»ÐУ¬°Ñand»»³É&&±¨´íÁË
MSSQLÖÐûÓÐ&&
½«nvarchar Öµ '1g' ת»»ÎªÊý¾ÝÀàÐÍΪ int µÄÁÐʱ·¢ÉúÓï·¨´íÎó£¬Äܲ»ÄÜÈÃÕâ¸öÌø¹ý£¬¾ÍÊÇ˵²éÕÒµ½²»ÄÜת»»µÄ¾Í²»¹ÜËüÁË
Õâ¸ö£¬Ó¦¸ÃÊÇ¿ÉÒÔÓбä֮ͨ·¨µÄ
 
  
 ÕâÖÖ¶¼ÊÇÓÃwhereÌõ¼þ¹ýÂ˵ôµÄ£¬¾ÍÏñ2Â¥Ëù˵µÄwhere isnumeric(×Ö¶Î)=1
    
 
	Ïà¹ØÎÊ´ð£º
        
    
    ÈçºÎ½«MSSQLÊý¾Ý¿âת»»ÎªMYSQL 
 ÔÚÍøÉÏÕÒÁ˺ܶà ˵µÄºÜÂÒ ÇëÎÊÓиßÊÖ¿ÉÒÔ½ÌÏÂÂð ллÁË
ûÓÐʲôºÃ°ì·¨¡£Á½ÕßÖ®¼ä»¹ÊÇÓÐЩ²îÒìµÄ¡£ 
  
 Êý¾ÝÀàÐÍ£¬´æ´¢¹ý³ÌÓï·¨¡£ 
  
 Èç¹ûÖ»ÊDZíºÍ¼Ç¼£¬Ôò¿ÉÒÔ°²×°Ò»¸öMYS ......
    
        
    
    ÓÐÒ»¸öÊý¾Ý¿âÀïÖ»ÓÐ2WÌõÊý¾Ý²»µ½£¬È´ÓÐ500MÄÇô´ó,Ôõô»ØÊ°¡£¿ÊÇACCESSµÄÊý¾Ý¿â¡£ºóÀ´ÎÒ°ÑACCESSµ¼Èëµ½MSSQLÖУ¬Ò²Õ¼ÓÃÁË500M×óÓҵĿռ䣬Èç¹ûѹËõÊý¾Ý¿âÄØ£¿Çë¸ßÊÖÖ¸µã
ѹËõÊý¾Ý¿â£¿ÄÜ×öµ½Ã´...
ÆÚ´ý¸ßÈËÖ¸µã ÎÒ ......
    
        
    
    ±íµÄ½á¹¹ÈçÏ£º 
  
 ±í1£ºtb_big 
 ×ֶΣºfalseid Öµ£º1£¬2£¬ 
 ×ֶΣºbigtype Öµ£ºA£¬B£¨ÓëfalseidµÄÖµµÄλÖÃÒ»Ò»¶ÔÓ¦£¬¼´1¶ÔÓ¦A£¬2¶ÔÓ¦B£© 
  
 ±í2£ºtb_small 
 ×ֶΣºfalseid£¨Óëtb_bigµÄfalseid_1¹ØÁªµ ......
    
        
    
    ÈçÌ⣬ÈçºÎÈÃÊý¾Ý¿âÖÐÿÈյĵã»÷Êý¼Ç¼ÔÚ24£º00×Ô¶¯ÇåÁ㣬²»ÓÃSQL¼Æ»®ÈÎÎñʵÏÖ£¬ÒòΪÎÒÎÞ·¨¹ÜÀíSQL·þÎñÆ÷£¬ÎÒÏëͨ¹ýGlobal.ascxʵÏÖ£¬¾ßÌå²»ÖªµÀÔõô×ö¡£
ÎÊÌâÓеãÄÑ
 
 using System.Timers; 
  
 private s ......
    
        
    
    ÎÒµÄjava³ÌÐòÒªÁ¬½ÓÔ¶³ÌµÄÊý¾Ý¿âMSSQL£¬µ«ÊÇÔ¶³Ì·þÎñÆ÷£¬Ã»Óпª1433¶Ë¿Ú£¬ÓÐʲô°ì·¨ÄÜÈÃÎÒµÄjava³ÌÐòÁ¬½ÓÔ¶³ÌÊý¾Ý¿â
ÊÇ˵mysqlÂ𣿠
 
ÎÒÒ²Óöµ½ÁËÕâ¸öÎÊÌ⣬ÎÒÒ²ÏëÇó½â¾ö£¬ºÇºÇ£¬°ïÄã¶¥¶¥£¡
MSSQL,¾ÍÊÇ΢Èí ......