ÒªÈçºÎѧºÃsql - MS-SQL Server / »ù´¡Àà
ÎÒÏÖÔÚ»áһЩ»ù±¾µÄsqlÓï·¨£¨Ôöɾ¸Ä²é,´æ´¢¹ý³Ì,ÊÂÎñ£© ²»ÖªµÀÒªÈçºÎÉîÈëѧϰsql,²»ÖªµÀ ÓÐûÓÐʲôºÃµÄ½¨Òé~~~
ÉÏÂÛ̳¿´Ìû »ù±¾µÄ»áÁËÒÔºó¾Í¿ÉÒÔÂòµãÉîÈëµÄÊé¿´ÁË ±ÈÈç¼¼ÊõÄÚÄ» Ö±½Ó¿´ÊéÄã»áºÜÀÛ£¬Ô½¿´Ô½ÔΡ£ÎҵľÑéÊÇÖ±½Óѧϰ±ðÈËÏֳɵĶ«Î÷¡£±ÈÈç¹Ü¼ÒÆŵÈÈí¼þµÄ´æ´¢¹ý³Ì£¬ÀïÃæдµÄºÜʵÓ㬻ù±¾ÉÏÊéÉÏдµÄ¶«Î÷£¬ËûÃǵÄÈí¼þÀïÃ涼Óõ½ÁË¡£ÎÒµÄqq:59955142¡£ Ï£Íû¸ø·Ö¡£×î½üûÓзÖÁË¡£Ð»Ð»£¡·ÒýÓà »ù±¾µÄ»áÁËÒÔºó¾Í¿ÉÒÔÂòµãÉîÈëµÄÊé¿´ÁË ±ÈÈç¼¼ÊõÄÚÄ» ±ÈÈ磿 »¹ÊǶà¶àµÄÁ·Ï°°É£¬Á·Ï°Êµ¼ù×îÖØÒªÒýÓà »¹ÊǶà¶àµÄÁ·Ï°°É£¬Á·Ï°Êµ¼ù×îÖØÒª ÓÐʱ¼äÎÒ»ù±¾¿´ÂÛ̳ ÊÔÊÔ±ðÈ˵Äsql Èç¹ûʱ¼ä´ó°Ñ£¬¿ÉÒÔÔÚÕâÀïÅÝÂÛ̳¡£ ¿´Ã¿¸öÈ˵ÄÎÊÌ⣬²¢ÇÒ½øÐÐ˼¿¼½â¾ö¡£ ¶øÇÒÒª×öºÃÕûÀí¡£³é¿Õ°ÑÁª»ú´ÔÊé¶à¿´¼¸±é¡£ ×îºóÔÙÉîÈë ÎÒ¾õµÃ»¹ÊÇÏÈ¿´Ê飬´òÏ»ù´¡£¬È»ºó¿ÉÒÔÈ¥¿´¿´ÊÓƵ£¬ÔÙ×Ô¼º¶¯ÊÖÈ¥Á·Á·£¬ÕâÑùÓиöÑÐò½¥½øµÄ¹ý³Ì ѧϰÊÇÒ»²½Ò»²½À´µÄ£¬¼±²»µÃ¡£
Ïà¹ØÎÊ´ð£º
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£ ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î date(Ö÷) outid(Ö÷) inid(Ö÷) num amt 2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
ÓÐÕâÑùÒ»ÌõSQL Select Get_Costtaxrate(col1), Get_Tcostvalue(col1) from a ÆäÖÐGet_Costtaxrate¡¢Get_Tcostvalue¶¼ÊǺ¯Êý£¬ÕâÁ½¸öº¯ÊýÀïÃ涼ÊDzéÕÒÒ»¸ö´ó±í£¬Get_Tcostvalue»¹ÐèÒªµ÷ÓÃGet_C ......
ͨ¹ýNAME×Ö¶ÎÌõ¼þ²éѯһ¸öÊý¾Ý±í£¬¼ÙÉèÎÒÓÐ100¸öÐÕÃû£¬ÓÐÒÔÏÂÁ½¸ö·½·¨£¬ ·½·¨1£º °Ñ100¸öName ×é³ÉÒ»¸öSQLÓï¾ä£¬±ÈÈç Select * from tmp_table where Name='ÕÅÈý' or Name ='ÀîËÄ' Or ...Or Name='µÚÒ»°Ù¸öÐÕÃû' ......
Ôõô°ÑMDFÊý¾Ýתµ½MySQL£¿ ÖÁÉٵø½¼Óµ½sqlserverÉÏ ¾ßÌåÔõôŪ°¡ ÎҵıÏÒµÉè¼ÆµÄÊý¾Ý¿âÊÇ´ÓÍøÉÏdownÏÂÀ´µÄ£¿£¿ Ä㻹²»ÈçÖ±½ÓÓÃsqlserverÄØ º¯Êý¡¢´æ´¢¹ý³Ì¶¼µÃ¸ÄÁË¡£ sqlserverûÔõôÓùý¡£Ò²Ã»Óа²× ......