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

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


Ïà¹ØÎÊ´ð£º

C# DataSetµ¼³öxml Åú´¦Àí(Ñ­»·)µÃÔõô´¦Àí

DataSetµ¼³öxml Åú´¦Àí(Ñ­»·)µÃÔõô´¦Àí
XMLÎļþ
<A>
      <B>
        <C>
        </C>
  &nb ......

sql - MS-SQL Server / ÒÉÄÑÎÊÌâ

sqlµÄÈí¼þÔÚÄÄÀï¿ÉÒÔϰ¡£¡ÔÚÍøÉÏÕÒÁËÂù¶à¶¼Óò»Á˰¡

Ëæ±ã¸ãÒ»D°æ°É£¬

ѸÀ×µÚÒ»¸ö¾Í¿ÉÒÔÓÃ
2000,2005¶¼ÕâÑù

http://119.147.41.16/down?cid=0698C2D64D7D637D90A6D2482298E6717D4F15CD&t=2&fmt=-1 ......

¹ØÓÚSQLÓï¾äORµÄÎÊÌâ - Oracle / ¸ß¼¶¼¼Êõ

ͨ¹ýNAME×Ö¶ÎÌõ¼þ²éѯһ¸öÊý¾Ý±í£¬¼ÙÉèÎÒÓÐ100¸öÐÕÃû£¬ÓÐÒÔÏÂÁ½¸ö·½·¨£¬
·½·¨1£º
°Ñ100¸öName ×é³ÉÒ»¸öSQLÓï¾ä£¬±ÈÈç Select * from tmp_table where Name='ÕÅÈý' or Name ='ÀîËÄ' Or ...Or Name='µÚÒ»°Ù¸öÐÕÃû'
......

Ôõô°ÑMDFÊý¾Ýתµ½MySQL£¿ - MS-SQL Server / »ù´¡Àà

Ôõô°ÑMDFÊý¾Ýתµ½MySQL£¿
ÖÁÉٵø½¼Óµ½sqlserverÉÏ

¾ßÌåÔõôŪ°¡ ÎҵıÏÒµÉè¼ÆµÄÊý¾Ý¿âÊÇ´ÓÍøÉÏdownÏÂÀ´µÄ£¿£¿

Ä㻹²»ÈçÖ±½ÓÓÃsqlserverÄØ

º¯Êý¡¢´æ´¢¹ý³Ì¶¼µÃ¸ÄÁË¡£

sqlserverûÔõôÓùý¡£Ò²Ã»Óа²× ......

Accessͨ¹ýSqlÓï¾ä´´½¨Êý¾Ý¿â - .NET¼¼Êõ / C#

ÔÚAccessµÄ²éѯÖÐÖ´ÐÐÏÂÃæµÄÓï¾ä,ÎÞЧ,ÌáʾÆÚ´ýselect ,updata ,...
CreateTble C=Answer N="»ØÌû±í"
(
  C=ID T="INTEGER" P=No M=No N="±àºÅ" Z=false,
  C=Ques ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ