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

MSSQLÔõô»ñÈ¡Êý¾Ý¿âÀúÊ·²éѯ×Ü´ÎÊý

ÈçÌ⣬MYSQLÓÖÔõô»ñÈ¡£¿
ÈçÌâ

Õâ¸ö¹À¼ÆÔÚÈÕÖ¾ÎļþÖвÅÄÜ¿´¼û°É

Õâ¸ö¹À¼ÆÔÚÈÕÖ¾ÎļþÖвÅÄÜ¿´¼û°É


ÒýÓÃ
³ý·ÇÄãÒµÎñÉÏ×ö¼Ç¼£¬·ñÔòÄãÊDz»ÄÜÖªµÀµÄ¡£ÒòΪÈÕÖ¾²»¼Ç¼selectÓï¾äÃüÁî¡£
..

ÄÇÓÐûÓÐϵͳ´æ´¢¹ý³Ì»òÕßÈ«¾Öº¯ÊýÄܹ»»ñÈ¡ÄØ£¿

ÒýÓÃ
ÄÇÓÐûÓÐϵͳ´æ´¢¹ý³Ì»òÕßÈ«¾Öº¯ÊýÄܹ»»ñÈ¡ÄØ£¿


û

ÄÇͳ¼Æ·þÎñÆ÷Æô¶¯ºóÊÕµ½µÄ²éѯ´ÎÊý£¿


ÄÇͳ¼ÆMSSQLÆô¶¯ºóµÄ²éѯ´ÎÊý£¿

ÌìÎÄÊý×Ö£¬²»¶®¡­¡­


Ïà¹ØÎÊ´ð£º

MSSQLÈçºÎ²åÈë²»ÏàͬµÄ¼Ç¼ - .NET¼¼Êõ / ASP.NET

ÈçÌ⣬Óû§×¢²áʱ£¬Óû§ÃûÊDz»ÄÜÖØ¸´µÄ£¬ÈçºÎÅжϲåÈëµÄ¼Ç¼²»Öظ´ÄØ£¿
Çë¿´Çå³þÎÒµÄÌâÄ¿£¬²»Òª´ÓÍøÉϳ­Ò»Ð©´ð°¸¹ýÀ´£¬ÍøÉϺܶàÈËдµÄÏÈselectÔÙinsertµÄ¶¼ÊÇϹ³¶£¬Ñ¹¸ù¾Íû¿¼Âǵ½²¢·¢ÐÔÎÊÌ⣬ÎÒÏÖÔÚ²»Ïë¼ÓÉÏÐòÁл¯ ......

ÔÚ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ÖÐÈçºÎÑ¡ÔñÒ»ÐÐÖÐ×îСµÄʱ¼ä£¿

Ò»ÕÅ±í£¬×ֶηÖΪid,time1,time2,time3,time4,time5 
ÇëÎÊÎÒÓ¦¸ÃÈçºÎÑ¡ÔñIDΪ1µÄÄÇÌõ¼Ç¼ÖÐtimeʱ¼ä×îСµÄֵĨ£¿
UP!

[code=SQL][/code]select min(t) from 
(select time1 as t from t1 where id ......

¹ØÓÚMSSQLÐ޸ļÆËãÁÐ

sql2005  Äܲ»Äܶ¯Ì¬Ð޸ļÆËãÁе͍ÒåÁ˰¡
ÏÖÔÚºÜÓôÃÆµÄÊÇ
Èç¹ûÓÃÏÈɾ³ý ÔÙÌí¼Ó¼ÆËãÁеϰ
ÓëÆäÏà¹ØµÄÊÓͼ ÓÖÒªÖØÐ°Ñ×Ö¶ÎÑ¡ÉÏ

  ALTER TABLE TabelName ADD ColumnC AS ColumnA+ColumnB& ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ