select ID from FBaoMingXinXi where DATEDIFF(MS,DengJiShiJian,2009-11-16 10:59:50) <1
10 ¸½½üÓï·¨´íÎó SQL code: select ID from FBaoMingXinXi where DATEDIFF(MS,DengJiShiJian,'2009-11-16 10:59:50') <1
SQL code: select ID from FBaoMingXinXi where DATEDIFF(MS,DengJiShiJian,'2009-11-16 10:59:50') <1
''ÈÕÆÚÒýºÅ¶¼²»´ò¸ö? Èç¹ûǰºó´óС²»Ò»¶¨µÄ»°¼Ó¾ø¶ÔÖµ SQL code: select ID from FBaoMingXinXi where ABS(DATEDIFF(MS,DengJiShiJian,'2009-11-16 10:59:50')) <1
°²×°ÁËsql server 2008ÆóÒµ°æ£¬²Ù×÷ϵͳΪwindows server 2008 X64£¬°²×°Íê³Ésql server 2008ºó£¬»¹×°ÁËvs2008£¬È»ºó´òÁËvs2008ºÍsql server 2008µÄSP1¡£ °²×°ºó£¬Á¬½ÓÊý¾Ý¿âʱ£¬Èç¹ûÖ¸¶¨·þÎñÆ÷Ãû³ÆÎª¡°.\MSSQLSE ......