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
Ïà¹ØÎÊ´ð£º
DataSetµ¼³öxml Åú´¦Àí(Ñ»·)µÃÔõô´¦Àí XMLÎļþ <A> <B> <C> </C> &nb ......
sqlµÄÈí¼þÔÚÄÄÀï¿ÉÒÔϰ¡£¡ÔÚÍøÉÏÕÒÁËÂù¶à¶¼Óò»Á˰¡ Ëæ±ã¸ãÒ»D°æ°É£¬ ѸÀ×µÚÒ»¸ö¾Í¿ÉÒÔÓà 2000,2005¶¼ÕâÑù http://119.147.41.16/down?cid=0698C2D64D7D637D90A6D2482298E6717D4F15CD&t=2&fmt=-1 ......
ͨ¹ýNAME×Ö¶ÎÌõ¼þ²éѯһ¸öÊý¾Ý±í£¬¼ÙÉèÎÒÓÐ100¸öÐÕÃû£¬ÓÐÒÔÏÂÁ½¸ö·½·¨£¬ ·½·¨1£º °Ñ100¸öName ×é³ÉÒ»¸öSQLÓï¾ä£¬±ÈÈç Select * from tmp_table where Name='ÕÅÈý' or Name ='ÀîËÄ' Or ...Or Name='µÚÒ»°Ù¸öÐÕÃû' ......
Ôõô°ÑMDFÊý¾Ýתµ½MySQL£¿ ÖÁÉٵø½¼Óµ½sqlserverÉÏ ¾ßÌåÔõôŪ°¡ ÎҵıÏÒµÉè¼ÆµÄÊý¾Ý¿âÊÇ´ÓÍøÉÏdownÏÂÀ´µÄ£¿£¿ Ä㻹²»ÈçÖ±½ÓÓÃsqlserverÄØ º¯Êý¡¢´æ´¢¹ý³Ì¶¼µÃ¸ÄÁË¡£ sqlserverûÔõôÓùý¡£Ò²Ã»Óа²× ......
ÔÚAccessµÄ²éѯÖÐÖ´ÐÐÏÂÃæµÄÓï¾ä,ÎÞЧ,ÌáʾÆÚ´ýselect ,updata ,... CreateTble C=Answer N="»ØÌû±í" ( C=ID T="INTEGER" P=No M=No N="±àºÅ" Z=false, C=Ques ......