sql—datediff º¯Êý
DATEDIFF
·µ»Ø¿çÁ½¸öÖ¸¶¨ÈÕÆÚµÄÈÕÆÚºÍʱ¼ä±ß½çÊý¡£
Ò»¡¢ Óï·¨
DATEDIFF ( datepart , startdate , enddate )
¶þ¡¢²ÎÊý
datepart
Êǹ涨ÁËÓ¦ÔÚÈÕÆÚµÄÄÄÒ»²¿·Ö¼ÆËã²î¶îµÄ²ÎÊý¡£Ï±íÁгöÁË Microsoft® SQL Server™ ʶ±ðµÄÈÕÆÚ²¿·ÖºÍËõд¡£
ÈÕÆÚ²¿·Ö Ëõд
year yy, yyyy
quarter qq, q
Month mm, m
dayofyear dy, y
Day dd, d
Week wk, ww
Hour hh
minute mi, n
second ss, s
millisecond ms
startdate
ÊǼÆËãµÄ¿ªÊ¼ÈÕÆÚ¡£startdate ÊÇ·µ»Ø datetime »ò smalldatetime Öµ»òÈÕÆÚ¸ñʽ×Ö·û´®µÄ±í´ïʽ¡£
ÒòΪ smalldatetime Ö»¾«È·µ½·ÖÖÓ£¬ËùÒÔµ±Óà smalldatetime ֵʱ£¬ÃëºÍºÁÃë×ÜÊÇ 0¡£
Èç¹ûÄúÖ»Ö¸¶¨Äê·ÝµÄ×îºóÁ½Î»Êý×Ö£¬ÔòСÓÚ»òµÈÓÚ"Á½Î»ÊýÄê·Ý½ØÖ¹ÆÚ"ÅäÖÃÑ¡ÏîµÄÖµµÄ×îºóÁ½Î»Êý×ÖµÄÊý×ÖËùÔÚÊÀ¼ÍÓë½ØÖ¹ÄêËùÔÚÊÀ¼ÍÏàͬ¡£´óÓÚ¸ÃÑ¡ÏîµÄÖµµÄ×îºóÁ½Î»Êý×ÖµÄÊý×ÖËùÔÚÊÀ¼ÍΪ½ØÖ¹ÄêËùÔÚÊÀ¼ÍµÄÇ°Ò»¸öÊÀ¼Í¡£ÀýÈ磬Èç¹û two digit year cutoff Ϊ 2049£¨Ä¬ÈÏ£©£¬Ôò 49 ±»½âÊÍΪ 2049£¬2050 ±»½âÊÍΪ 1950¡£Îª±ÜÃâÄ£ºý£¬ÇëʹÓÃËÄλÊýµÄÄê·Ý¡£
enddate
ÊǼÆËãµÄÖÕÖ¹ÈÕÆÚ¡£enddate ÊÇ·µ»Ø datetime »ò smalldatetime Öµ»òÈÕÆÚ¸ñʽ×Ö·û´®µÄ±í´ïʽ¡£
Èý¡¢·µ»ØÀàÐÍ
integer
ËÄ¡¢Ó÷¨
´Ëº¯Êý¼ÆËãÁ½¸öÖ¸¶¨ÈÕÆÚÖ®¼äÈÕÆÚ²¿·ÖµÄÊýÄ¿¡£½á¹ûΪÈÕÆÚ²¿·Ö
Ïà¹ØÎĵµ£º
create PROCEDURE pagelist
@tablename nvarchar(50),
@fieldname nvarchar(50)='*',
@pagesize int output,--ÿҳÏÔʾ¼Ç¼ÌõÊý
@currentpage int output,--µÚ¼¸Ò³
@orderid nvarchar(50),--Ö÷¼üÅÅÐò
@sort int,--ÅÅÐò·½Ê½£¬1±íʾÉýÐò£¬0±íʾ½µÐòÅÅÁÐ
......
Microsoft SQL Server2005¼¼ÊõÄÚÄ»:T-SQL³ÌÐòÉè¼Æ
http://www.amazon.cn/mn/detailApp/ref=sr_1_25?_encoding=UTF8&s=books&qid=1261538877&asin=B0011C2568&sr=8-25
Microsoft SQL Server 2005¼¼ÊõÄÚÄ»£º²éѯ¡¢µ÷ÕûºÍÓÅ»¯
http://www.amazon.cn/mn/detailApp/ref=sr_1_4?_encoding=UTF8&s=books&am ......
µÚÒ»²½:ÏÂÔØ°²×°Oracle 10g Release 2 ¿Í»§¶ËÈí¼þ,ÏÂÔØÁ¬½ÓÊÇ:
http://download.oracle.com/otn/nt/oracle10g/10201/10201_database_win32.zip
ÏÂÔغó°²×°
µÚ¶þ²½:ÏÂÔØ°²×°Oracle ODAC,ÏÂÔØÁ¬½ÓÊÇ:
http://download.oracle.com/otn/other/ole-oo4o/ODAC1020221.exe
µÚÈý²½: ÖØÆôMS SQ ......
1. GROUP BY ÊÇ·Ö×é²éѯ, Ò»°ã GROUP BY ÊǺ;ۺϺ¯ÊýÅäºÏʹÓÃ
group by ÓÐÒ»¸öÔÔò,¾ÍÊÇ select ºóÃæµÄËùÓÐÁÐÖÐ,ûÓÐʹÓþۺϺ¯ÊýµÄÁÐ,±ØÐë³öÏÖÔÚ group by ºóÃ棨ÖØÒª£©
ÀýÈç,ÓÐÈçÏÂÊý¾Ý¿â±í£º
A B
1 abc
1 bcd
1 asdfg
Èç¹ûÓÐÈ ......
LINQ to SQL ÐÔÄÜ 10 Tips
http://www.cnblogs.com/worksguo/archive/2008/06/04/1213075.html
Ç°Ò»ÖÜ£¬ÎÒµÄÓ²ÅÌÓÐÁ½·ÖÇø»µÁË£¬ÎÒ×¼±¸µÄÎÄÕÂÓë×ÊÁ϶¼ÔÚÀïÃ棬ËùÒÔLINQµÄÎÄÕÂÍ£ÁËÒ»¶Îʱ¼ä£¬ÕæµÄÌ«²»ºÃÀ£¬ÎªÀ´ÃÖ²¹Ò»Ï¾ÍÏÈ·¢ÕâƪÎÄÕÂÉÏÀ£¬Ã÷ÌìÔÙһƪ¹ØÓÚDisconnection DataµÄÎÄÕ¡£
Ö»²»¹ýÐҺã¬ÔÚÕ⼸ÌìÖÐÎҽ߾¡È«Á¦ ......