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

sqlÖ´ÐÐ˳Ðò

±ê×¼µÄ sql µÄ½âÎö˳ÐòΪ: (1).from ×Ӿ䠠×é×°À´×Ô²»Í¬Êý¾ÝÔ´µÄÊý¾Ý
 (2).where ×Ӿ䠠»ùÓÚÖ¸¶¨µÄÌõ¼þ¶Ô¼Ç¼½øÐÐɸѡ
 (3).group by ×Ӿ䠠½«Êý¾Ý»®·ÖΪ¶à¸ö·Ö×é 
 (4).ʹÓþۺϺ¯Êý½øÐмÆËã
 (5).ʹÓàhaving ×Ó¾äɸѡ·Ö×é 
 (6).¼ÆËãËùÓеıí´ïʽ 
 (7).ʹÓàorder by ¶Ô½á¹û¼¯½øÐÐÅÅÐò


Ïà¹ØÎĵµ£º

SQL Server£º´æ´¢Í¼ÏñºÍBLOBÎļþ

SQL Server£º´æ´¢Í¼ÏñºÍBLOBÎļþ(Ò»)
 
×÷ÕߣºØýÃû ÎÄÕÂÀ´Ô´£ºOnegreen.Net ä¯ÀÀ´ÎÊý£º2559 ¸üÐÂʱ¼ä£º2008-5-25 23:16:09 
¡¡¡¡Ê²Ã´ÊÇBLOB
¡¡¡¡Ê×ÏÈ£¬ÎÒÃÇÀ´±È½ÏÁ½ÖÖÎļþÀàÐÍASCIIºÍ¶þ½øÖÆ¡£´æ´¢ÔÚSQL ServerÖеĴ󲿷ÖÊý¾ÝÖµ¶¼ÊÇÓÉASCII(ÃÀ¹úÐÅÏ¢½»»»±ê×¼´úÂë)×Ö·û×é³É¡£¼òµ¥ËµÀ´£¬ASCII×Ö·û¾ÍÊÇÄܹ»ÔÚ¼ ......

¹ØÓÚSQL Server·þÎñ¹ÜÀíÆ÷µÄÎÊÌâ

ÎÊÌâ: һ̨·þÎñÆ÷ÉÏÔËÐÐÁËSQL Server,SQL Server Agent,Distributed Transaction,CoordinatorÕâÈý¸ö·þÎñ£¬ÇëÎÊÕą̂·þÎñÆ÷ÊÇһ̨ʲôÑùµÄ·þÎñÆ÷£¿ÕâÈý¸ö·þÎñ¾ßÌåÓÐʲô×÷Óã¿
ÕâÊÇһ̨Êý¾Ý¿â·þÎñÆ÷.
SQL Server ÕâÊÇÖ÷Êý¾Ý¿â·þÎñ£¬¶øÇÒÐγÉÁËSQL ServerµÄÖ§Öù¡£ËüÓÃÓÚ´æ´¢ºÍÌáÈ¡Êý¾Ý¡£
SQL Server Agent Ò²½ÐSQL Server´ú ......

ÊéдSQLʱҲ»ñµÃÖÇÄÜÌáʾ

дSQLµÄ±Èд.NET³ÌÐòµÄÌåÑéÉϲîÒ»µÈ£¬Ã»ÓÐÖÇÄÜÌáʾ£¬ÐèÒª¼Çס¹Ø¼ü×Ö£¬º¯Êý»òÕß²»¶ÏµØCopy±í×Ö¶ÎÃû£¬×Ô¶¨Ò庯Êý£¬´æ´¢¹ý³ÌÖ®ÀàµÄ¡£²»¹ýÔÚ
VS2010ÖУ¬ÎÒÃÇ¿ÉÒÔʹÓÃÖÇÄÜÌáʾÁË£¬ÈçÏÂÃæ¼¸·ùͼËùʾ£º

Ôڱ༭Æ÷ÖУ¬ ÊäÈë Shift + J
£¨Ìáʾ£º VS2010 ¿ª·¢¹¤¾ßÖбêµÄÊÇ Ctrl +J ÆäʵӦ¸ÃÊÇ Shift + J £©¾Í¿ÉÒÔ×Ô¶¯´ò¿ªÕâ¸öÖÇ ......

sqlµÄ INNER JOIN, left join,right joinÓï·¨

inner join(µÈÖµÁ¬½Ó) Ö»·µ»ØÁ½¸ö±íÖÐÁª½á×Ö¶ÎÏàµÈµÄÐÐ
left join(×óÁª½Ó) ·µ»Ø°üÀ¨×ó±íÖеÄËùÓмǼºÍÓÒ±íÖÐÁª½á×Ö¶ÎÏàµÈµÄ¼Ç¼
right join(ÓÒÁª½Ó) ·µ»Ø°üÀ¨ÓÒ±íÖеÄËùÓмǼºÍ×ó±íÖÐÁª½á×Ö¶ÎÏàµÈµÄ¼Ç¼
INNER JOIN Óï·¨£º
INNER JOIN Á¬½ÓÁ½¸öÊý¾Ý±íµÄÓ÷¨£º
SELECT * from ±í1 INNER JOIN ±í2 ON ±í1.×ֶκÅ=±í2 ......

sql serverÖг£¼ûµÄº¯ÊýµÄÓ÷¨

SQL×Ö·û´®º¯Êýhttp://www.cnblogs.com/virusswb/archive/2008/09/10/1288576.html
selectÓï¾äÖÐÖ»ÄÜʹÓÃsqlº¯Êý¶Ô×ֶνøÐвÙ×÷£¨Á´½Ósql server£©£¬
select ×Ö¶Î1 from ±í1 where ×Ö¶Î1.IndexOf("ÔÆ")=1;
ÕâÌõÓï¾ä²»¶ÔµÄÔ­ÒòÊÇindexof£¨£©º¯Êý²»ÊÇsqlº¯Êý£¬¸Ä³Ésql¶ÔÓ¦µÄº¯Êý¾Í¿ÉÒÔÁË¡£
left£¨£©ÊÇsqlº¯Êý¡£
select ×Ö ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ