sql ³£ÓÃ
¹«Ë¾×éÖ¯SQLˮƽ¿¼ÊÔ£¬¿´ÁËд½Ì²Ä£¬Ð´Á˵ã×ܽᷢÉÏÀ´¸ú´ó¼Ò·ÖÏí¡£
ÎÒ¹«Ë¾Ê¹ÓõÄÊÇSybase ASE12.5£¬ËùÒÔÏÂÃæµÄһЩÌØÐÔÊÇÕë¶ÔSybase ASEµÄ¡£
Ò»£ºSQL Bisic
1£ºSQL(Structured Quary Language)ÌØÐÔ£º
a£º±ê×¼»¯
b£º·Ç¹ý³Ì»¯µÄ
c£º¿ÉÓÅ»¯µÄ
d£ºÃæÏò¼¯ºÏ²Ù×÷µÄ
2£ºASEÖеÄÊý¾ÝÀàÐÍ
a£ºNumberic
b£ºCharacter
c£ºDate/Time
d£ºLobs
3: convert(varchar, textColumn),Èç¹û²»Ö¸¶¨varchar(n)nÄÇôĬÈÏÊÇ30
4£ºwhere ÔÚsqlÖеÄ×÷ÓÃ
a£º¹ýÂËÊý¾Ý
b£º×ö±íÁ¬½Ó(sql92ÒÔÇ°)
c£ºÑ¡ÔñË÷Òý
5£ºwhare ºÍ havingµÄÇø±ð
whereÓï¾ä°Ñ¹ýÂ˺õÄÊý¾Ý²åÈëµ½work tableÖÐ
havingÓï¾ä´Ówork tableÖжÔÊý¾Ý½øÐÐÔÚ¹ýÂËÒԵõ½×îºóµÄ½á¹û¡£
6£ºÒ»¸öselectÓï¾äµÄÖ´ÐÐ˳Ðò
a£ºfrom clause
b£ºwhere clause
c£ºgroup by clause
d£ºselect clause
e£ºhaving clause
f£ºorder by clause
7£ºUnion VS Union All
a£ºUnion »á°ÑÁ½¸ö½á¹û¼¯ÅÅÐò£¬²¢ÇÒ³ýÈ¥Öظ´µÄÔªËØ£¨Ð§ÂʲÇáÒײ»ÒªÓã©
b£ºUnion All½ö½öÊÇ°ÑÁ½¸ö½á¹û¼¯ºÏ²¢£¬Ã»ÓÐÅÅÐò£¬Ò²²»È¥³ýÖظ´ÔªËØ£¨Ð§Âʺã©
¶þ£ºË÷ÒýºÍ²éѯ²ÎÊý
1£ºASEÖÐÓÐÈýÖÖaccessÊý¾Ý·½Ê½
a£ºclustered Index
b£ºnonclustered Index
c£ºtable scan
2£ºCovered Query
Ò»¸öCovered Query ½ö½ö´ÓË÷ÒýÖеõ½Êý¾Ý£¬²»ÓÃȥɨÃèÊý¾Ý¿â±í£¬ÕâÊÇ×î¿ìµÄÊý¾Ý²éѯ·½Ê½¡£
ÏÞÖÆ1£ºÖ»ÄÜÔÚseleceÖÐÉúЧ
ÏÞÖÆ2£ºËùÓб»ÒýÓõÄÁбØÐëÔÚͬһ¸önonclustered indexÖÐ
3£ºfunctional index
ÔÚASE15.0ÒÔºó²Å±»Ö§³Ö£¬Ò²¾ÍÊÇ˵ÔÚASE15.0ÒÔÇ°µÄ°æ±¾£¬ÏÂÁÐÓï¾äÊǿɶ¨²»»áÓÃÉÏË÷ÒýµÄ
sql ´úÂë
select column1
from table1
where upper(column2) = 'IVANL'
4£ºÈçºÎ²é¿´Ö´Ðмƻ®
sql ´úÂë
set showplan on
go
your sql
go
set showplan off
go
5: ÈçºÎ²é¿´IO
sql ´úÂë
set statistics io on
set statistics time on
go
you sql
go
set statistics io off
set statistics time off
go
6£ºÊ¹ÓÃIndexµÄ½¨Òé
a£ºÊ¹ÓÃÄÇЩ¾³£ÔÚwhereÓï¾äÖÐʹÓõÄ×Ö¶Î×öindex
b
Ïà¹ØÎĵµ£º
SqlserverÕⶫÎ÷ûÉÙ¸úËû´ò½»µÀ,¸Õѧ¿ª·¢ÓïÑÔʱ¾ÍÒѾ¸úËû½Ó´¥ÁË,²»ÒªËµºÜ¾«Í¨,µ«¾ÍÓï·¨»¹ËãÊÇÊìϤ,µ«ÏÖÔÚ¿ªÊ¼Ð´C#,·¢ÏÖºÜC#¶àÁËÒ»ÖÖSqlServerµÄ²ÎÊý´«È뷽ʽ,ÒÔÍùÎÒÃdz£³£¶ÔÒª´«²ÎµÄSqlÓï¾ä¶¼ÊÇÖ±½Óͨ¹ýÆ´´ÕSqlÓï¾äµÄ·½Ê½À´ÊµÏÖ,µ«ÏÖÔÚC#ΪʲôҪרÃÅ×öÒ»¸öSql²ÎÊýµÄÀàÀ´ÊµÏÖÄØ,¾¹ý²éÕÒ²ÅÖªµÀ,ÕâÑù×öÊÇÓеÀÀíµÄ,Ò»Ê ......
1.SQL SERVERµÄÊý¾ÝÀàÐÍ
¡¡¡¡Êý¾ÝÀàŪÊÇÊý¾ÝµÄÒ»ÖÖÊôÐÔ£¬±íʾÊý¾ÝËù±íʾÐÅÏ¢µÄÀàÐÍ¡£ÈκÎÒ»ÖÖ¼ÆËã»úÓïÑÔ¶¼¶¨ÒåÁË×Ô¼ºµÄÊý¾ÝÀàÐÍ¡£µ±È»£¬²»Í¬µÄ³ÌÐòÓïÑÔ¶¼¾ßÓв»Í¬µÄÌص㣬Ëù¶¨ÒåµÄÊý¾ÝÀàÐ͵ĸ÷ÀàºÍÃû³Æ¶¼»ò¶à»òÉÙÓÐЩ²»Í¬¡£SQLServer ÌṩÁË 25 ÖÖÊý¾ÝÀàÐÍ£º
¡¡¡¡·Binary [(n)]
¡¡¡¡·Varbinary [(n)]
¡¡ ......
ÔÚSQL SERVER 2005/2008ÖÐÓµÓÐÒ»¸ö¶ÔÏó
´ÓSQL SERVER2000Éý¼¶µ½2005/2008ºó£¬Ò»¸öÎÒÃDZØÐëÖØÐÂÈÏʶµÄÇé¿öÊǶÔÏó²»ÔÙÓÐËùÓÐÕߣ¨owner£©¡£¼Ü¹¹°üº¬¶ÔÏ󣬼ܹ¹ÓÐËùÓÐÕß¡£Èç¹ûÄã²éѯ±ísys.objects£¬Ä㽫»á¿´µ½Õâ¿´ÆðÀ´ÊÇÕýÈ·µÄ£¬Ö»ÊDZíÖл¹ÓÐÒ»¸ö×Ö¶Îprincipal_id£¬µ«ÊÇÒ»°ãÇé¿öÏÂËü×ÜÊÇNULLÖµ¡£²»¾ÃÇ°Ò»Ì죬ÎÒͻȻ¶Ôprincipal ......
**************************************
**** sql ²éѯ±¸Íü &nb ......
sql server ´´½¨Ë÷Òý
http://54laobaixing.blog.163.com/blog/static/57843681200952411133121/
SQL SERVERË÷Òý,ÓÅ»¯
http://tieba.baidu.com/f?kz=170889655
Sybase SQL ServerË÷ÒýµÄʹÓúÍÓÅ»¯
http://www.yesky.com/79/211079.shtml ......