msSql ÐÞ¸Äʱ¼ä×Ö¶Î - MS-SQL Server / »ù´¡Àà
±íA
SQL code:
autoID outDate type resultDate
1 2010-05-10 11£º12£º03 1 null
2 2010-05-10 15£º10£º03 0 null
3 2010-05-12 11£º12£º03 0 null
4 2010-05-14 11£º12£º03 1 null
5 2010-05-15 11£º12£º03 1 null
ÏÖÔÚÎÒÏë¸ü¸Ä±íAÀïµÄ resultDate ×Ö¶Î
Èç¹ûtypeΪ0£¬resultDate ¸ÄΪ outDate ¼ÓÉÏ20ÌìºóµÄ½á¹û
Èç¹ûtypeΪ1£¬resultDate ¸ÄΪ outDate ¼ÓÉÏ30ÌìºóµÄ½á¹û
Ð޸ĺóµÄ½á¹ûÓ¦¸ÃΪ£º
SQL code:
autoID outDate type resultDate
1 2010-05-10 11£º12£º03 1 2010-05-30 11£º12£º03
2 2010-05-10 15£º10£º03 0 2010-06-09 15£º10£º03
3 2010-05-12 11£º12£º03 0 2010-05-11 11£º12£º03
4 2010-05-14 11£º12£º03 1 2010-06-03 11£º12£º03
5 2010-05-15 11£º12£º03 1 2010-06-04 11£º12£º03
ÄÄλ֪µÀµÄ°ïÎÒ½â¾öÏÂ
лл
SQL code:
update ta
set resultDate=(case when [type]=0 then dateadd(day,2
Ïà¹ØÎÊ´ð£º
Ö´ÐеÄ˳Ðò£º
1£©Îļþä¯ÀÀ¿ò£¨Ñ¡ÔñÎļþʹÓã©
Ñ¡ÔñºÃÎļþºó
µã»÷Ò»¸öµ¼Èë°´Å¥µÄʱºò £¬°ÑÉÏÃæÉÏ´«¿òÀïµÄcsvÎļþÒÔÒ»¸öIDΪÎļþÃû£¬ÉÏ´«µ½**/**Îļþ¼ÐÏÂ
2£©¶ÁÈ¡Õâ¸öÎļþ¼ÐϵÄcsvµÄÎļþ£¬×ª»»³Ésql
3 ......
ÎÒÓжà¸ö±íA B C ½á¹¹ÊÇÒ»ÑùµÄ£¬¶¼ÓÐ2¸ö×Ö¶ÎnameºÍcontent,ÎÒÒªËÑË÷ËùÒÔ±íËùÓÐ×Ö¶ÎÖаüº¬¡°Öйú¡±µÄÄÚÈÝ Õâ¸öSQLÓï¾äÔõôд
ÈçºÎ½«¶à¸ö±íµÄ²éѯ½á¹ûÁ¬³ÉÒ»¸ö±í Õâ¸öSQLÓï¾äÔõôд ±íµÄ½á¹¹ÊÇÒ»ÑùµÄ
ÀýÈç£ ......
ÓÐÒ»¸öÊý¾Ý¿âÀïÖ»ÓÐ2WÌõÊý¾Ý²»µ½£¬È´ÓÐ500MÄÇô´ó,Ôõô»ØÊ°¡£¿ÊÇACCESSµÄÊý¾Ý¿â¡£ºóÀ´ÎÒ°ÑACCESSµ¼Èëµ½MSSQLÖУ¬Ò²Õ¼ÓÃÁË500M×óÓҵĿռ䣬Èç¹ûѹËõÊý¾Ý¿âÄØ£¿Çë¸ßÊÖÖ¸µã
ѹËõÊý¾Ý¿â£¿ÄÜ×öµ½Ã´...
ÆÚ´ý¸ßÈËÖ¸µã ÎÒ ......
tab1 ×Ö¶Î:billdate,goodsid,incount,inmoney,outcount,outmoney,endprice,endcount,endamt
tab2 ×Ö¶Î:goodsid,goodskind£¨ÉÌÆ·ÀàÐÍ£©
tab3 ×Ö¶Î:goodskind£¨ÉÌÆ·ÀàÐÍ£©,kindname
½á¹û£º
µÃµ½ÉÌÆ·ÀàÐÍÔÚÒ»¶Îʱ¼ä ......
ÓÐTABLEA ×Ö¶ÎΪ ²É¹ºµ¥ºÅ¡¢Ðкš¢ÎïÁϱàÂë¡¢Èë¿âÈÕÆÚ
ÏÖÏë°´ÕÕÎïÁϱàÂë²éѯ×î´óÈë¿âÈÕÆÚ
Óï¾äÈçÏ£º
SELECT ²É¹ºµ¥ºÅ¡¢Ðкš¢ÎïÁϱàÂë¡¢Èë¿âÈÕÆÚ from TABLEA A WHERE Èë¿âÈÕÆÚ=(SELECT MAX(Èë¿âÈÕÆÚ ......