Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö160KB

sqlServer ÈÕÆÚ±È½Ï

±È½Ï2¸öÈÕÆÚ²îСÓÚ1·ÖÖÓ¡£ÈÕÆÚ¸ñʽΪyyyy-MM-dd HH:mm:ss
SQL code:
DATEDIFF(MS,TIME1,TIME2)<1


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


ºÇºÇ£¬ÊÇMM£¬²»ÊÇMS

ÒýÓÃ
SQL codeDATEDIFF(MS,TIME1,TIME2) <1

ºÇºÇ¡£¡£¡£¡£

ºÇºÇ,ѧϰzhong ...


Ïà¹ØÎÊ´ð£º

Óг¥ÇósqlserverÊý¾Ý¿âÉè¼Æ:ÓÐÏßµçÊÓ

ÐèҪʹÓÃSQL Server2000»ò2005
ÐèÒªÉè¼ÆÊý¾ÝÓÐЧÑéÖ¤,·Àֹ¼Èë²»ºÏ·¨Êý¾Ý
ÐèÒªÉè¼Æ´æ´¢¹ý³Ì»ò×Ô¶¨Ò庯ÊýÍê³ÉÊý¾ÝµÄ¼Èë\ÐÞ¸Ä\ɾ³ý\ͳ¼Æ\²éѯ

Êý¾Ý¿â´ó²¿·Ö±íÎÒÒѾ­½¨Á¢,Ö»ÊǸ¨ÖúÐÔµÄС±í½¨Á¢µÄ»¹²»È« ......

½ô¼±ÇóÖúsqlserver Êý¾Ý¿â±»ÅúÁ¿²åÈë´úÂë

ËùÓбíµÄÎı¾×ֶζ¼±»²åÈë´úÂë
Ôõô»ØÊ¡£
´úÂëÒѾ­Ð´Á˹ýÂË×Ö·û´®
Èç¹ûÊÇ´úÂëµÄÎÊÌâ²»Ó¦¸Ãÿ±í¸ö¶¼±»²åÈëÁË

Èç¹û²»ÊÇ£¬sqlserverºÃ¶à¸ö¿â£¬Ö»ÓÐÕâ¸ö¿â±»²åÁË

»¹ÓÐʲô¸üºÃµÄ¼ÓÃÜ·½Ê½
Ôõôà ......

sqlserver 2008²»ÄÜÔ¶³ÌµÇ¼£¬Çë°ïæ

°²×°ÁËsql server 2008ÆóÒµ°æ£¬²Ù×÷ϵͳΪwindows server 2008 X64£¬°²×°Íê³Ésql server 2008ºó£¬»¹×°ÁËvs2008£¬È»ºó´òÁËvs2008ºÍsql server 2008µÄSP1¡£
°²×°ºó£¬Á¬½ÓÊý¾Ý¿âʱ£¬Èç¹ûÖ¸¶¨·þÎñÆ÷Ãû³ÆÎª¡°.\MSSQLSE ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ