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

sql ±¸Íü

**************************************
****     sql  ²éѯ±¸Íü                                    ****
**************************************
Ò»£ºÍâÁ¬½Ó£º
1¡¢×óÍâÁ¬½Ó£¨°Ñjoin×ó±ß±íÀïµÄËùÓÐÊý¾Ý¶¼²é³öÀ´¡£È»ºó°Ñjoin Óұ߱íÖеķûºÏÌõ¼þµÄÊý¾Ý¼ÓÔÚ×ó±ß±íµÄºóÃæ¡£¡£¡£¡££©
SELECT *  from t_empl_info as a  LEFT OUTER JOIN t_dept as b 
ON  a.dept_no=b.dept_id
--ͨ³£Çé¿öÏÂÊÇ£º×ó±ß±íÊǶ෽±í¡£Óұ߱íÊÇÒ»·½±í
--ÈýÕűíµÄ×óÍâÁ¬½Ó
 SELECT *
   from A left join  B
   on A.a=B.a
  left join C on B.b = C.b;


Ïà¹ØÎĵµ£º

sqlÐÐתÁÐ


дһ¸ö´æ´¢¹ý³Ì£¬½«±íÒ»°´ÕÕ±í¶þµÄÐÎʽ½øÐвéѯ¡£
²Ö¿âÃû³Æ ÉÌÆ·Ãû³Æ ÊýÁ¿
A
S001 12
A S002 17
A
S003 10
B S001 21
B
S002 5
B S003 ......

java¡¢C#ÖÐSqlÓï¾ä´«²ÎµÄд·¨¼°ÒâÒå

 SqlserverÕâ¶«Î÷ûÉÙ¸úËû´ò½»µÀ,¸Õѧ¿ª·¢ÓïÑÔʱ¾ÍÒѾ­¸úËû½Ó´¥ÁË,²»ÒªËµºÜ¾«Í¨,µ«¾ÍÓï·¨»¹ËãÊÇÊìϤ,µ«ÏÖÔÚ¿ªÊ¼Ð´C#,·¢ÏÖºÜC#¶àÁËÒ»ÖÖSqlServerµÄ²ÎÊý´«È뷽ʽ,ÒÔÍùÎÒÃdz£³£¶ÔÒª´«²ÎµÄSqlÓï¾ä¶¼ÊÇÖ±½Óͨ¹ýÆ´´ÕSqlÓï¾äµÄ·½Ê½À´ÊµÏÖ,µ«ÏÖÔÚC#ΪʲôҪרÃÅ×öÒ»¸öSql²ÎÊýµÄÀàÀ´ÊµÏÖÄØ,¾­¹ý²éÕÒ²ÅÖªµÀ,ÕâÑù×öÊÇÓеÀÀíµÄ,Ò»Ê ......

×Ô¼º×ܽáµÄ²»¶¨Ìõ¼þSQL²éѯÓï¾äµÄд·¨

  ÎÒ˵µÄ²»¶¨Ìõ¼þÊÇÖ¸²éѯÌõ¼þµÄ¸öÊý²»¶¨¡£ÓÐʱһ¸ö£¬ÓÐʱÁ½¸ö£¬ÓÐʱºÃ¼¸¸ö¡£
Ê×ÏÈÎÒ·¢ÏÖ
select * from A where a='kkk' Óë
select * from A where a like 'kkk'
ÆäʵЧ¹ûÊÇÒ»Ñù£¬Ö»Òª like ºóÃæµÄ×Ö·û´®²»°üº¬Í¨Åä·û¡£ÕâÑùÒ»À´¾ÍºÜ·½±ãÁË¡£Æ©ÈçÓÐ
select * from A where a='KKK' and b='LLL'
ÓÐÁ½¸ö²éѯÌõ¼þ£¬ ......

asp.net½«sqlÊý¾Ýµ¼³öexcel±í¸ñ(´úsql×Ö¶ÎÃû)

protected void Button1_Click(object sender, EventArgs e)
{
string strsql = "select * from TreeViewTemp where parentID=0";
DataTable dt = db.GetDataTable(strsql);
StringWriter sw = new StringWriter();
//StreamWriter sw = new Strea ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ