sql ¼± ÔÚÏßµÈ - MS-SQL Server / »ù´¡Àà
ͬһ¸ö·þÎñÆ÷£¬ Êý¾Ý¿âȨÏÞ²»Í¬£¬±ÈÈç A ±í ÐèÒªÕ˺Ša,ÃÜÂë aa b±í ÐèÒªÕ˺Šb,ÃÜÂëbb ÈçºÎ½øÐÐËûÃÇÖ®¼äµÄ²Ù×÷£¬ ²»ÐèÒª²Ù×÷×Ö·û´®
ÈçºÎ½øÐÐËûÃÇÖ®¼äµÄ²Ù×÷,²»ÊǸ÷¹Ü¸÷µÄ±íÂð£¿ÒªÍ³Ò»²Ù×÷£¬ÓÃÁ½¸ö±í¶¼ÓÐȨÏÞµÄÓû§²»¾ÍÐÐÁË Õâ¸ö?»¹ÕæÃ»ÓÐÕâô¸ã¹ý. »¹Êǽ¨ÒéÄãÓøöͬһµÄÕʺŰÉ.×îºÃÊÇsa. Èç¹û¶ÔA¡¢B±í½øÐвÙ×÷µÄ»°£¡¿ÉÒÔÏȰѶÔÏó²Ù×÷ȨÏÞɾ³ý£¬²Ù×÷ÍêºóÔÙ¶Ô¶ÔÏóÊÚȨ£¡ ²»ÖªµÀÕâÑù°²È«²»£¿µÈ´ý¸ßÈË.... ÐèÒª¸ã¸öÐéÄâ»ú ÔÙ×°¸öʵÀýÀ´½øÐÐÁ´½Ó·þÎñÆ÷²Ù×÷ÒýÓà ÐèÒª¸ã¸öÐéÄâ»ú ÔÙ×°¸öʵÀýÀ´½øÐÐÁ´½Ó·þÎñÆ÷²Ù×÷ ¸ã¸öÐéÄâ»ú!½éÈëµÚÈý·½...ºÇºÇ...¶¥...ÒýÓà ÈçºÎ½øÐÐËûÃÇÖ®¼äµÄ²Ù×÷,²»ÊǸ÷¹Ü¸÷µÄ±íÂð£¿ÒªÍ³Ò»²Ù×÷£¬ÓÃÁ½¸ö±í¶¼ÓÐȨÏÞµÄÓû§²»¾ÍÐÐÁË ÎÒµÄÒâ˼ÊÇ ÏÖÔÚÓÖÁ½¸öÊý¾Ý¿âÁ´½Ó×Ö·û´®£¬ÈçºÎÔÚÒ»¸ö´æ´¢¹ý³ÌÀïÓÃÁíÒ»¸ö×Ö·û´®£¬×Ö·û´®µ±²ÎÊý´«½ø Õâ¸öÎÊÌâÊÇÓеã¹Ö£¬ºÇºÇ£¬»¹Êǽ¨Ò»¸ö¶¼ÓÐȨÏÞµÄÕ˺Űɣ¡ Õâ¸ö¿ÉÒÔÓÃopenrowsetÒýÓà ÒýÓà 1 Â¥ htl258 µÄ»Ø¸´: ÈçºÎ½øÐÐËûÃÇÖ®¼äµÄ²Ù×÷,²»ÊǸ÷¹Ü¸÷µÄ±íÂð£¿ÒªÍ³Ò»²Ù×÷£¬ÓÃÁ½¸ö±í¶¼ÓÐȨÏÞµÄÓû§²»¾ÍÐÐÁË ÎÒµÄÒâ˼ÊÇ ÏÖÔÚÓÖÁ½¸öÊý¾Ý¿âÁ´½Ó×Ö·û´®£¬ÈçºÎÔÚÒ»¸ö´æ´¢¹ý³ÌÀïÓÃÁíÒ»¸ö×Ö·û´®£¬×Ö·û´®µ±²ÎÊý´«½ø ÁíÒ»¸ö×Ö·û´®À´Ô´ÊÇÄÄÀïÒýÓà ÒýÓà 6 Â¥ xt218218 µÄ»Ø¸´: ÒýÓà 1 Â¥ htl258 µÄ»Ø¸´: ÈçºÎ½øÐÐËûÃÇÖ®¼äµÄ²Ù×÷,²»ÊǸ÷¹Ü¸÷µÄ±íÂð£¿ÒªÍ³Ò»²Ù×÷£¬ÓÃÁ½¸ö±í¶¼ÓÐȨÏÞµÄÓû§²»¾ÍÐÐÁË<
Ïà¹ØÎÊ´ð£º
Ö´ÐеÄ˳Ðò£º 1£©Îļþä¯ÀÀ¿ò£¨Ñ¡ÔñÎļþʹÓã© Ñ¡ÔñºÃÎļþºó µã»÷Ò»¸öµ¼Èë°´Å¥µÄʱºò £¬°ÑÉÏÃæÉÏ´«¿òÀïµÄcsvÎļþÒÔÒ»¸öIDΪÎļþÃû£¬ÉÏ´«µ½**/**Îļþ¼ÐÏ 2£©¶ÁÈ¡Õâ¸öÎļþ¼ÐϵÄcsvµÄÎļþ£¬×ª»»³Ésql 3 ......
protected void btnLogin_Click(object sender, EventArgs e) { SqlConnection conn = new SqlConnection("Server = (local);user id = sa;pwd = 1;database = Login"); &nb ......
select count(1) from FX_RETURNBOOKCHECKLIST fxreturnbo0_ where fxreturnbo0_.BOOKID='164 ' AND fxreturnbo0_.RETURNID='00025.S0000001' ÉÏÃæÒ»¸ö¼òµ¥µÄSQL,Ö´ÐÐʱ¼ä2.6à ......
3̨µçÄÔ£¬ÆäÖÐһ̨×÷ΪMYSQL·þÎñÆ÷£¬ÁíÍâ2̨ΪTOMCAT·þÎñÆ÷¡£ MYSQL·þÎñÆ÷ÀïÓÐÒ»Ìõ¼Ç¼£¬ IDΪ10. ÏÖÔÚ2̨TOMCATͬʱ£¨100%£©·¢ÆðÐÞ¸ÄMYSQLÀïIDΪ10µÄÄÇÌõ¼Ç¼£¬±ÈÈçÐ޸ĴËID¼Ç¼ÀïijһÏîµÄÄÚÈÝ¡£ ±ÈÈçTOMCAT 1Ò ......
ÎÒÏë²éѯ³öÿÌìÊý¾ÝµÄ×î´óµÄÒ»¸öÖµ¡£±íµÄ¸ñʽÈçÏ ±íÃû: hisdata ×Ö¶Î ±àºÅ Öµ ״̬ ʱ¼ä Id value state dattime 101 32.3 0 ......