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Óï¾äÔõôд ±íµÄ½á¹¹ÊÇÒ»ÑùµÄ
ÀýÈç£ ......
½ñÌì×öÁËÒ»¸ö´æ´¢¹ý³Ì »·¾³ÊÇSQL2000Êý¾Ý¿â
´óÖÂÈçÏÂ
½¨Á¢ÁÙʱ±í
¶¨ÒåÔ±¹¤Óαê
Ñ»·Ô±¹¤£¨ÊôÓÚ1¸ö¹«Ë¾)
......
ÐèÇóÈçÏ£º
ѧԺ academy£¨aid,aname£©
°à¼¶ class£¨cid,cname,aid£©
ѧÉú stu(sid,sname,aid,cid)
סËÞÇø region(rid,rname)
ËÞÉáÂ¥ build(bid,rid,bnote) bnoteÊÇ¡®ÄС¯/¡®Å®¡¯
ËÞÉá dorm(did,rid,bid£¬bedn ......