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

SQL´úÂë¸ú×Ù²»³öÀ´

ÈçÌ⣬ÎÒ³ÌÐòǰ̨ÏúÊÛÒ»±Ê½»Ò׸¶¿îʱ»áµ¯³öÏÔʾһÅú¿ÉÓõĴÙÏúÐÅÏ¢£¬ÎÒÏëÖªµÀÕâ¸ö´ÙÏúÐÅÏ¢ÊÇʲôɸѡµÄ£¬Ê¹Óøú×ÙÆ÷Ïë²é¿´ÕâЩ´ÙÏúÐÅÏ¢ÊÇÔõôɸѡµÄ£¬µ«ÊǸú×Ù²»³öÓйØSELECTÓï¾ä»òÕß´æ´¢¹ý³Ì£¬Ö»ÊÇһЩºÍ´ÙÏúÎ޹صĶ«Î÷£¬ÇëÎÊΪʲô£¿
sql µ¥²½µ÷ÊÔ£¿£¿

²»Êǵĵ¥²½µ÷ÊÔ£¬ÊÇÓпͻ§·´Ó³½çÃæÏÔʾµÄ´ÙÏúÐÅÏ¢ÓеãС´í£¬ËùÒÔÎÒÏ뿴С´ÙÏúÐÅÏ¢Ôõô˧ѡ³öÀ´µÄ£¬Ê¹ÓÃSQL¸ú×ÙÆ÷È´¸ú²»³öÏà¹ØÓï¾ä£¬ÓôÃÆing¡«

SQL¸ú×ÙÆ÷  ÔõôÓ𡣿£¿Ñ§Ï°Ñ§Ï°

ûÈËÓöµ½¹ý¸ú²»³öÓï¾äÀ´£¿

˵Ã÷³ÌÐò³ö´íÁË£¬Ã»ÓÐÖ´Ðе½ÕâÒ»²½¡£

Èç¹ûÊÇ´æ´¢¹ý³ÌµÄ»°£¬²ÎÊý´«µÝµÄÉÙÁË»òÕß¶àÁË£¬Ò²»á²»Ö´ÐС£



ÒýÓÃ
˵Ã÷³ÌÐò³ö´íÁË£¬Ã»ÓÐÖ´Ðе½ÕâÒ»²½¡£

Èç¹ûÊÇ´æ´¢¹ý³ÌµÄ»°£¬²ÎÊý´«µÝµÄÉÙÁË»òÕß¶àÁË£¬Ò²»á²»Ö´ÐС£



³ÌÐòû´í£¬ÓдÙÏúÐÅÏ¢ÏÔʾµÄ£¬¾ÍÊǸú²»³öËüÊÇÔõôɸѡÕâЩÊý¾ÝµÄÓï¾äÀ´


Ïà¹ØÎÊ´ð£º

ÈçºÎÓÃc#£¬sql2000 ¿ª·¢c/sÏµĹ¤×÷Á÷£¿

±¾ÈËc#ÐÂÊÖ ¿ÉÊÇÒªÇóÒªÓÃc# £¬sql2000¿ª·¢c/sµÄ¹¤×÷Á÷£¬Ò»Í·ÎíË®£¬Çë´ó¼Ò°ïæ°ï棬¸øµã˼·£¬ËµµÄÔ¼¾ßÌåÔ½ºÃ£¬ÎÒÒ²ºÃÍùÄǸö·½ÃæÈ¥Ñ§Ï°
http://www.hxzi.com/view/61402.html
B/S°æµÄ£¬»ù±¾Ë¼ÏëÓ¦¸Ã²î²»¶àµÄ¡£¡£ ......

ÇóSQL£¿

´ó¼ÒºÃ£¬ÇëÎÊÔÚ±íMÖÐÓÐ×ֶΣºa b c d e 
ÎÒÏë²é³öÆäÖÐÂú×ãÏÂÃæÈÎÒâÒ»ÏîµÄÊý¾Ý£¬1.×Ö¶Îa µÄÖµ²»ÊÇ ¡®Êé»ò±Ê»ò±¾¡¯ÖÐÈÎÒ»£¬2.aΪÊéµÄʱºò×Ö¶Îb,cÊÇ¿Õ;3.µ±aֵΪ±ÊµÄʱºòdÊÇ¿Õ;4.µ±aΪ±¾µÄʱºòb,d,e¶¼ÊÇ¿Õ;5.È ......

SQLÓï¾äÎÊÌ⣬¸ßÊÖ°ïæ£¡£¡

½«Ò»¸ö±í21~30ɾ³ý£¬sqlÓï¾äÔõôд
Õâ¸öÌ«ÁýͳÁË£¬ÊÇÅÅÐòºóµÄµÚ21Ìõµ½30Ìõ¼Ç¼ɾ³ý»¹ÊÇijһÁÐÖµÔÚ21µ½30Ö®¼äµÄɾ³ý°¡£¿

21-30ÊÇʲôÒâ˼£¿×ֶεϰ¾Ídelete from table1 where col1>=21 and col1<=30
Ö¸µ ......

C#ÈçºÎÅжÏÁ¬½Ósql serverÊý¾Ý¿â³É¹¦£¿

C#ÈçºÎÅжÏÁ¬½Ósql serverÊý¾Ý¿â³É¹¦£¿
try
{
connection.connect()
return true;
}
catch()
{
return false;
}

Â¥Ö÷ºÜ׿±£¬¿ªÁ˼¸ÌùÁË¡£

ÒýÓÃ
try
{
connection.connect( ......

²ËÄñÌáÎÊ£¬Çó¼òµ¥sql ?



±íA

Sup_code    st_sup_code    buy_code      buy_code1 
1001        400            &nbs ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ