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

SQL SERVERÄÚÖú¯Êý


¾ÛºÏº¯ÊýÈôÒª»ã×ÜÒ»¶¨·¶Î§µÄÊýÖµ£¬ÇëʹÓÃÒÔϺ¯Êý£º
SUM
·µ»Ø±í´ïʽÖÐËùÓÐÖµµÄ×ܺ͡£
Óï·¨
SUM(aggregate)
SUM Ö»ÄÜÓë°üº¬ÊýÖµµÄ×Ö¶ÎÒ»ÆðʹÓ᣽«ºöÂÔ¿ÕÖµ¡£
AVERAGE
·µ»Ø±í´ïʽÖÐËùÓзǿÕÖµµÄƽ¾ùÖµ£¨ËãÊõƽ¾ùÖµ£©¡£
Óï·¨
AVERAGE(aggregate)
AVERAGE Ö»ÄÜÓë°üº¬ÊýÖµµÄ×Ö¶ÎÒ»ÆðʹÓ᣽«ºöÂÔ¿ÕÖµ¡£
MAX
·µ»Ø±í´ïʽÖеÄ×î´óÖµ¡£
Óï·¨
MAX(aggregate)
¶ÔÓÚ×Ö·ûÁУ¬MAX 
½«°´ÅÅÐò˳ÐòÀ´²éÕÒ×î´óÖµ¡£½«ºöÂÔ¿ÕÖµ¡£
MIN
·µ»Ø±í´ïʽÖеÄ×îСֵ¡£
Óï·¨
MIN(aggregate)
¶ÔÓÚ×Ö·ûÁУ¬MIN 
½«°´ÅÅÐò˳ÐòÀ´²éÕÒ×îСֵ¡£½«ºöÂÔ¿ÕÖµ¡£
COUNT
·µ»Ø×éÖзǿÕÏîµÄÊýÄ¿¡£
Óï·¨
COUNT(aggregate)
COUNT Ê¼ÖÕ·µ»Ø 
Int 
Êý¾ÝÀàÐÍÖµ¡£
COUNTDISTINCT
·µ»Ø×éÖÐijÏîµÄ·Ç¿Õ·ÇÖØ¸´ÊµÀýÊý¡£
Óï·¨
COUNTDISTINCT(aggregate)
STDev
·µ»ØÄ³ÏîµÄ·Ç¿ÕÖµµÄ±ê׼ƫ²î¡£
Óï·¨
STDEV(aggregate)
STDevP
·µ»ØÄ³ÏîµÄ·Ç¿ÕÖµµÄ×ÜÌå±ê׼ƫ²î¡£
Óï·¨
STDEVP(aggregate)
VAR
·µ»ØÄ³ÏîµÄ·Ç¿ÕÖµµÄ·½²î¡£
Óï·¨
VAR(aggregate)
VARP
·µ»ØÄ³ÏîµÄ·Ç¿ÕÖµµÄ×ÜÌå·½²î¡£
Óï·¨
VARP(aggregate)
Ìõ¼þº¯Êý
ÈôÒª²âÊÔÌõ¼þ£¬ÇëʹÓÃÒÔϺ¯Êý£º
IF
Èç¹ûÖ¸¶¨Á˼ÆËã½á¹ûΪ TRUE 
µÄÌõ¼þ£¬½«·µ»ØÒ»¸öÖµ£»Èç¹ûÖ¸¶¨Á˼ÆËã½á¹ûΪ 
FALSE 
µÄÌõ¼þ£¬Ôò·µ»ØÁíÒ»¸öÖµ¡£
Óï·¨
IF(condition, value_if_true, value_if_false)
Ìõ¼þ±ØÐëÊǼÆËã½á¹ûΪ TRUE 
»ò 
FALSE 
µÄÖµ»ò±í´ïʽ¡£Èç¹ûÌõ¼þΪ 
True
£¬Ôò 
Value_if_true 
±íʾ·µ»ØµÄÖµ¡£Èç¹ûÌõ¼þΪ 
False
£¬Ôò 
Value_if_false 
±íʾ·µ»ØµÄÖµ¡£
IN
È·¶¨Ä³ÏîÊÇ·ñÊǼ¯µÄ³ÉÔ±¡£
Óï·¨
IN(item, set)
Switch
¶ÔһϵÁбí´ïʽÇóÖµ²¢·µ»ØÓëÆäÖеÚÒ»¸öΪ True 
µÄ±í´ïʽÏà¹ØÁªµÄ±í´ïʽµÄÖµ¡£
Switch 
¿ÉÒÔÓÐÒ»¸ö»ò¶à¸öÌõ¼þ
/
Öµ¶Ô¡£
Óï·¨
Switch(condition1, value1)
ת»»
ÈôÒª½«Öµ´ÓÒ»ÖÖÊý¾ÝÀàÐÍת»»ÎªÁíÒ»ÖÖÊý¾ÝÀàÐÍ£¬ÇëʹÓÃÒÔϺ¯Êý£º
INT
½«Öµ×ª»»ÎªÕûÊý¡£
Óï·¨
INT(value)
DECIMAL
½«Öµ×ª»»ÎªÊ®½øÖÆÊý×Ö¡£
Óï·¨
DECIMAL(value)
FLOAT
½«Öµ×ª»»Îª float 
Êý¾ÝÀàÐÍ¡£
Óï·¨
FLOAT(value)
TEXT
½«Êýֵת»»ÎªÎı¾¡£
Óï·¨
TEXT(value)
ÈÕÆÚºÍʱ¼äº¯Êý
ÈôÒªÏÔʾÈÕÆÚ»òʱ¼ä£¬ÇëʹÓÃÒÔϺ¯Êý£º
DATE
·µ»Ø¸ø¶¨Äê¡¢Ô¡


Ïà¹ØÎĵµ£º

Sql Server»ù±¾º¯Êý

1.×Ö·û´®º¯Êý
³¤¶ÈÓë·ÖÎöÓÃ
datalength(Char_expr) ·µ»Ø×Ö·û´®°üº¬×Ö·ûÊý,µ«²»°üº¬ºóÃæµÄ¿Õ¸ñ
substring(expression,start,length) ²»¶à˵ÁË,È¡×Ó´®
right(char_expr,int_expr) ·µ»Ø×Ö·û´®ÓÒ±ßint_expr¸ö×Ö·û
×Ö·û²Ù×÷Àà
upper(char_expr) תΪ´óд
lower(char_expr) תΪСд
space(int_expr) Éú³Éint_expr¸ö¿Õ¸ñ ......

SQL ServerÈ«ÎÄË÷ÒýµÄ¸öÈË×ܽá(ÏÂ) ¹ØÓÚÖÐÎÄ·Ö´Ê


SQL ServerÈ«ÎÄË÷ÒýµÄ¸öÈË×ܽá(ÏÂ)-¹ØÓÚÖÐÎÄ·Ö´Ê
(2005-11-14 04:32:01)
×ªÔØ
 
·ÖÀࣺÉî¶ÈÑо¿
ÔÚʹÓÃSQL SearchµÄ¹ý³ÌÖУ¬»¹·¢ÏÖÁËÒ»¸öÎÊÌ⣺Ëü¶ÔÖÐÎÄ£¬Êǰ´×ִַʵģ¬ÏÂÃæÎÒ½âÊÍһϣº
±ÈÈç¶Ô'²©¿ÍÌóÉÔ±ºÜ¶àÊÇMVP'Õâ¾ä»°£¬¼ÙÈçÒ»¸ö¸öµÄ×ÖµÄ×÷Ë÷Òý£¬»á±ÈʹÓÃ'²©¿ÍÌÃ','³ÉÔ±',MVP'¼¸¸ö´Ê×÷Ë÷ÒýÉú³ÉµÄË ......

SQLÖÐcase when thenµÄʹÓÃʵÀý

¼ÙÉèÏÖÔÚNews±íÓÐÒÔÏÂ×Ö¶Î
News_Id,News_Title,News_IsSetTop,News_SetTopTime
ÆäÖÐNews_IsSetTop(char(1))ÊÇ“ÊÇ·ñÖö¥”µÄº¬Ò壻News_SetTopTime(DateTime)ÊÇÖö¥Ê±¼ä£»
ÏÖÔÚҪʵÏÖ£ºÈç¹ûNews_IsSetTopΪ"1"ʱ £¬ORDER BY News_IsSetTop DESC,News_Id DESC£»News_IsSetTopΪ"0"ʱ£¬ORDER BY News_ID DESC ......

×î¼òµ¥µÄ×î¸ßЧµÄ¹ýÂËSQL½Å±¾·À×¢Èë

.errInfo
{
    border:solid 1px #d00;
    background:#F7F0F7;
}
1.URLµØÖ··À×¢È룺
//¹ýÂËURL·Ç·¨SQL×Ö·û
var sUrl=location.search.toLowerCase();
var sQuery=sUrl.substring(sUrl.indexOf("=")+1);
re=/select|update|delete|truncate|join|union|exec|insert|drop|count|&r ......

SQL ServerÈÕÆÚ

---Ò»¸öÔµĵÚÒ»Ìì
SELECT DATEADD(mm, DATEDIFF(mm,0,getdate()), 0) 
--- ±¾ÖܵÄÐÇÆÚÒ»
SELECT DATEADD(wk, DATEDIFF(wk,0,getdate()), 0)
---Ò»ÄêµÄµÚÒ»Ìì
SELECT DATEADD(yy, DATEDIFF(yy,0,getdate()), 0)
----¼¾¶ÈµÄµÚÒ»Ìì
SELECT DATEADD(qq, DATEDIFF(qq,0,getdate()), 0)
----ÉϸöÔµÄ×îºóÒ»Ìì
......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ