SQL UNION ºÍUNION ALL ²Ù×÷·û
SQL UNION ²Ù×÷·û
UNION ²Ù×÷·ûÓÃÓںϲ¢Á½¸ö»ò¶à¸ö SELECT Óï¾äµÄ½á¹û¼¯¡£
Çë×¢Ò⣬UNION ÄÚ²¿µÄ SELECT Óï¾ä±ØÐëÓµÓÐÏàͬÊýÁ¿µÄÁС£ÁÐÒ²±ØÐëÓµÓÐÏàËÆµÄÊý¾ÝÀàÐÍ¡£Í¬Ê±£¬Ã¿Ìõ SELECT Óï¾äÖеÄÁеÄ˳Ðò±ØÐëÏàͬ¡£
SQL UNION Óï·¨
SELECT column_name(s) from table_name1
UNION
SELECT column_name(s) from table_name2
×¢ÊÍ£ºÄ¬Èϵأ¬UNION ²Ù×÷·ûѡȡ²»Í¬µÄÖµ¡£Èç¹ûÔÊÐíÖØ¸´µÄÖµ£¬ÇëʹÓà UNION ALL¡£
SQL UNION ALL Óï·¨
SELECT column_name(s) from table_name1
UNION ALL
SELECT column_name(s) from table_name2
ÁíÍ⣬UNION ½á¹û¼¯ÖеÄÁÐÃû×ÜÊǵÈÓÚ UNION ÖеÚÒ»¸ö SELECT Óï¾äÖеÄÁÐÃû¡£
ÏÂÃæµÄÀý×ÓÖÐʹÓõÄÔʼ±í£º
Employees_China:
E_IDE_Name
01
Zhang, Hua
02
Wang, Wei
03
Carter, Thomas
04
Yang, Ming
Employees_USA:
E_IDE_Name
01
Adams, John
02
Bush, George
03
Carter, Thomas
04
Gates, Bill
ʹÓà UNION ÃüÁî
ʵÀý
ÁгöËùÓÐÔÚÖйúºÍÃÀ¹úµÄ²»Í¬µÄ¹ÍÔ±Ãû£º
SELECT E_Name from Employees_China
UNION
SELECT E_Name from Employees_USA
½á¹û
E_Name
Zhang, Hua
Wang, Wei
Carter, Thomas
Yang, Ming
Adams, John
Bush, George
Gates, Bill
×¢ÊÍ£ºÕâ¸öÃüÁîÎÞ·¨ÁгöÔÚÖйúºÍÃÀ¹úµÄËùÓйÍÔ±¡£ÔÚÉÏÃæµÄÀý×ÓÖУ¬ÎÒÃÇÓÐÁ½¸öÃû×ÖÏàͬµÄ¹ÍÔ±£¬ËûÃǵ±ÖÐÖ»ÓÐÒ»¸öÈ˱»ÁгöÀ´ÁË¡£UNION ÃüÁîÖ»»áѡȡ²»Í¬µÄÖµ¡£
UNION ALL
UNION ALL ÃüÁîºÍ UNION ÃüÁºõÊǵÈЧµÄ£¬²»¹ý UNION ALL ÃüÁî»áÁгöËùÓеÄÖµ¡£
SQL Statement 1
UNION ALL
SQL Statement 2
ʹÓà UNION ALL ÃüÁî
ʵÀý£º
ÁгöÔÚÖйúºÍÃÀ¹úµÄËùÓеĹÍÔ±£º
SELECT E_Name from Employees_China
UNION ALL
SELECT E_Name from Employees_USA
½á¹û
E_Name
Zhang, Hua
Wang, Wei
Carter, Thomas
Yang, Ming
Adams, John
Bush, George
Carter, Thomas
Gates, Bill
ÔÌûµØÖ·£ºhttp://www.w3school.com.cn/sql/sql_union.asp
Ïà¹ØÎĵµ£º
¸Õ¸Õ×°ÁËSQL2008£¬ÅäÖÃÁËһϣ¬ÔÚÍøÉÏÕÒµ½Õâ¸ö½Ì³Ì£¬¾õµÃ²»´í£¬×ªÔØÑ§Ï°
1¡¢ ¸ü¸ÄTCP/IPÁ¬½ÓΪÆôÓÃ
2¡¢ µÇ¼ £¬ ÐÞ¸Ä2¸öµØ·½
a) Éí·ÝÑéÖ¤·½Ê½£¨»ìºÏģʽ£©
ͼһ£ºÊ×ÏÈʹÓÃwindowsÉí·ÝµÇ¼£¨×¢Ò⣬ ·þÎñÆ÷Ãû³Æ±ØÐëÌîдÕýÈ·£©
  ......
http://msdn.microsoft.com/zh-cn/library/bb546187.aspx
http://www.cnblogs.com/kirinboy/archive/2010/01/20/linq-to-sql-update-1.html
¡¾ÒýÎÄ¡¿
ÔÚѧϰLINQʱ£¬ÎÒ¼¸ºõ±»Ò»¸öÀ§ÄÑËù»÷µ¹£¬Õâ¾ÍÊÇÄã´Ó±êÌâÖп´µ½µÄ¸üÐÂÊý¾Ý¿âµÄ²Ù×÷¡£ÏÂÃæÎÒ¾ÍÒ»²½²½´øÄã×ßÈëÕâÄà̶£¬Çë×¼±¸ºÃשͷºÍ¿ÚË®£¬Follow me¡£
´Ó×î¼òµ¥µÄÇé¿öÈë ......
Óû§È¨ÏÞ¹ÜÀí
Ò»¡¢·þÎñÆ÷µÇ¼ÕʺźÍÓû§ÕʺŹÜÀí
1.SQL Server·þÎñÆ÷µÇ¼¹ÜÀí
²»¹ÜʹÓÃÄÄÖÖÈÏ֤ģʽ£¬Óû§¶¼±ØÐëÏȾ߱¸ÓÐЧµÄÓû§µÇ¼Õʺš£SQL ServerÓÐÈý¸öĬÈϵÄÓû§µÇ¼Õʺţº¼´sa¡¢Builtin\administratorsºÍguest¡£saÊÇϵͳ¹ÜÀíÔ±(system administrator)µÄ¼ò³Æ£¬ÊÇÒ»¸öÌØÊâµÄÓû§£¬ÔÚSQL ServerϵͳºÍËùÓÐÊý¾Ý¿âÖÐÓ ......
SQL Server 2005ÆôÓÃsaÕ˺Å
ÆôÓÃsaÓû§ºÍÔ¶³ÌÁ¬½Ó
²Ëµ¥Start->Microsoft SQL Server 2005->Configuration Tools->SQL Server Configuration Manager
Ñ¡ÖÐSQL Server 2005 Network Configuration
ÔÚÓұߵÄTCP/IPÉϵãÓÒ¼ü£¬enabled
²Ëµ¥Start->Microsoft SQL Server 2005->SQL ......
Student(S#,Sname,Sage,Ssex) ѧÉú±í
Course(C#,Cname,T#) ¿Î³Ì±í
SC(S#,C#,score) ³É¼¨±í
Teacher(T#,Tname) ½Ìʦ±í
ÎÊÌ⣺
1¡¢²éѯ“001”¿Î³Ì±È“002”¿Î³Ì³É¼¨¸ßµÄËùÓÐѧÉúµÄѧºÅ£»
select a.S# from (select s#,score from SC where C#='001') a,(sele ......