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
Ïà¹ØÎÊ´ð£º
ÎÒÓжà¸ö±íA B C ½á¹¹ÊÇÒ»ÑùµÄ£¬¶¼ÓÐ2¸ö×Ö¶ÎnameºÍcontent,ÎÒÒªËÑË÷ËùÒÔ±íËùÓÐ×Ö¶ÎÖаüº¬¡°Öйú¡±µÄÄÚÈÝ Õâ¸öSQLÓï¾äÔõôд
ÈçºÎ½«¶à¸ö±íµÄ²éѯ½á¹ûÁ¬³ÉÒ»¸ö±í Õâ¸öSQLÓï¾äÔõôд ±íµÄ½á¹¹ÊÇÒ»ÑùµÄ
ÀýÈç£ ......
tab1 ×Ö¶Î:billdate,goodsid,incount,inmoney,outcount,outmoney,endprice,endcount,endamt
tab2 ×Ö¶Î:goodsid,goodskind£¨ÉÌÆ·ÀàÐÍ£©
tab3 ×Ö¶Î:goodskind£¨ÉÌÆ·ÀàÐÍ£©,kindname
½á¹û£º
µÃµ½ÉÌÆ·ÀàÐÍÔÚÒ»¶Îʱ¼ä ......
Çë½Ì¸ßÊÖ£º
ÒÔÏÂÊÇÊý¾Ý¿âÖеÄÈýÌõ¼Ç¼£¬Ó¢ÎÄΪ×Ö¶ÎÃû³Æ
id planname TaskBeginTime Status
329 2010Äê03 ......
ÐèÇóÈçÏ£º
ѧԺ 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 ......
ÓÐÕâÑùÒ»ÌõSQL
Select Get_Costtaxrate(col1), Get_Tcostvalue(col1) from a
ÆäÖÐGet_Costtaxrate¡¢Get_Tcostvalue¶¼ÊǺ¯Êý£¬ÕâÁ½¸öº¯ÊýÀïÃæ¶¼ÊDzéÕÒÒ»¸ö´ó±í£¬Get_Tcostvalue»¹ÐèÒªµ÷ÓÃGet_C ......