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

sql ¼± ÔÚÏßµÈ - MS-SQL Server / »ù´¡Àà

ͬһ¸ö·þÎñÆ÷£¬ Êý¾Ý¿âȨÏÞ²»Í¬£¬±ÈÈç A ±í ÐèÒªÕ˺Ša,ÃÜÂë aa b±í ÐèÒªÕ˺Šb,ÃÜÂëbb
  ÈçºÎ½øÐÐËûÃÇÖ®¼äµÄ²Ù×÷£¬ ²»ÐèÒª²Ù×÷×Ö·û´®
ÈçºÎ½øÐÐËûÃÇÖ®¼äµÄ²Ù×÷,²»ÊǸ÷¹Ü¸÷µÄ±íÂð£¿ÒªÍ³Ò»²Ù×÷£¬ÓÃÁ½¸ö±í¶¼ÓÐȨÏÞµÄÓû§²»¾ÍÐÐÁË

Õâ¸ö?»¹ÕæÃ»ÓÐÕâô¸ã¹ý.

»¹Êǽ¨ÒéÄãÓøöͬһµÄÕʺŰÉ.×îºÃÊÇsa.

Èç¹û¶ÔA¡¢B±í½øÐвÙ×÷µÄ»°£¡¿ÉÒÔÏȰѶÔÏó²Ù×÷ȨÏÞɾ³ý£¬²Ù×÷ÍêºóÔÙ¶Ô¶ÔÏóÊÚȨ£¡

²»ÖªµÀÕâÑù°²È«²»£¿µÈ´ý¸ßÈË....

ÐèÒª¸ã¸öÐéÄâ»ú ÔÙ×°¸öʵÀýÀ´½øÐÐÁ´½Ó·þÎñÆ÷²Ù×÷

ÒýÓÃ
ÐèÒª¸ã¸öÐéÄâ»ú ÔÙ×°¸öʵÀýÀ´½øÐÐÁ´½Ó·þÎñÆ÷²Ù×÷


¸ã¸öÐéÄâ»ú!½éÈëµÚÈý·½...ºÇºÇ...¶¥...

ÒýÓÃ
ÈçºÎ½øÐÐËûÃÇÖ®¼äµÄ²Ù×÷,²»ÊǸ÷¹Ü¸÷µÄ±íÂð£¿ÒªÍ³Ò»²Ù×÷£¬ÓÃÁ½¸ö±í¶¼ÓÐȨÏÞµÄÓû§²»¾ÍÐÐÁË


ÎÒµÄÒâ˼ÊÇ ÏÖÔÚÓÖÁ½¸öÊý¾Ý¿âÁ´½Ó×Ö·û´®£¬ÈçºÎÔÚÒ»¸ö´æ´¢¹ý³ÌÀïÓÃÁíÒ»¸ö×Ö·û´®£¬×Ö·û´®µ±²ÎÊý´«½ø

Õâ¸öÎÊÌâÊÇÓеã¹Ö£¬ºÇºÇ£¬»¹Êǽ¨Ò»¸ö¶¼ÓÐȨÏÞµÄÕ˺Űɣ¡

Õâ¸ö¿ÉÒÔÓÃopenrowset

ÒýÓÃ
ÒýÓà 1 Â¥ htl258 µÄ»Ø¸´:
ÈçºÎ½øÐÐËûÃÇÖ®¼äµÄ²Ù×÷,²»ÊǸ÷¹Ü¸÷µÄ±íÂð£¿ÒªÍ³Ò»²Ù×÷£¬ÓÃÁ½¸ö±í¶¼ÓÐȨÏÞµÄÓû§²»¾ÍÐÐÁË


ÎÒµÄÒâ˼ÊÇ ÏÖÔÚÓÖÁ½¸öÊý¾Ý¿âÁ´½Ó×Ö·û´®£¬ÈçºÎÔÚÒ»¸ö´æ´¢¹ý³ÌÀïÓÃÁíÒ»¸ö×Ö·û´®£¬×Ö·û´®µ±²ÎÊý´«½ø
ÁíÒ»¸ö×Ö·û´®À´Ô´ÊÇÄÄÀï

ÒýÓÃ
ÒýÓà 6 Â¥ xt218218 µÄ»Ø¸´:
ÒýÓà 1 Â¥ htl258 µÄ»Ø¸´:
ÈçºÎ½øÐÐËûÃÇÖ®¼äµÄ²Ù×÷,²»ÊǸ÷¹Ü¸÷µÄ±íÂð£¿ÒªÍ³Ò»²Ù×÷£¬ÓÃÁ½¸ö±í¶¼ÓÐȨÏÞµÄÓû§²»¾ÍÐÐÁË<


Ïà¹ØÎÊ´ð£º

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

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

ASPÁ´½ÓSQLµÄ¼òµ¥µÇ½½çÃæ - .NET¼¼Êõ / ASP.NET

protected void btnLogin_Click(object sender, EventArgs e)
  {
  SqlConnection conn = new SqlConnection("Server = (local);user id = sa;pwd = 1;database = Login");
&nb ......

sqlÓÅ»¯ - Oracle / »ù´¡ºÍ¹ÜÀí

select count(1) from FX_RETURNBOOKCHECKLIST fxreturnbo0_ where fxreturnbo0_.BOOKID='164 ' AND fxreturnbo0_.RETURNID='00025.S0000001' 
ÉÏÃæÒ»¸ö¼òµ¥µÄSQL,Ö´ÐÐʱ¼ä2.6à ......

MYSQLµ÷¶ÈµÄÎÊÌâ - MS-SQL Server / ÒÉÄÑÎÊÌâ


3̨µçÄÔ£¬ÆäÖÐһ̨×÷ΪMYSQL·þÎñÆ÷£¬ÁíÍâ2̨ΪTOMCAT·þÎñÆ÷¡£
MYSQL·þÎñÆ÷ÀïÓÐÒ»Ìõ¼Ç¼£¬ IDΪ10.
ÏÖÔÚ2̨TOMCATͬʱ£¨100%£©·¢ÆðÐÞ¸ÄMYSQLÀïIDΪ10µÄÄÇÌõ¼Ç¼£¬±ÈÈçÐ޸ĴËID¼Ç¼ÀïijһÏîµÄÄÚÈÝ¡£ ±ÈÈçTOMCAT 1Ò ......

Çë½ÌSQLÓï¾ä²éѯÎÊÌ⣿ - MS-SQL Server / »ù´¡Àà

ÎÒÏë²éѯ³öÿÌìÊý¾ÝµÄ×î´óµÄÒ»¸öÖµ¡£±íµÄ¸ñʽÈçÏÂ
±íÃû: hisdata
×Ö¶Î ±àºÅ Öµ ״̬ ʱ¼ä  
  Id value state dattime  
  101 32.3 0 ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ