Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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 ...


Ïà¹ØÎÊ´ð£º

ACCESS·±ÌåÁ¬½Ó¼òÌåsqlserver2000

  ÎÒµÄÊý¾Ý¿âÊǼòÌåsqlserver2000 ,ÎÒÏëÔÚ·±ÌåaccessÏÂÁ¬½Ó,ͨ¹ýodbcÊÇ¿ÉÒÔÁË,µ«ÔÚaccessϳöÏÖ´ò¿ªµÄ±íÈ«ÖÐ"#ÒÑɾ³ý"
²»ÖªµÀÒªÔõô²Ù×÷²Å¿ÉÒÔÓÃACCESS·±ÌåÁ¬½Ó¼òÌåsqlserver2000.лл!!!
´ó¼Ò¶¼ ......

sqlserverÖУ¬Óô洢¹ý³Ì·ÖÒ³

´ó¼ÒÓÐûÓÐ ´æ´¢¹ý³Ì·ÖÒ³µÄÀý×Ó£¬¹²Ïíһϣ¬Ð»Ð»£¡£¡£¡
http://wyf.javaeye.com/blog/462396

SET QUOTED_IDENTIFIER ON
GO
SET ANSI_NULLS ON
GO


/*--ʵÏÖ·ÖÒ³µÄͨÓô洢¹ý³Ì

  ......

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

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

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

Çóc#²Ù×÷sqlserverÊý¾Ý¿âÎÊÌâ

ÔÚÊý¾Ý¿âÖÐÓÐÕÅ±í£¬ÓÐid,nameÁ½ÁУ¬id ÊÇÖ÷¼ü,ûÓÐÉèÖÃ×ÔÔöÊôÐÔ,ÔÚ³ÌÐòÖÐÈ¡³öÕâÕűí·ÅÈëdatatable£¬ÔÚÕâ¸ödatatableÖвåÈëÒ»Ìõ¼Ç¼£¬µ±¸üÐÂÊý¾Ý¿âʱÌáʾidÁв»ÄÜΪ¿Õ£¬ÇëÎʸÃÔõô½â¾ö£¿
¸øËüÒ»¸öÖµ£¡£¡Ö÷¼ü²»ÄÜΪ¿Õ ......

sqlserver Ò»¸ö×ֶεĶàÐÐÊý¾ÝÏà¼Ó

×Ö¶Î1  ×Ö¶Î2  ×Ö¶Î3
1      2      4
ff      dd      xx

ÈçÉÏÃæµÄÀý×Ó£¬ÈçºÎ×ö²éѯ ÈÃÁ½ÐÐÖеÄ×ֶνøÐÐÏà¼Ó¡£

È ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ