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

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

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

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

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

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

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

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



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

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



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


Ïà¹ØÎÊ´ð£º

Á½¸öµ¼¹¹sql serverÊý¾Ý¿â,Êý¾Ýµ¼Èëµ¼³öÎÊÌâ

ÏÖÔÚÓÐÁ½¸öÒì¹¹µÄsql serverÊý¾Ý¿â,ÎÒÏ뽫µÚÒ»¸ö±íÖеÄÊý¾Ýµ¼Èëµ½µÚ¶þ¸ö±íÖÐ,×Ô¼ºÖ¸¶¨µ¼ÈëÊý¾ÝµÄ×Ö¶Î,ÈçºÎµ¼ÈëÊý¾ÝÄØ,´ó¼ÒÌÖÂÛÒ»ÏÂ?
dts¹¤¾ß

µ¼Èëµ¼³ö¹¤¾ß.

DD

¹þ¹þ£¬¹À¼ÆÕâλÊǵØQIOU¶¼Êܲ»Á˵Ä

Ö±½ÓÐ ......

csvÎļþת»»³Ésqlµ¼Èëµ½Êý¾Ý¿â£¬Ã»ÓÐÊý¾ÝΪºÎ£¿

Ö´ÐеÄ˳Ðò£º
1£©Îļþä¯ÀÀ¿ò£¨Ñ¡ÔñÎļþʹÓã©
Ñ¡ÔñºÃÎļþºó
µã»÷Ò»¸öµ¼Èë°´Å¥µÄʱºò £¬°ÑÉÏÃæÉÏ´«¿òÀïµÄcsvÎļþÒÔÒ»¸öIDΪÎļþÃû£¬ÉÏ´«µ½**/**Îļþ¼ÐÏÂ
2£©¶ÁÈ¡Õâ¸öÎļþ¼ÐϵÄcsvµÄÎļþ£¬×ª»»³Ésql
3 ......

Çë½ÌÒ»¸ösqlÊý¾ÝɸѡÎÊÌâ

ÓÐ×Ö¶Î
ÈÕÆÚ£¬id

ÈÕÆÚ²»Öظ´£¬id ÓÐÖØ¸´

ÐèҪɸѡ³ö ÿ¸öidÀïÃæÈÕÆÚ×îÔçµÄÊý¾Ý¡£
SQL code:
select * from ±í t where not exists(select 1 from ±í where t.ÈÕÆÚ>ÈÕÆÚ and id=t.id)

SQL ......

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

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

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

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

sqlÓï¾äÖÐÄܲ»ÄÜÕâÑùÅÅÐò£¿

Êý¾Ý±í¡¾biao¡¿£¬
×ֶΣºid¡¢myname¡¢mytxt
mytxtÄÚÈݸñʽÐÎÈ磺n|abcd¡££¨ÀýÈ磺1|ÁõµÂ»ª£¬2|Èδﻪ£¬3|αÌϼ£¬4|Âõ¿Ë@½Ü¿ËÑ·£©

ÎÒÏÖÔÚÏ£Íû¶Á¼Ç¼³öÀ´ºó£¬°´ÕÕ[mytxt]×Ö¶ÎÀïµÄÊúÏߣ¨|£©Ç°ÃæµÄÄǸöÊý× ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ