MSSQLÔõô»ñÈ¡Êý¾Ý¿âÀúÊ·²éѯ×Ü´ÎÊý
ÈçÌ⣬MYSQLÓÖÔõô»ñÈ¡£¿
ÈçÌâ
Õâ¸ö¹À¼ÆÔÚÈÕÖ¾ÎļþÖвÅÄÜ¿´¼û°É
Õâ¸ö¹À¼ÆÔÚÈÕÖ¾ÎļþÖвÅÄÜ¿´¼û°É
..
ÄÇÓÐûÓÐϵͳ´æ´¢¹ý³Ì»òÕßÈ«¾Öº¯ÊýÄܹ»»ñÈ¡ÄØ£¿
û
ÄÇͳ¼Æ·þÎñÆ÷Æô¶¯ºóÊÕµ½µÄ²éѯ´ÎÊý£¿
ÄÇͳ¼ÆMSSQLÆô¶¯ºóµÄ²éѯ´ÎÊý£¿
ÌìÎÄÊý×Ö£¬²»¶®¡¡
Ïà¹ØÎÊ´ð£º
ÈçÌ⣬Óû§×¢²áʱ£¬Óû§ÃûÊDz»ÄÜÖØ¸´µÄ£¬ÈçºÎÅжϲåÈëµÄ¼Ç¼²»Öظ´ÄØ£¿
Çë¿´Çå³þÎÒµÄÌâÄ¿£¬²»Òª´ÓÍøÉϳһЩ´ð°¸¹ýÀ´£¬ÍøÉϺܶàÈËдµÄÏÈselectÔÙinsertµÄ¶¼ÊÇϹ³¶£¬Ñ¹¸ù¾Íû¿¼Âǵ½²¢·¢ÐÔÎÊÌ⣬ÎÒÏÖÔÚ²»Ïë¼ÓÉÏÐòÁл¯ ......
±íµÄ½á¹¹ÈçÏ£º
±í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 ......
Ò»ÕÅ±í£¬×ֶηÖΪ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 ......
sql2005 Äܲ»Äܶ¯Ì¬Ð޸ļÆËãÁе͍ÒåÁ˰¡
ÏÖÔÚºÜÓôÃÆµÄÊÇ
Èç¹ûÓÃÏÈɾ³ý ÔÙÌí¼Ó¼ÆËãÁеϰ
ÓëÆäÏà¹ØµÄÊÓͼ ÓÖÒªÖØÐ°Ñ×Ö¶ÎÑ¡ÉÏ
ALTER TABLE TabelName ADD ColumnC AS ColumnA+ColumnB& ......