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

SQLº¯Êý´óÈ«

¾ÛºÏº¯Êý
MAX(×Ö¶Î)      
Çóij×Ö¶ÎÖеÄ×î´óÖµ
MIN(×Ö¶Î)
    
Çóij×Ö¶ÎÖеÄ×îСֵ
AVG(×Ö¶Î)
     
Çóij×Ö¶ÎÖÐµÄÆ½¾ùÖµ
SUM(×Ö¶Î)
    
Çóij×Ö¶ÎÖеÄ×ܺÍ
COUNT(×Ö¶Î) 
ͳ¼ÆÄ³×ֶηǿռͼÊý
COUNT
(*)       
ͳ¼Æ¼Í¼Êý
 
¾ÛºÏº¯ÊýÁ·Ï°
²éѯProducts±í£¬ËùÓÐUnitPriceÖ®ºÍ
²éѯProducts±í£¬ËùÓиßÓÚ50µÄUnitPriceÖ®ºÍ
²éѯProducts±í£¬ËùÓÐUnitPrice֮ƽ¾ùÖµ
²éѯCustomers±í£¬¹²ÓжàÉÙCustomer
²éѯCustomers±í£¬¹²ÓжàÉÙCountry
²éѯProducts±í£¬UnitPriceµÄ×î´óÖµ
 
 
ÈÕÆÚº¯Êý
GETDATE()
×÷Ó㺻ñÈ¡µ±Ç°ÈÕÆÚʱ¼ä
DATEPART(datepart ,
date)
×÷Ó㺻ñÈ¡ÈÕÆÚ»òʱ¼äµÄÒ»²¿·Ö¡£ÓÐÁ½¸ö²ÎÊý£¬date´ú±íÒª±»²Ù×÷µÄÈÕÆÚ¡£datepart´ú±íÒª»ñ
È¡µÄ²¿·Ö¡£
DATEDIFF(datepart , startdate ,
enddate)
×÷Ó㺱ȽÏÁ½¸öÈÕÆÚijһ²¿·ÖµÄ²îÖµ£¬
ͨ³£startdate´ú±í½ÏÔçµÄÈÕÆÚ , enddate´ú±í½ÏÍíµÄ
DATEADD (datepart , number,
date)
×÷ÓãºÔÚdate»ù´¡ÉϼÓÉÏÒ»¶Îʱ¼ä
YEAR(date)
µÈ¼ÛÓÚDATEPART(year , date)
MONTH(date)
µÈ¼ÛÓÚDATEPART(month , date)
DAY(date)
µÈ¼ÛÓÚDATEPART(day , date)
 
Datepart Abbr.
year yy, yyyy
quarter   
qq, q
month     
mm, m
dayofyear        
dy, y
day  
dd, d
weekday  dw
hour hh
minute    
mi, n
second    
ss, s
millisecond      
ms
ËÄÉáÎåÈë±£ÁôÁ½Î»Ð¡Êý
print
Round(5.5678,2)
ÏòÏÂÈ¡Õû
print Floor(1.9)
ÏòÉÏÈ¡Õû
print Ceiling(2.1)
create
table
score
(stuId int,
 ps int,
 jm int
)
insert into score values(1,99,54)
insert into score values(1,85,43)
insert into score values(1,92,71)
select
stuId,ceiling(ps*0.35+jm*0.65)
from Score
print
rand()*100
CHARINDEX
·µ»Ø×Ö·û´®ÖÐÖ¸¶¨±í´ïʽµÄÆðʼλÖá£
Óï·¨
CHARINDEX ( expression_r1 , expression_r2 [ , start_location ]
)
print charindex('hello','gsfjhellokjhellosa',7)
REPLACE
ÓÃ


Ïà¹ØÎĵµ£º

SQL ServerÊý¾Ý²Ö¿âÏà¹Ø¸ÅÄî ά¶È±íºÍÊÂʵ±í¸ÅÊö

SQL ServerÊý¾Ý²Ö¿âÏà¹Ø¸ÅÄî-ά¶È±íºÍÊÂʵ±í¸ÅÊö ÊÕ²Ø
¿ªÊ¼Ñо¿BI£¬³õѧ¡£»á¼Ç¼һЩ¸ÅÄîÐÔµÄÎÄÕ¡£
»ù±¾¸ÅÄ
1.¶àάÊý¾Ý¼¯£º¶àάÊý¾Ý¼¯ÊÇÁª»ú·ÖÎö´¦Àí (OLAP) ÖеÄÖ÷Òª¶ÔÏó£¬ÊÇÒ»Ïî¿É¶ÔÊý¾Ý²Ö¿âÖеÄÊý¾Ý½øÐпìËÙ·ÃÎʵļ¼Êõ¡£¶àάÊý¾Ý¼¯ÊÇÒ»¸öÊý¾Ý¼¯ºÏ£¬Í¨³£´ÓÊý¾Ý²Ö¿âµÄ×Ó¼¯¹¹Ô죬²¢×éÖ¯ºÍ»ã×ܳÉÒ»¸öÓÉÒ»×éά¶ÈºÍ¶ÈÁ ......

×î¼òµ¥µÄSQL ServerÊý¾Ý¿â´æ´¢¹ý³Ì·ÖÒ³


×î¼òµ¥µÄSQL ServerÊý¾Ý¿â´æ´¢¹ý³Ì·ÖÒ³
 
·¢²¼Ê±¼ä£º2008.07.02 05:11     À´Ô´£ºÈüµÏÍø    ×÷ÕߣºAlizze
¡¾ÈüµÏÍø£­IT¼¼Êõ±¨µÀ¡¿×î¼òµ¥µÄSQL ServerÊý¾Ý¿â´æ´¢¹ý³Ì·ÖÒ³:
1.Ö»ÐèÒªÌṩSqlÓï¾äºÍÿҳµÄ¼Ç¼Êý,Ò³Êý¾Í¿ÉÒÔÁË
2,Ëٶȳ¬¿ìÓ´,100W¼Ç¼1~3Ãë¾Í·Ö³öÀ´ÁË
......

sql2005ÖÐÒ»¸öxml¾ÛºÏµÄÀý×Ó

sql2005ÖÐÒ»¸öxml¾ÛºÏµÄÀý×Ó ÊÕ²Ø
¸ÃÎÊÌâÀ´×ÔÂÛ̳ÌáÎÊ£¬ÑÝʾSQL´úÂëÈçÏÂ
--½¨Á¢²âÊÔ»·¾³
set nocount on
create table test(ID varchar(20),NAME varchar(20))
insert into test select '1','aaa'
insert into test select '1','bbb'
insert into test select '1','ccc'
insert into test select '2','ddd'
inser ......

sqlÁÙʱ±í:SQL ServerÖеÄÁÙʱ±íºÍ±í±äÁ¿

ÔÚSQL ServerµÄÐÔÄܵ÷ÓÅÖУ¬ÓÐÒ»¸ö²»¿É±ÈÄâµÄÎÊÌ⣺ÄǾÍÊÇÈçºÎÔÚÒ»¶ÎÐèÒª³¤Ê±¼äµÄ´úÂë»ò±»Æµ·±µ÷ÓõĴúÂëÖд¦ÀíÁÙʱÊý¾Ý¼¯?±í±äÁ¿ºÍÁÙʱ±íÊÇÁ½ÖÖÑ¡Ôñ¡£
¡¡¡¡ÔÚSQL ServerµÄÐÔÄܵ÷ÓÅÖУ¬ÓÐÒ»¸ö²»¿É±ÈÄâµÄÎÊÌ⣺ÄǾÍÊÇÈçºÎÔÚÒ»¶ÎÐèÒª³¤Ê±¼äµÄ´úÂë»ò±»Æµ·±µ÷ÓõĴúÂëÖд¦ÀíÁÙʱÊý¾Ý¼¯?±í±äÁ¿ºÍÁÙʱ±íÊÇÁ½ÖÖÑ¡Ôñ¡£¼ÇµÃÔÚ¸øÒ»¼Ò ......

¡¾×ª¡¿ ÓÃEXPLAIN PLAN ·ÖÎöSQLÓï¾ä

ÓÃEXPLAIN PLAN ·ÖÎöSQLÓï¾ä
http://blog.csdn.net/kj021320/archive/2006/08/19/1096021.aspx
ÈçºÎÉú³Éexplain plan?
¡¡¡¡½â´ð:ÔËÐÐutlxplan.sql. ½¨Á¢plan ±í
¡¡¡¡Õë¶ÔÌØ¶¨SQLÓï¾ä£¬Ê¹Óà explain plan set statement_id = 'tst1' into plan_table
¡¡¡¡ÔËÐÐutlxplp.sql »ò utlxpls.sql²ì¿´explain plan
EXPLAIN PLA ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ