Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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


Ïà¹ØÎÊ´ð£º

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

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

sqlССµÄÒÉÎÊ - .NET¼¼Êõ / C#

¿ÉÄÜÒòΪ¹¤×÷µÄÔ­Òò ½Ó´¥Êý¾Ý¿âÕâ¿é±È½ÏÉÙ£¬Ö®Ç°¶¼ÊÇ×ö³ÌÐòÕâ¿é£¬Êý¾Ý¿âÕâ¿é¶¼ÓÐרÃŵÄÈËÀ´×ö ·Ö¹¤¶¼ºÜÃ÷ϸ ËùÒÔ¶ÔÊý¾Ý¿âÕâÒ»¿éÍêÈ«²»Á˽⡣ǰ¶Îʱ¼ä È¥ÃæÊÔÁ˼¸¼Ò¹«Ë¾ ¼¸ºõ¶¼ÊÇÔÚÊý¾Ý¿âÕâ¿é¹ÒµôµÄ Á¬¸ö¼òµ¥µÄSQ ......

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='µÚÒ»°Ù¸öÐÕÃû'
......

ASPÒ³ÃæÎÞ·¨´ò¿ªÇóÖú£¡ - MS-SQL Server / »ù´¡Àà

¸÷λºÃ£¬ÎÒ¸Õ°ÑÒ»¸öASPÍøÕ¾ÉèÖúÃÁË£¬Ò²ÄÜÕý³£·ÃÎÊ¡£µ«ÊÇÔÚÎÒ±¾»úÉϲ»ÄÜ´ò¿ªadmin\login.asp,ËùÒÔÎÞ·¨ÊµÏÖºǫ́¹ÜÀí¡££¨´íÎóÌáʾÎÞ·¨ÕÒµ½ÍøÒ³£¬´úÂë404£¬ÎҵIJÙ×÷ϵͳÊÇwin2000 server)
µ«ÊÇÆæ¹ÖµÄÊÇÔÚ¾ÖÓòÍøµÄÆäËû» ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ