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

sql ÈÕÆÚ¼ÆËã

ÔÚÍøÉÏËÑÁË ºÃ¶à
ÓÐÆ´½Ó×Ö·û´®µÄ£¬²»¹ýÎÒ¾õµÃ ¼ÈÈ» sql ³ýÁË dateTime  Õâ¸öÀàÐÍ ¾Í²»»áÈÃÄã È¥½ØÈ¡×Ö·û´® £¨ÕâÑù¶àÂ鷳ѽ£©
ÓÚÊÇÔÙËÑ  £¬ÕÒµ½Ò»¸ö±È½ÏºÃµÄ  ÏÖÔÚ½éÉÜÒ»ÏÂ
DATEDIFF(DAY,addDate, '2010-04-23') = -1
ʲôÒâ˼ÄØ£¿ÌýÎÒÂýÂý·Ö½â
DATEDIFF  ²»ÓöàÉÙ  º¯ÊýÃû
DAY            ±È½ÏµÄÊÇʱ¼äµÄÄǸö²¿·Ö£¬·Ö±ðÓÐ Äê¡¢Ô¡¢ÈÕ¡¢Ê±¡¢·Ö¡¢Ãë¡¢ºÁÃë...
addDate    ±È½ÏµÄÊý¾Ý¿â×Ö¶Î
'2010-04-23'  ±È½ÏµÄÊý¾Ý£¬Ò²¿ÉÒÔʹ²ÎÊý
= -1           Õâ¸öÒªÏêϸ˵Ã÷Ò»ÏÂ
=   ±È½Ï·û
-1  ÄØ  Òâ˼¾ÍÊÇ   '2010-04-23'  - addDate µÄ Day ²¿·Ö = -1
²»Ã÷°×£¿ ÁôÑÔ°É £¡


Ïà¹ØÎĵµ£º

SQLÖ®¾Å SQLµÄ°²×°Óë¹ÜÀí

SQL Server °²×°×¢ÒâÊÂÏ£¡
==============================
http://www.cnblogs.com/pvistely/archive/2008/12/31/1365702.html
1. ÐèÒª.Net Framework 3.5£¬ÈôÔÚVista»ò¸ü¸ßµÄOSÉÏÐèÒª3.5 SP1µÄÖ§³Ö£¨ÔÚSQL2008°²×°µÄÇ°»á×Ô¶¯¸üа²×°£©
2. ÐèÒªWidnows PowerShellµÄÖ§³Ö,WPSÊÇÒ»¸ö¹¦Äܷdz£Ç¿´óµÄShellÓ¦Óã¬ÃüÁîÓë ......

SQL Server 2005 T SQL ÖеÄOUTPUT×Ó¾äÓï·¨

OUTPUT×Ó¾äÊÇSQL Server 2005 ÖжÔINSERT¡¢UPDATEºÍDELETEÐÂÔöµÄ£¬½ñÌì¿´¼ûÔ°×ÓÀïÓÐÈËÌáÆð(SQL2005Öзµ»ØÐ޸ĺóµÄÊý¾Ý)£¬¾ÍÔÚÕâÀï¼Ç¼һÏÂËüµÄÓï·¨¡£
 OUTPUT { DELETED | INSERTED | from_table_name }. {* | column_name } [,...n]
  &nbs ......

SQl 2005 For XMl ¼òµ¥²éѯ(Raw£¬Auto£¬Pathģʽ)(1)

 ºÜ¶àÈ˶ÔXpath¿ÉÄܱȽÏÊìϤ£¬µ«²»ÖªµÀÓÐûÓÐÖ±½Ó²Ù×÷¹ýÊý¾Ý¿â£¬ÎÒÃǶ¼ÖªµÀ ÔÚSql2005À﹫֧³ÖµÄ¼¸ÖÖ²éѯÓÐRaw£¬Auto£¬PathģʽµÈ£¬Èç¹ûÔÚ2000ÀïʹÓùý PathģʽµÄÅóÓÑÓ¦¸ÃÖªµÀ£¬ÊDz»ÈÝÒ×´¦Àí²éѯ½á¹ûµÄ£¬ÄÇôÔÚ2005Àï¶ÔÕâÒ»¿é×öÁ˺ܺõÄÌáÉý
        ÎÒÏÈÀ´½éÉÜÒ»ÏÂʲôÊÇSql¡¡F ......

SQL Óï¾ä ¼ò½é

×î½üÁ½ÌìÒ»Ö±ÔÚÕÛÌÚSQLÓï¾ä£¬Ã»°ì·¨£¬Ð´Êý¾Ý¿âµÄÐֵܸøÁËÁ½¸öÀý×ӾͲ»ÔÙ¹ÜÁË£¬¶øÇÒ×î½üÇë¼ÙÁË¡£½ñÌì¼Ó°à»¹ÊÇÕÛÌÚÕâôһ¸öÓï¾ä£¬×ÜÊDz»¶Ô£¬ÇëÀÏ´ó¿´ÁË¿´»¹ÊÇû¿´³öÃŵÀÀ´£¬ ÔÚSQLite Expert Professional ÀïÃæдµÄÓï¾ä¶¼¿ÉÒÔÖ´Ðгɹ¦£¬µ«ÊÇÔÚAndroidµÄ¹¤³ÌÀïÃæÔõôÕÛÌھͲ»¶Ô¡£ ÓôÃÆ°¡£¬½ñÌì¼Ó°àËãÊÇ°×¼ÓÁË¡£
ΪÁ˲éÕÒºÍÑ§Ï ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ