SQL´úÂë¸ú×Ù²»³öÀ´
ÈçÌ⣬ÎÒ³ÌÐòǰ̨ÏúÊÛÒ»±Ê½»Ò׸¶¿îʱ»áµ¯³öÏÔʾһÅú¿ÉÓõĴÙÏúÐÅÏ¢£¬ÎÒÏëÖªµÀÕâ¸ö´ÙÏúÐÅÏ¢ÊÇʲôɸѡµÄ£¬Ê¹Óøú×ÙÆ÷Ïë²é¿´ÕâЩ´ÙÏúÐÅÏ¢ÊÇÔõôɸѡµÄ£¬µ«ÊǸú×Ù²»³öÓйØSELECTÓï¾ä»òÕß´æ´¢¹ý³Ì£¬Ö»ÊÇһЩºÍ´ÙÏúÎ޹صĶ«Î÷£¬ÇëÎÊΪʲô£¿
sql µ¥²½µ÷ÊÔ£¿£¿
²»Êǵĵ¥²½µ÷ÊÔ£¬ÊÇÓпͻ§·´Ó³½çÃæÏÔʾµÄ´ÙÏúÐÅÏ¢ÓеãС´í£¬ËùÒÔÎÒÏ뿴С´ÙÏúÐÅÏ¢Ôõô˧ѡ³öÀ´µÄ£¬Ê¹ÓÃSQL¸ú×ÙÆ÷È´¸ú²»³öÏà¹ØÓï¾ä£¬ÓôÃÆing¡«
SQL¸ú×ÙÆ÷ ÔõôÓ𡣿£¿Ñ§Ï°Ñ§Ï°
ûÈËÓöµ½¹ý¸ú²»³öÓï¾äÀ´£¿
˵Ã÷³ÌÐò³ö´íÁË£¬Ã»ÓÐÖ´Ðе½ÕâÒ»²½¡£
Èç¹ûÊÇ´æ´¢¹ý³ÌµÄ»°£¬²ÎÊý´«µÝµÄÉÙÁË»òÕß¶àÁË£¬Ò²»á²»Ö´ÐС£
³ÌÐòû´í£¬ÓдÙÏúÐÅÏ¢ÏÔʾµÄ£¬¾ÍÊǸú²»³öËüÊÇÔõôɸѡÕâЩÊý¾ÝµÄÓï¾äÀ´
Ïà¹ØÎÊ´ð£º
ÏÖÔÚÓÐÁ½¸öÒì¹¹µÄsql serverÊý¾Ý¿â,ÎÒÏ뽫µÚÒ»¸ö±íÖеÄÊý¾Ýµ¼Èëµ½µÚ¶þ¸ö±íÖÐ,×Ô¼ºÖ¸¶¨µ¼ÈëÊý¾ÝµÄ×Ö¶Î,ÈçºÎµ¼ÈëÊý¾ÝÄØ,´ó¼ÒÌÖÂÛÒ»ÏÂ?
dts¹¤¾ß
µ¼Èëµ¼³ö¹¤¾ß.
DD
¹þ¹þ£¬¹À¼ÆÕâλÊǵØQIOU¶¼Êܲ»Á˵Ä
Ö±½ÓÐ ......
Ö´ÐеÄ˳Ðò£º
1£©Îļþä¯ÀÀ¿ò£¨Ñ¡ÔñÎļþʹÓã©
Ñ¡ÔñºÃÎļþºó
µã»÷Ò»¸öµ¼Èë°´Å¥µÄʱºò £¬°ÑÉÏÃæÉÏ´«¿òÀïµÄcsvÎļþÒÔÒ»¸öIDΪÎļþÃû£¬ÉÏ´«µ½**/**Îļþ¼ÐÏÂ
2£©¶ÁÈ¡Õâ¸öÎļþ¼ÐϵÄcsvµÄÎļþ£¬×ª»»³Ésql
3 ......
ÓÐ×Ö¶Î
ÈÕÆÚ£¬id
ÈÕÆÚ²»Öظ´£¬id ÓÐÖØ¸´
ÐèҪɸѡ³ö ÿ¸öidÀïÃæÈÕÆÚ×îÔçµÄÊý¾Ý¡£
SQL code:
select * from ±í t where not exists(select 1 from ±í where t.ÈÕÆÚ>ÈÕÆÚ and id=t.id)
SQL ......
C#ÈçºÎÅжÏÁ¬½Ósql serverÊý¾Ý¿â³É¹¦£¿
try
{
connection.connect()
return true;
}
catch()
{
return false;
}
Â¥Ö÷ºÜ׿±£¬¿ªÁ˼¸ÌùÁË¡£
ÒýÓÃ
try
{
connection.connect( ......
Êý¾Ý±í¡¾biao¡¿£¬
×ֶΣºid¡¢myname¡¢mytxt
mytxtÄÚÈݸñʽÐÎÈ磺n|abcd¡££¨ÀýÈ磺1|ÁõµÂ»ª£¬2|Èδﻪ£¬3|αÌϼ£¬4|Âõ¿Ë@½Ü¿ËÑ·£©
ÎÒÏÖÔÚÏ£Íû¶Á¼Ç¼³öÀ´ºó£¬°´ÕÕ[mytxt]×Ö¶ÎÀïµÄÊúÏߣ¨|£©Ç°ÃæµÄÄǸöÊý× ......