Çó sqlÖÐ selectËùÓеÄÓï¾ä¡£
ÐèÒªÇóËùÓÐselect ²éѯÓï¾ä£¬°üº¬ËùÓвéѯ¡£
select .......
from..........
where .......... and or ........
order by ..........
Õâ¸öÎÊÌâ¾ÍÏñÒªÇóÁгö½ñÍíÄܳԵÄËùÓвËÒ»Ñù£¬ÎÞ·¨Çî¾ÙµÄ
ʲôÒâ˼£¿£¿Â¥Ö÷»¹²»ÈçÈ¥¿´Áª»ú´ÔÊé
¾ÍÊÇÁоÙËùÓÐselectÓï¾ä
±ÈÈç
select union all distinct
from table1£¬tabel2£¬
where ¡£¡£¡£¡£
order by¡£¡£¡£
group by¡£¡£¡£
having¡£¡£¡£
ÀàËÆsqlÓï·¨·ÖÎöÆ÷¡£Ö»ÊÇ·ÖÎöselectÓï·¨¡£
select * from tablename
½¨ÒéÂò±¾Êé¿´~~~~~~~~~~~~
Ïà¹ØÎÊ´ð£º
¿ÉÄÜÒòΪ¹¤×÷µÄÔÒò ½Ó´¥Êý¾Ý¿âÕâ¿é±È½ÏÉÙ£¬Ö®Ç°¶¼ÊÇ×ö³ÌÐòÕâ¿é£¬Êý¾Ý¿âÕâ¿é¶¼ÓÐרÃŵÄÈËÀ´×ö ·Ö¹¤¶¼ºÜÃ÷ϸ ËùÒÔ¶ÔÊý¾Ý¿âÕâÒ»¿éÍêÈ«²»Á˽⡣ǰ¶Îʱ¼ä È¥ÃæÊÔÁ˼¸¼Ò¹«Ë¾ ¼¸ºõ¶¼ÊÇÔÚÊý¾Ý¿âÕâ¿é¹ÒµôµÄ Á¬¸ö¼òµ¥µÄSQ ......
ÎÒÃÇC#×öÒ»¸ö´°Ìå ÍùÊý¾Ý¿âÀï²åÈëÊý¾Ý
SqlConnection cn = new SqlConnection("Data Source=20090713-1752\\SQLEXPRESS;Initial Catalog=goods;Integrated Security=True");
......
select count(1) from FX_RETURNBOOKCHECKLIST fxreturnbo0_ where fxreturnbo0_.BOOKID='164 ' AND fxreturnbo0_.RETURNID='00025.S0000001'
ÉÏÃæÒ»¸ö¼òµ¥µÄSQL,Ö´ÐÐʱ¼ä2.6à ......
ÈçºÎÔÚSQL2005ÖÐÉ趨¶¨Ê±×÷Òµ£¬±ÈÈç˵¶¨Ê±ÇåÀíijЩ±íµÄÊý¾Ý£¬
»òÕßÊǶ¨Ê±µÄ½«Ä³Ð©±íµÄÊý¾Ýµ¼³öexcel£¡
ÔÚÏߵȴý£¬¼±¼±¼±£¬×îºÃÊÇÏêϸ²½Ö裡
֮ǰÎÒ×öµÄ×÷ÒµÓеãÎÊÌ⣡
°ïUP
²Î¿¼:http://hi.baidu.com/toiota ......