SQLÓï¾äЧÂÊÎÊÌâµÄ¼¸µã×ܽá
1. SQLÓÅ»¯µÄÔÔòÊÇ£º
½«Ò»´Î²Ù×÷ÐèÒª¶ÁÈ¡µÄBLOCKÊý¼õµ½×îµÍ,¼´ÔÚ×î¶ÌµÄʱ¼ä´ïµ½×î´óµÄÊý¾ÝÍÌÍÂÁ¿¡£
µ÷Õû²»Á¼SQLͨ³£¿ÉÒÔ´ÓÒÔϼ¸µãÇÐÈ룺
¼ì²é²»Á¼µÄSQL£¬¿¼ÂÇÆäд·¨ÊÇ·ñ»¹ÓпÉÓÅ»¯ÄÚÈÝ
¼ì²é×Ó²éѯ ¿¼ÂÇSQL×Ó²éѯÊÇ·ñ¿ÉÒÔÓüòµ¥Á¬½ÓµÄ·½Ê½½øÐÐÖØÐÂÊéд
¼ì²éÓÅ»¯Ë÷ÒýµÄʹÓÃ
¿¼ÂÇÊý¾Ý¿âµÄÓÅ»¯Æ÷
2. ±ÜÃâ³öÏÖSELECT * from table Óï¾ä£¬ÒªÃ÷È·²é³öµÄ×ֶΡ£
3. ÔÚÒ»¸öSQLÓï¾äÖУ¬Èç¹ûÒ»¸öwhereÌõ¼þ¹ýÂ˵ÄÊý¾Ý¿â¼Ç¼Խ¶à£¬
¶¨Î»Ô½×¼È·£¬Ôò¸ÃwhereÌõ¼þÔ½Ó¦¸ÃÇ°ÒÆ¡£
4. ²éѯʱ¾¡¿ÉÄÜʹÓÃË÷Òý¸²¸Ç¡£¼´¶ÔSELECTµÄ×ֶν¨Á¢¸´ºÏË÷Òý£¬
ÕâÑù²éѯʱֻ½øÐÐË÷ÒýɨÃ裬²»¶ÁÈ¡Êý¾Ý¿é¡£
5. ÔÚÅжÏÓÐÎÞ·ûºÏÌõ¼þµÄ¼Ç¼ʱ½¨Òé²»ÒªÓÃSELECT COUNT £¨*£©ºÍselect top 1 Óï¾ä¡£
6. ʹÓÃÄÚ²ãÏÞ¶¨ÔÔò£¬ÔÚÆ´Ð´SQLÓï¾äʱ£¬½«²éѯÌõ¼þ·Ö½â¡¢·ÖÀ࣬
²¢¾¡Á¿ÔÚSQLÓï¾äµÄ×îÀï²ã½øÐÐÏÞ¶¨£¬ÒÔ¼õÉÙÊý¾ÝµÄ´¦ÀíÁ¿¡£
7. Ó¦¾ø¶Ô±ÜÃâÔÚorder by×Ó¾äÖÐʹÓñí´ïʽ¡£
8. Èç¹ûÐèÒª´Ó¹ØÁª±í¶ÁÊý¾Ý£¬¹ØÁªµÄ±íÒ»°ã²»Òª³¬¹ý7¸ö¡£
9. СÐÄʹÓà IN ºÍ OR£¬ÐèҪעÒâIn¼¯ºÏÖеÄÊý¾ÝÁ¿¡£½¨Ò鼯ºÏÖеÄÊý¾Ý²»³¬¹ý200¸ö¡£
10. <> Óà < ¡¢ > ´úÌæ£¬>ÓÃ>=´úÌæ£¬<ÓÃ<=´úÌæ£¬ÕâÑù¿ÉÒÔÓÐЧµÄÀûÓÃË÷Òý¡£
11. ÔÚ²éѯʱ¾¡Á¿¼õÉÙ¶Ô¶àÓàÊý¾ÝµÄ¶ÁÈ¡°üÀ¨¶àÓàµÄÁÐÓë¶àÓàµÄÐС£
12. ¶ÔÓÚ¸´ºÏË÷ÒýҪעÒ⣬ÀýÈçÔÚ½¨Á¢¸´ºÏË÷ÒýʱÁеÄ˳ÐòÊÇF1£¬F2£¬F3£¬
ÔòÔÚwhere»òorder by×Ó¾äÖÐÕâЩ
Ïà¹ØÎĵµ£º
¡¡¡¡ÎÒ¾³£Åöµ½ÓÐÈË»áÎÊһЩÊý¾Ý¿âÓÅ»¯·½ÃæµÄÎÊÌ⣬ÎÒ¾õµÃÕâÊÇÒ»×î»ù±¾¼¼ÄÜÒªÇó£¬ÌرðÊÇʹÓÃsql server 2005£¬¶ÔÓÚsql serverµÄÓÅ»¯£¬Ê¹ÓõÄרְdba»ò¼æÖ°dbaÃǹ¤×÷¸üÇáËÉ£¬Ð§Âʸü¸ßÁË£¬µ«ÊÇ»¹ÊÇÓкܶàÐÂÈË¿ÉÄܲ»´óÁ˽⣬ÎÒÔÚÕâ¶ùдһÏÂ×î»ù±¾µÄһЩ½éÉÜ¡£
¡¡¡¡Ò»¡¢Ê×ÏȽéÉÜÒ»ÏÂsql server 2005ÖÐÓÅ»¯Êý¾ÝʱʹÓõ½µÄÁ½¸ö¹¤ ......
--> Title : SQL Server2005 SynonymµÄʹÓÃ
--> Author : wufeng4552
--> Date : 2009-10-30
1.SynonymµÄ¸ÅÄî
¡¡ Synonym£¨Í¬Òå´Ê£©ÊÇSQL Server 2005µÄÐÂÌØÐÔ¡£¿ÉÒÔ¼òµ¥µÄÀí½âSynonymΪÆäËû對ÏóµÄ±ðÃû¡£
語·¨
CREATE SYNONYM [ schema_name_1. ] synonym_name FOR & ......
Ò».×¢ÊÍ
-- µ¥ÐÐ×¢ÊÍ£¬´ÓÕâµ½±¾ÐнáÊøÎª×¢ÊÍsql Óï·¨£¬ÀàËÆC++£¬c#ÖÐ//
/* ¡ */ ¶àÐÐ×¢ÊÍ£¬ÀàËÆC++£¬C#ÖÐ/* ¡ */
¶þ.±äÁ¿£¨int£¬ smallint£¬ tinyint£¬ decimal£¬float£¬real£¬ money £¬smallmoneysql Óï·¨£¬ text £¬image£¬ char£¬ varchar¡£¡£¡£¡£¡£¡££©
Óï·¨£º
DECLARE
&nb ......
Ê×Ïȸø³öÁ½ÕŲâÊÔ±í
a(aid int, adata varchar(20)) b(bid int, bdata varchar(20))
1.join Óë inner join
Ö´ÐÐÈçÏÂÓï¾ä£º
select * from a join b on a.aid = b.bid;
ÎÒÃÇ»áµÃµ½ÈçϵĽá¹û£º
AID ADAT ......
SQLÓï¾äÀàËÆstring.Format()×é×°±äÁ¿µÄʹÓá£
Ò»°ãÀ´Ëµ£¬ÎÒÃÇ»áÔÚ³ÌÐòÔËÐÐÆÚ¼ä½«ËùÒªÔËÐеÄÃüÁîÓï¾ä×éºÏ³ÉÒ»¸ö×Ö·û´®£¬È»ºóʹÓÃEXECUTEÃüÁî»òϵͳ´æ´¢¹ý³Ì
@0sp_executesqlÀ´ÔËÐС£½ñÌ죬ÎÒÃǽ«À´Ïêϸ̽ÌÖÕâÁ½ÖÖ·½·¨¸÷×ÔµÄÓÅÁӵ㡣
(Ò») ʹÓÃEXECUTEÃüÁîÔËÐÐÃüÁî×Ö·û´®
ҪʹÓÃEXECUTEÃüÁîÀ´ÔËÐÐÒ»¸öÃüÁî×Ö·û´®µÄÓï·¨ÈçÏ ......