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

SQLServer ά»¤Ë÷ÒýʵÏÖ²éѯÓÅ»¯

Ë÷Òý·ÖΪÁ½´óÀà:¾Û¼¯Ë÷ÒýºÍ·Ç¾Û¼¯Ë÷Òý
Ò»¡¢¾Û¼¯Ë÷Òý
µ±Êý¾Ý±íÖеÄÒ»Áб»È·¶¨ÎªÖ÷¼üºó,SQLServer»á×Ô¶¯ÎªËü½¨Á¢¾Û¼¯Ë÷Òý,ÒòΪ¾Û¼¯Ë÷ÒýÊDZêʶÿ¸ö¼Ç¼Ðеļü,ËùÒÔËü½«±»Ó¦Óõ½Ã¿¸ö²éѯÖÐ.
¶þ¡¢·Ç¾Û¼¯Ë÷Òý
·Ç¾Û¼¯Ë÷ÒýµÄÇé¿ö¾Í±È½Ï¸´ÔÓÁË,ÒòΪËüÊÇÏà¶ÔÓÚ±í¶ÀÁ¢×éÖ¯µÄ,ÔÚSQLServerÖÐÓе¥¶ÀµÄ½á¹¹À´´æ´¢·Ç¾Û¼¯Ë÷Òý.
 
ÓÐÒ»µãÊÇҪעÒâµÄ,²»Òª´úÌæ²éѯÓÅ»¯Æ÷È¥Ö¸¶¨Ä³¸öË÷Òý,DBAÓ¦¸ÃÏë°ì·¨±ÜÃâÓÅ»¯Æ÷²»Ê¹ÓÃË÷Òý½øÐвéѯ:
1¡¢¸ßËéƬÂÊ
µ±Ë÷ÒýËéƬÂʳ¬¹ý40%µÄʱºò,ÓÅ»¯Æ÷»á·ÅÆúʹÓÃË÷Òý,ÒòΪÔÚËéƬÂÊÈç´Ë¸ßµÄË÷ÒýÖÐɨÃèÊý¾Ý»¹²»ÈçÖ±½Óµ½±íÖÐȥɨÃè.
DBAÓ¦¸Ã³£³£¼àÊÓË÷ÒýËéƬÂÊ,µ±´ïµ½30%µÄʱºò¾ÍÒª¿¼ÂÇÖØÐÂ×éÖ¯Ë÷Òý
2¡¢Î¨Ò»ÐÔ
Èç¹ûÒ»¸öË÷Òý²»ÊÇΨһË÷Òý,ÄÇôÓÅ»¯Æ÷»áÈÏΪֱ½Óµ½Êý¾Ý±íÖÐɨÃè±ÈʹÓÃÕâ¸öË÷ÒýµÄЧÂÊÒª¸ß
3¡¢²éѯÖÐʹÓÃÁ˺¯Êý
µ±²éѯÖÐʹÓÃÁ˺¯Êýʱ,ÔÚ¸ÃÁÐÉϽ¨Á¢µÄË÷ÒýÊDz»»á±»Ê¹ÓõÄ.
ÀýÈç:col½¨Á¢ÁËË÷Òý,µ«ÊÇÔÚ²éѯÖÐʹÓÃÁË convert(nvarchar,col)=’test’,Õâʱ²éѯÓÅ»¯Æ÷²»»áʹÓøÃË÷Òý
4¡¢²éѯ´íÎóµÄ×Ö¶Î
Èç¹û½¨Á¢×éºÏ×ֶεÄË÷Òý,ÄÇôֻÓе±µÚÒ»¸öÁб»²éѯʹÓÃʱ,¸ÃË÷Òý²Å»á±»Ê¹ÓÃ
ÀýÈç:½¨Á¢Ò»¸öË÷Òý(col1,col2,col3),µ±²éѯÖÐʹÓÃcol2=’test’ʱË÷Òý²»»á±»Ê¹ÓÃ.Ö»ÓÐcol1=’test’ÕâÑùµÄ²éѯ,Õâ¸öË÷Òý²Å»á±»Ê¹ÓÃ
Èç¹ûÄãÏë¶Ôcol3²éѯʱʹÓÃË÷Òý,ÄÇôֻÄܽ¨Á¢Á½¸öË÷Òý,Ò»¸ö½¨Á¢ÔÚcol1ÉÏ,ÁíÒ»¸ö½¨Á¢ÔÚcol3ÉÏ
 
ÁíÍâÒ»¸öҪעÒâµÄÊÇ,·Ç¾Û¼¯Ë÷ÒýÓë¾Û¼¯Ë÷Òý²»Í¬,¾Û¼¯Ë÷ÒýÌî³äÒò×ÓΪ100%²¢ÇÒûÓÐËéƬ,ÒòΪÊý¾Ýʱ˳Ðò×·¼ÓµÄ.·Ç¾Û¼¯Ë÷ÒýÒª¿¼Âǵ½Êý¾ÝÌî³äʱ,Ë÷ÒýÒ³Ìî³äÒò×Ó.
ÔÚÖؽ¨Ë÷Òýʱ»¹Òª¸ù¾ÝÇ°Ò»½×¶ÎµÄ¼àÊÓÖØÐÂÉ趨Ìî³äÒò×Ó.Ò»°ãµÄÇé¿öÊÇ70%-80%,ÎÒ×îµÍʹÓùý65%µÄÌî³äÒò×Ó.


Ïà¹ØÎĵµ£º

Öؽ¨ SQLServer Ë÷ÒýµÄÖØÒªÐÔ!


Ô­ÎÄת×Ô:http://dev.csdn.net/develop/article/71/71778.shtm
 
´ó¶àÊýSQL Server±íÐèÒªË÷ÒýÀ´Ìá¸ßÊý¾ÝµÄ·ÃÎÊËٶȣ¬Èç¹ûûÓÐË÷Òý£¬SQL ServerÒª½øÐбí¸ñɨÃè¶ÁÈ¡±íÖеÄÿһ¸ö¼Ç¼²ÅÄÜÕÒµ½Ë÷ÒªµÄÊý¾Ý¡£Ë÷Òý¿ÉÒÔ·ÖΪ´ØË÷ÒýºÍ·Ç´ØË÷Òý£¬´ØË÷Òýͨ¹ýÖØÅűíÖеÄÊý¾ÝÀ´Ìá¸ßÊý¾ÝµÄ·ÃÎÊËٶȣ¬¶ø·Ç´ØË÷ÒýÔòͨ¹ýά»¤±íÖеÄÊý ......

18¾ä»°ÈëÃÅSQLServer XML

18¾ä»°ÈëÃÅSQLServer XML ÊÕ²Ø
/*
sql xml ÈëÃÅ:
    --by jinjazz
    --http://blog.csdn.net/jinjazz
   
    1¡¢xml:        ÄÜÈÏʶԪËØ¡¢ÊôÐÔºÍÖµ
   
    2¡¢xpath: ......

£¨×ª£©SqlserverºÏ²¢¸´ÖƵÄwebͬ²½Ïê½â(ת΢ÈíÈýƪ)2


ÈçºÎΪ Web ͬ²½ÅäÖà IIS
¸üÐÂÈÕÆÚ£º 2006 Äê 12 Ô 12 ÈÕ
±¾Ö÷ÌâÖеĹý³ÌÊÇΪºÏ²¢¸´ÖÆÅäÖà Web ͬ²½µÄµÚ¶þ¸ö²½Öè¡£Ó¦ÔÚΪ Web ͬ²½ÆôÓ÷¢²¼ºóÖ´Ðд˲½Öè¡£ÓйØÅäÖùý³ÌµÄ¸ÅÊö£¬Çë²ÎÔÄ ÅäÖà Web ͬ²½¡£Íê³É±¾Ö÷ÌâÖеĹý³Ìºó£¬Çë¼ÌÐøÖ´ÐеÚÈý¸ö²½Öè“ÅäÖö©ÔÄÒÔʹÓà Web ͬ²½”¡£ÏÂÁÐÖ÷ÌâÖн«½éÉܵÚÈý¸ö²½Öè£ ......

SQLServer ×î³£ÓõÄË÷Òý×Ö¶Î(ͨÓÃË÷Òý×Ö¶Î)

Ò»¡¢SQLServer ͨÓÃË÷Òý×Ö¶Î
 
1¡¢Primary Key's Ö÷¼ü
2¡¢Foreign Key's Íâ¼ü
3¡¢Ö§³ÖSELECT¡¢INSERT¡¢UPDATEºÍDELETEÃüÁîµÄ×ֶΠ:
(1)¡¢INNER JOIN
(£²)¡¢RIGHT | LEFT OUTER JOIN
(£³)¡¢WHERE
(£´)¡¢ORDER BY
(£µ)¡¢GROUP BY
(£¶)¡¢HAVING
¶þ¡¢´´½¨Ë÷ÒýµÄÆäËûÒòËØ(Ö÷ÒªÒòËض¼ÒòΪË÷ÒýÊÇÊý¾Ý±íÍⲿ ......

sqlserver 2000×öÅÅÃûº¯Êý

sqlserver 2000ÅÅÃûº¯Êý
Ãû´ÎÉú³É·½Ê½1,Öظ´Ê±ºÏ²¢Ãû´Î
SELECT *¡¡,¡¡Place=(SELECT COUNT(DISTINCT Score) +1 from jh03 WHERE Score >= a.Score)
from jh03 a
ORDER BY Place
 Ãû´ÎÉú³É·½Ê½2 , Öظ´Ê±±£ÁôÃû´Î¿Õȱ
SELECT * , Place=(SELECT COUNT(Score) from jh03 WHERE Score > a.Score) + 1
from j ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ