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
·µ»Ø¸ø¶¨Äê¡¢Ô¡
Ïà¹ØÎĵµ£º
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´úÀíÍê³ÉÒ»¸ö×÷Òµºó£¬Í¨Öª²Ù×÷Ô±µÄ·½·¨ÓжàÖÖ¡£
ÀýÈ磬ͨ¹ýÃüÁîϵͳ°ÑÏàÓ¦µÄÏûϢдÈëWindows NTʼþÈÕÖ¾ÖУ¬ÒÔ±ã֪ͨϵͳ¹ÜÀíÔ±·´¸´¶ÁÈ¡´ËÈÕÖ¾¡£
ÁíÍâÒ»ÖÖ¸üºÃµÄÑ¡Ôñ¾ÍÊÇʹÓõç×ÓÓʼþ¡¢´«ºô»ú»òÍøÂç´«ËͰѾ¯±¨ÏûϢ֪ͨ¸ø²Ù×÷Ô±¡£²Ù×÷Ô±ÊÇSQL Server´úÀí·¢ËÍÏûÏ¢µÄ½ÓÊÕÕߣ¬²Ù×÷Ô±¿ÉÒÔÔÚÒ»¸ö×÷ҵ֮ǰ ......
SQL ServerÈ«ÎÄË÷ÒýµÄ¸öÈË×ܽá(ÏÂ)-¹ØÓÚÖÐÎÄ·Ö´Ê
(2005-11-14 04:32:01)
×ªÔØ
·ÖÀࣺÉî¶ÈÑо¿
ÔÚʹÓÃSQL SearchµÄ¹ý³ÌÖУ¬»¹·¢ÏÖÁËÒ»¸öÎÊÌ⣺Ëü¶ÔÖÐÎÄ£¬Êǰ´×ִַʵģ¬ÏÂÃæÎÒ½âÊÍһϣº
±ÈÈç¶Ô'²©¿ÍÌóÉÔ±ºÜ¶àÊÇMVP'Õâ¾ä»°£¬¼ÙÈçÒ»¸ö¸öµÄ×ÖµÄ×÷Ë÷Òý£¬»á±ÈʹÓÃ'²©¿ÍÌÃ','³ÉÔ±',MVP'¼¸¸ö´Ê×÷Ë÷ÒýÉú³ÉµÄË ......
--Óï ¾ä ¹¦ ÄÜ
--Êý¾Ý²Ù×÷
SELECT --´ÓÊý¾Ý¿â±íÖмìË÷Êý¾ÝÐкÍÁÐ
INSERT --ÏòÊý¾Ý¿â±íÌí¼ÓÐÂÊý¾ÝÐÐ
DELETE --´ÓÊý¾Ý¿â±íÖÐɾ³ýÊý¾ÝÐÐ
UPDATE --¸üÐÂÊý¾Ý¿â±íÖеÄÊý¾Ý
--Êý¾Ý¶¨Òå
CREATE TABLE --´´½¨Ò»¸öÊý¾Ý¿â±í
DROP TABLE --´ÓÊý¾Ý¿âÖÐɾ³ý±í
ALTER TABLE --ÐÞ¸ÄÊý¾Ý¿â±í½á¹¹
CREATE VIEW --´´½¨Ò»¸öÊÓͼ
DRO ......
½øÈësql*plusÐèÒªÊäÈëÓû§Ãû¡¢¿ÚÁîºÍÖ÷»ú±êÖ¾·û
system/manager
sys/change_on_intall
scott/tiger
internal/oracle
ÒÔÉÏΪ³õʼÃÜÂë
Ö÷»ú×Ö·û´®¿Õ»òÕßÊÇ@+ÄãµÄ·þÎñÃû,ÔÚ±¾µØµÇ½²»ÐèÒª±¾µØ·þÎñÃû¡£
ÏÂÃæ¾Í½éÉÜÒ»ÏÂһЩ³£ÓõÄsql*plusÃüÁ
Ê×ÏȲ鿴µ±Ç°Ê¹ÓõÄÊý¾Ý¿âʵÀý:
select name from V$database;
Çл»Á½¸ö ......