ÇóÒ»ÌõmssqlÓï¾ä..?? - MS-SQL Server / »ù´¡Àà
ÇóÒ»ÌõmssqlÓï¾ä..?? ±í news ×Ö¶Îdtime µÄÀàÐÍÊÇdatetime ÎÒҪɾ³ýËùÓÐ µ±Ç°·þÎñÆ÷ʱ¼ä¼õÈ¥ dtime×ֶδóÓÚ5ÌìµÄ¼Ç¼( getdate()-dtime )>5 µÃÔõôд.Çë´Í½Ì??
SQL code: datediff(dd,dtime,getdate())>5 SQL code: select * from news where datediff(dd,dtime,getdate())>5 SQL code: dtime<dateadd(dd,-5,getdate()) д·¨Òª¸Ä³ÉÕâÑù×îºÃÒýÓà SQL code datediff(dd,dtime,getdate())>5 ´ó¸çÄܲ»ÄܰïÎÒдÍêÕûÒ»µã..ÎÒÒ²ÊÇÓõ½datediff(dd,dtime,getdate())>5 µ«ÀÏÊÇÖ´Ðв»³É¹¦ лл SQL code: delete news where dtime<dateadd(dd,-5,getdate()) ÔÎ SQL code: delete news where datediff(dd,dtime,getdate())>5 Õâ¸öÓ¦¸ÃÄܳɹ¦°¡ ²»³É¹¦±¨Ê²Ã´´íÎó? лл.¸÷λ.. ѧϰÏ Óкô¦µÄ
Ïà¹ØÎÊ´ð£º
Ö´ÐеÄ˳Ðò£º 1£©Îļþä¯ÀÀ¿ò£¨Ñ¡ÔñÎļþʹÓã© Ñ¡ÔñºÃÎļþºó µã»÷Ò»¸öµ¼Èë°´Å¥µÄʱºò £¬°ÑÉÏÃæÉÏ´«¿òÀïµÄcsvÎļþÒÔÒ»¸öIDΪÎļþÃû£¬ÉÏ´«µ½**/**Îļþ¼ÐÏ 2£©¶ÁÈ¡Õâ¸öÎļþ¼ÐϵÄcsvµÄÎļþ£¬×ª»»³Ésql 3 ......
ÎÒÒ»¸öÏîÄ¿£¬Óиö²åÈë²Ù×÷£¬¾ßÌåÊÇÕâÑùµÄ£º ÎÒÓнø»õÐÅÏ¢±í¡£ÔÚ³ö»õʱѡÔñÏàÓ¦µÄ½ø»õÐÅÏ¢£¬ÊäÈëÊýÁ¿£¬Ñ¡Ôñ²¿Ãź󣬵㱣´æ°´Å¥£¬ÓÉÓÚÍøÂçÑÓʱ£¬µãÒ»ÏÂûÓз´Ó³£¬ÓÚÊÇÓû§¾ÍÓÖµãһϣ¬µ¼ÖÂÒ»´Î²åÈëÁËÁ½Ìõ¼Ç¼: Àý£º
......
select count(1) from FX_RETURNBOOKCHECKLIST fxreturnbo0_ where fxreturnbo0_.BOOKID='164 ' AND fxreturnbo0_.RETURNID='00025.S0000001' ÉÏÃæÒ»¸ö¼òµ¥µÄSQL,Ö´ÐÐʱ¼ä2.6à ......
ÇëÎÊ Ìí¼ÓÐÂÊý¾ÝÔ´->Êý¾Ý¿â->Ìí¼ÓÁ¬½Ó Õâ¸ö½çÃæÏ£¬Êý¾ÝÔ´Ñ¡Ôñ£ºMicrosoft SQL Server (SqlClient)£» ·þÎñÆ÷Ãû£º Ó¦¸ÃÐ´Ê²Ã´ÄØ£¿ ÓÐËÖªµÀ£¿¶àл¸÷λ£¡£¡ Äãµ½µ×ÊÇÒªÁ¬mysql»¹ÊÇmssql£¿ ÒýÓà ÇëÎÊ ......
ÏÂÃæÊÇXML³õʼÎļþÄÚÈÝ XML code: <upd:Update xmlns:lar="http://schemas.microsoft.com/msus/2002/12/LogicalApplicabilityRules" xmlns:cmd="http://schemas.microsoft.com/msus/2002/12/Up ......