SQL×ֶΣ¬ºáÏòÕ¹¿ª
ÇëÎʸ÷룬ÈçºÎ½«SQlÖУ¬Ä³×Ö¶ÎÖеÄÖµºáÏòÕ¹¿ªÄØ£¬
CASE WHEN ¾ßÌåÎÊÌâ¾ßÌå·ÖÎö£¬¿´ÄãÒªÔõôչ¿ª ÐÕÃû ¿ÆÄ¿ ³É¼¨ ÕÅÈý Ó¢Óï 90 ÀîËÄ Ó¢Óï 85 ÍõÎå Ó¢Óï 80 ÕÅÈý Êýѧ 95 ÀîËÄ Êýѧ 92 ÍõÎå Êýѧ 98 ÕÅÈý ÓïÎÄ 80 ÀîËÄ ÓïÎÄ 85 ÍõÎå ÓïÎÄ 82 ———————————————— ½á¹û ———————————————— ÐÕÃû Ó¢Óï Êýѧ ÓïÎÄ ÕÅÈý 90 95 80 ÀîËÄ 85 92 85 ÍõÎå 80 98 92 ÒýÓà ÐÕÃû ¿ÆÄ¿ ³É¼¨ ÕÅÈý Ó¢Óï 90 ÀîËÄ Ó¢Óï 85 ÍõÎå Ó¢Óï 80 ÕÅÈý Êýѧ 95 ÀîËÄ Êýѧ 92 ÍõÎå Êýѧ 98 ÕÅÈý ÓïÎÄ 80 ÀîËÄ
Ïà¹ØÎÊ´ð£º
sql table±íÓиöÎı¾ÀàÐ͵Äa×ֶΣ¬´æ´¢µÄÄÚÈÝÈ«²¿ÊÇÊý×Ö£¬ÀýÈç2009001£¬2008578ÕâÑùµÄ¸ñʽ£»b×Ö¶ÎÎı¾ÀàÐÍ£¬´æµÄÒ²ÊÇÊý×ÖÀýÈç 001£¬123 aspÀïÃæ strday=100£¬strb=001 ÎÒÏë¶Á³ö£¬´Óa×ֶεÄÊý×Ö°´´óµ½Ð¡µÄË ......
sql2005 select *from v_ddxx where d_sfsc='0' and (g_ssbm='1001' or g_ssbm='1002') and (xxf>0 and xxfwzf <>0 ),Ö´ÐÐËÙ¶ÈÂýµÄÒªËÀ£¬µ«ÊÇÈç¹û°Ñ(xxf>0 and ......
ÎÒÓõÄÊÇmysql5.1£¬Êý¾Ý¿â×Ö·û¼¯Îªutf8 ͨ¹ýdosÃüÁîÐе¼ÈëSQLÎļþ ³ö´í£¬ÎÞ·¨µ¼Èë¡£ ½«SQLÎļþÖеÄÊý¾ÝÈ«²¿Ê¹ÓÃÓ¢ÎÄ ¿ÉÒÔµ¼Èë ÇëÎÊÎÊÌâÔÚÄÄ£¿ ×°¸öÖÐÎÄÈí¼þ¼´¿É. ºÜ¶àÄêÒÔǰ,Óùý¸öÒ»¸ ......
C#ÈçºÎÅжÏÁ¬½Ósql serverÊý¾Ý¿â³É¹¦£¿ try { connection.connect() return true; } catch() { return false; } Â¥Ö÷ºÜ׿±£¬¿ªÁ˼¸ÌùÁË¡£ ÒýÓà try { connection.connect( ......