SQLÓï¾ä OR ´æ´¢¹ý³Ì£¿ - .NET¼¼Êõ / C#
Ö´ÐÐÊý¾Ý¿â²Ù×÷ʱ£¬Ö±½ÓÓÃSQL Óï¾äºÃһЩ »¹ÊÇÓô洢¹ý³Ì¸ü¼ÑÄØ£¿ ¸÷ÊãÆð¼û
Õâ¸öµÄ¾ßÌåÎÊÌâ¾ßÌå·ÖÎö ¼òµ¥µÄselect ¡¢updateºÍinsertµ±È»sql½â¾öÁË ¸´ÔӵķÅÔÚsql·þÎñ¶ËÓ¦¸ÃºÃµã Â¥Ö÷Çë²ÎÔÄ http://msdn.microsoft.com/zh-cn/library/ms973918(v=MSDN.10).aspx ÄÜÓÃsqlÓï¾äʵÏֵIJ»ÒªÓô洢¹ý³Ì£¬¸´ÔӵŦÄܺÍÂß¼¹ØϵÓô洢¹ý³Ì ·ÀÖ¹sql×¢ÈëÊý¾Ý²ÎÊý»¯ »ù´¡Ôöɾ¸Ä²éÓÃSQLÓï¾ä£¬ ¶ÔÓÚ¸´ÔÓÒµÎñ£¬Ê¹Óô洢¹ý³Ì£¬¶Ô¸´ÔÓ²éѯҲ¿ÉÒÔʹÓÃÊÓͼ ÓÅÐãÓë·ÇÓÅÐãÖ®·Ö ´æ´¢¹ý³Ì±È½ÏºÃ£¬ÒòΪ´æ´¢¹ý³ÌÊÇÔ¤ÏȱàÒëºÃµÄ£¬Ö´ÐÐËٶȸü¿ì£¬¶øÇÒ¸ü°²È«£¬¿ÉÒÔÓÐЧµÄ·ÀÖ¹sql×¢Èë ×îºÃ»¹ÊÇʹÓô洢¹ý³ÌÕâÑù¿ÉÒÔ£¬ÕâÑù×öµÄϵͳÒÆÖ²ÐÔ»¹ÊDZȽϺõġ£ ʹÓô洢¹ý³ÌµÄÓŵ㻹ÊDZȽ϶àµÄ£¬·ÀÖ¹sql×¢È룬¼õÇáÁË·þÎñµÄ¸ºµ£µÈ¡£ ¸Ã˵µÄÂ¥É϶¼ËµÁË.... ¶¥ÉÏÈ¥£¬ËûÃǶ¼ËµµÄÓеÀÀí¡¡ ¸öÈËÒ²ÕâôÈÏΪ¡£ ¸´ÔÓ µ÷Óô洢¹ý³Ì ¼òµ¥ Ö±½ÓÓÃsqlÓï¾ä½øÐвÙ×÷ ´Ó¼ò£¬Ò²·½±ãÐÞ¸Ä ¾ßÌåÎÊÌâ¾ßÌå·ÖÎö ÎÒ»¹ÊǾõµÃsqlÓï¾ä¸üºÃÓà Õâ¸öÒª¿´¾ßÌåµÄÇé¿öÁË ´æ´¢¹ý³ÌÏûºÄµÄÊÇ·þÎñÆ÷×ÊÔ´£¬ÎÒÒ»°ãϲ»¶ÓÃsql°ÑÊý¾Ý´Ó·þÎñ¶ËÈ¡¹ýÀ´ÔÚ¿Í»§¶Ë½øÐи´ÔÓÂß¼´¦Àí£¬±Ï¾¹·þÎñÆ÷»¹ÊÇÖ´Ðмòµ¥µÄselect¸üºÃ£¬ÕâÑùÄܹ»¸üºÃ·¢»Ó¿Í»§¶ËµÄÔËËãÄÜÁ¦¡£ ËùÒÔÎÒ¾õµÃÈç¹ûûÓбØÒª£¬×îºÃ»¹ÊDz»ÒªÓô洢¹ý³Ì¡£ À´Ñ§Ï°Ñ§Ï°£¡ÒýÓà Õâ¸öÒª¿´¾ßÌåµÄÇé¿öÁË ÓÐÀíÒýÓà ÄÜÓÃsqlÓï¾äʵÏֵIJ»ÒªÓô洢¹ý³Ì£¬¸´ÔӵŦÄܺÍÂß¼¹ØϵÓô洢¹ý³Ì ·ÀÖ¹sq
Ïà¹ØÎÊ´ð£º
¿ÉÄÜÒòΪ¹¤×÷µÄÔÒò ½Ó´¥Êý¾Ý¿âÕâ¿é±È½ÏÉÙ£¬Ö®Ç°¶¼ÊÇ×ö³ÌÐòÕâ¿é£¬Êý¾Ý¿âÕâ¿é¶¼ÓÐרÃŵÄÈËÀ´×ö ·Ö¹¤¶¼ºÜÃ÷ϸ ËùÒÔ¶ÔÊý¾Ý¿âÕâÒ»¿éÍêÈ«²»Á˽⡣ǰ¶Îʱ¼ä È¥ÃæÊÔÁ˼¸¼Ò¹«Ë¾ ¼¸ºõ¶¼ÊÇÔÚÊý¾Ý¿âÕâ¿é¹ÒµôµÄ Á¬¸ö¼òµ¥µÄSQ ......
ÏÖÔÚÓÐÁ½ÕÅ±í£ºÎÄÕÂÖ÷±íA(articleId,articleTitle)£¬ÎÄÕÂÆÀÂÛ±íB(commentId,articleId,commentTitle) ÏÖÔÚÎÒÏëʵÏÖÕâÑùµÄ¹¦ÄÜ£ºÁгöÎÄÕÂÁÐ±í£¬ÆäÖÐÿƪÎÄÕ±êÌâÏÂÃæÁгö´ËÎÄÕµÄÇ°2¸öÎÄÕÂÆÀÂÛ£¬ÇëÎÊsqlÓï¾äÔõôд°¡ ......
ͨ¹ýNAME×Ö¶ÎÌõ¼þ²éѯһ¸öÊý¾Ý±í£¬¼ÙÉèÎÒÓÐ100¸öÐÕÃû£¬ÓÐÒÔÏÂÁ½¸ö·½·¨£¬ ·½·¨1£º °Ñ100¸öName ×é³ÉÒ»¸öSQLÓï¾ä£¬±ÈÈç Select * from tmp_table where Name='ÕÅÈý' or Name ='ÀîËÄ' Or ...Or Name='µÚÒ»°Ù¸öÐÕÃû' ......
Ôõô°ÑMDFÊý¾Ýתµ½MySQL£¿ ÖÁÉٵø½¼Óµ½sqlserverÉÏ ¾ßÌåÔõôŪ°¡ ÎҵıÏÒµÉè¼ÆµÄÊý¾Ý¿âÊÇ´ÓÍøÉÏdownÏÂÀ´µÄ£¿£¿ Ä㻹²»ÈçÖ±½ÓÓÃsqlserverÄØ º¯Êý¡¢´æ´¢¹ý³Ì¶¼µÃ¸ÄÁË¡£ sqlserverûÔõôÓùý¡£Ò²Ã»Óа²× ......
A±í ÓÐÁ½¸ö×ֶΠid ΨһÊý×ÖÓò InfoTxt text ÀàÐÍ ÎÒÏÖÔÚÒª°Ñ id ²»ÊÇ14 µÄËùÓÐ InfoTxt×ֶΠÎı¾ºóÃæ ¶¼¼ÓÉÏ 'aaa' °´ÏÂÃæÖ´ÐÐÏÂÀ´ Ö»Óбí×îºóÒ»ÐмÓÉÏÁË 'aaa' ......