sql DATEPART£¨£©º¯Êý
cdateÊÇdatetimeÀàÐ͵Ä×Ö¶Î
ͳ¼ÆÒ»ÄêµÄÈçÏÂ
select datepart(yy,cdate) as 'Ô·Ý',sum(cmoney) from consumption group by datepart(yy,cdate)
ͳ¼ÆÒ»ÔµÄÈçÏÂ
select datepart(mm,cdate) as 'Ô·Ý',sum(cmoney) from consumption where datepart(yy,cdate)=2009 group by datepart(mm,cdate)
ͳ¼ÆÒ»ÖܵÄÈçÏÂ
select DATEPART(wk,cdate) as 'ÖÜ', sum(cmoney) from consumption group by DATEPART(wk,cdate)
ͳ¼ÆÒ»ÌìµÄÈçÏÂ
select DATEPART(dd,cdate) as 'ºÅ', sum(cmoney) from consumption where datepart(mm,cdate)=6 group by DATEPART(dd,cdate)
ÒÔÉÏÓõ½µÄ¾ÍÊÇ“DATEPART£¨£©”º¯Êý¡£º¯ÊýDATEPART£¨£©µÄ²ÎÊýÊÇÁ½¸ö±äÁ¿¡£µÚÒ»¸ö±äÁ¿Ö¸¶¨Òª³éÈ¡ÈÕÆÚµÄÄÄÒ»²¿·Ö£»µÚ¶þ¸ö±äÁ¿ÊÇʵ¼ÊµÄÊý¾Ý¡£
ÈÕÆÚµÄ¸÷²¿·Ö¼°Æä¼òд
ÈÕÆÚ²¿·Ö ¼òд Öµ
year yy 1753--9999
quarter qq 1--4
month mm 1--12
day of year dy 1--366
day dd 1--31
week wk &n
Ïà¹ØÎĵµ£º
參¿¼: http://blog.sina.com.cn/s/blog_59b11d010100af1n.html
ÈçºÎ»Ö¸´/ÐÞ¸´MS SQLÊý¾Ý¿âµÄMDFÎļþ
Èç¹û±¸·ÝµÄÊý¾Ý¿âÓÐ2¸öÎļþ£¬·Ö±ðÊÇ.LDF ºÍ .MDF£¬´ò¿ªÆóÒµ¹ÜÀíÆ÷£¬ÔÚʵÀýÉÏÓÒ»÷---ËùÓÐÈÎÎñ--¸½¼ÓÊý¾Ý¿â£¬È»ºóÑ¡ÔñÄǸö.MDFÎļþ£¬¾Í¿ÉÒÔÁË¡£
¡¡¡¡»òÕßÔÚ²éѯ·ÖÎöÆ÷ÖÐÊäÈ룺
¡¡¡¡sp_attach_db "Êý¾Ý¿âÃû³Æ" ......
1. Sql ÑÓʱºòÖ´ÐÐ
a. ÈýÊ®ÃëºóÖ´ÐÐ WAITFOR DELAY ºóÃæµÄÓï¾ä
WAITFOR DELAY '00:00:30'
b. 10:00·Ö¿ªÊ¼Ö´ÐкóÃæµÄ´úÂë
WAITFOR TIME '10:00';
2. ÊÕËõÊý¾Ý¿â£¬Ê¹Æä¿ÕÓà¿Õ¼äΪ0%
DBCC SHRINKDATABASE (DataBaseName,0)
3. È¡µÃÊý¾Ý¿âÎļþËùÔÚµÄÅÌ·û
declare @dirverNam ......
ÕýÔÚ¼ÓÔØÊý¾Ý...
¡¡¡¡1.°´ÐÕÊϱʻÅÅÐò: select * from TableName Order By CustomerName Collate Chinese_PRC_Stroke_ci_as
¡¡¡¡2.Êý¾Ý¿â¼ÓÃÜ: select encrypt(’ÔʼÃÜÂë’) select pwdencrypt(’ÔʼÃÜÂë’) select pwdcompare(’ÔʼÃÜÂë’,’¼ÓÃܺóÃÜÂë’) = 1--Ïàͬ£»·ñÔ ......
SQL SERVER 2005ÒýÈëÁËÔÚµ¥Ò»Á¬½ÓÉ϶Զà»î¶¯½á¹û¼¯£¨Ò²³ÆÎªMARS£©»ò¶à¸öÇëÇóµÄÖ§³Ö¡£Í¨¹ýÔÚÓëSQL SERVER 2005µÄÁ¬½ÓÉÏÆôÓÃÕâÒ»ÌØÐÔ£¬µ±´æÔÚÓëSqlconnectionÏà¹ØÁªµÄ¿ª·ÅʽSqlDataReaderʱ£¬Á¬½Ó½«²»»áÖжϡ£¼´Ê¹ÉÐδ¹Ø±Õµ±Ç°´ò¿ªµÄSqlDataReader£¬Ò²ÈÔÈ»Äܹ»ÔÚSqlconnectionÉÏÖ´ÐÐÆäËû²éѯ±ÈÈ磺SELECT£¬UPDATE£¬CREATETABL ......
ÔÚSQLÓï¾äÓÅ»¯¹ý³ÌÖУ¬ÎÒÃǾ³£»áÓõ½hint,ÏÖ×ܽáÒ»ÏÂÔÚSQLÓÅ»¯¹ý³ÌÖг£¼ûOracle HINTµÄÓ÷¨£º
1. /*+ALL_ROWS*/
±íÃ÷¶ÔÓï¾ä¿éÑ¡Ôñ»ùÓÚ¿ªÏúµÄÓÅ»¯·½·¨,²¢»ñµÃ×î¼ÑÍÌÍÂÁ¿,ʹ×ÊÔ´ÏûºÄ×îС»¯.
ÀýÈç:
SELECT /*+ALL+_ROWS*/ EMP_NO,EMP_NAM,DAT_IN from BSEMPMS WHERE EMP_NO=’SCOTT’;
2. /*+FIRST_ROWS*/
±í ......