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

ÒªÈçºÎѧºÃsql - MS-SQL Server / »ù´¡Àà

ÎÒÏÖÔÚ»áһЩ»ù±¾µÄsqlÓï·¨£¨Ôöɾ¸Ä²é,´æ´¢¹ý³Ì,ÊÂÎñ£©

²»ÖªµÀÒªÈçºÎÉîÈëѧϰsql,²»ÖªµÀ ÓÐûÓÐʲôºÃµÄ½¨Òé~~~
ÉÏÂÛ̳¿´Ìû


»ù±¾µÄ»áÁËÒÔºó¾Í¿ÉÒÔÂòµãÉîÈëµÄÊé¿´ÁË ±ÈÈç¼¼ÊõÄÚÄ»

Ö±½Ó¿´ÊéÄã»áºÜÀÛ£¬Ô½¿´Ô½ÔΡ£Îҵľ­ÑéÊÇÖ±½Óѧϰ±ðÈËÏֳɵĶ«Î÷¡£±ÈÈç¹Ü¼ÒÆŵÈÈí¼þµÄ´æ´¢¹ý³Ì£¬ÀïÃæдµÄºÜʵÓ㬻ù±¾ÉÏÊéÉÏдµÄ¶«Î÷£¬ËûÃǵÄÈí¼þÀïÃ涼Óõ½ÁË¡£ÎÒµÄqq:59955142¡£
Ï£Íû¸ø·Ö¡£×î½üûÓзÖÁË¡£Ð»Ð»£¡·

ÒýÓÃ
»ù±¾µÄ»áÁËÒÔºó¾Í¿ÉÒÔÂòµãÉîÈëµÄÊé¿´ÁË ±ÈÈç¼¼ÊõÄÚÄ»


±ÈÈ磿

»¹ÊǶà¶àµÄÁ·Ï°°É£¬Á·Ï°Êµ¼ù×îÖØÒª

ÒýÓÃ
»¹ÊǶà¶àµÄÁ·Ï°°É£¬Á·Ï°Êµ¼ù×îÖØÒª


ÓÐʱ¼äÎÒ»ù±¾¿´ÂÛ̳ ÊÔÊÔ±ðÈ˵Äsql

Èç¹ûʱ¼ä´ó°Ñ£¬¿ÉÒÔÔÚÕâÀïÅÝÂÛ̳¡£

¿´Ã¿¸öÈ˵ÄÎÊÌ⣬²¢ÇÒ½øÐÐ˼¿¼½â¾ö¡£

¶øÇÒÒª×öºÃÕûÀí¡£³é¿Õ°ÑÁª»ú´ÔÊé¶à¿´¼¸±é¡£

×îºóÔÙÉîÈë

ÎÒ¾õµÃ»¹ÊÇÏÈ¿´Ê飬´òÏ»ù´¡£¬È»ºó¿ÉÒÔÈ¥¿´¿´ÊÓƵ£¬ÔÙ×Ô¼º¶¯ÊÖÈ¥Á·Á·£¬ÕâÑùÓиöÑ­Ðò½¥½øµÄ¹ý³Ì

ѧϰÊÇÒ»²½Ò»²½À´µÄ£¬¼±²»µÃ¡£


Ïà¹ØÎÊ´ð£º

Çë½ÌsqlÓï¾ä¡£ - Oracle / ¿ª·¢

ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
  ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......

Ò»Ìõ SQL - Oracle / »ù´¡ºÍ¹ÜÀí

ÓÐÕâÑùÒ»ÌõSQL
 Select Get_Costtaxrate(col1), Get_Tcostvalue(col1) from a
 
ÆäÖÐGet_Costtaxrate¡¢Get_Tcostvalue¶¼ÊǺ¯Êý£¬ÕâÁ½¸öº¯ÊýÀïÃ涼ÊDzéÕÒÒ»¸ö´ó±í£¬Get_Tcostvalue»¹ÐèÒªµ÷ÓÃGet_C ......

¹ØÓÚSQLÓï¾äORµÄÎÊÌâ - Oracle / ¸ß¼¶¼¼Êõ

ͨ¹ýNAME×Ö¶ÎÌõ¼þ²éѯһ¸öÊý¾Ý±í£¬¼ÙÉèÎÒÓÐ100¸öÐÕÃû£¬ÓÐÒÔÏÂÁ½¸ö·½·¨£¬
·½·¨1£º
°Ñ100¸öName ×é³ÉÒ»¸öSQLÓï¾ä£¬±ÈÈç Select * from tmp_table where Name='ÕÅÈý' or Name ='ÀîËÄ' Or ...Or Name='µÚÒ»°Ù¸öÐÕÃû'
......

Ôõô°ÑMDFÊý¾Ýתµ½MySQL£¿ - MS-SQL Server / »ù´¡Àà

Ôõô°ÑMDFÊý¾Ýתµ½MySQL£¿
ÖÁÉٵø½¼Óµ½sqlserverÉÏ

¾ßÌåÔõôŪ°¡ ÎҵıÏÒµÉè¼ÆµÄÊý¾Ý¿âÊÇ´ÓÍøÉÏdownÏÂÀ´µÄ£¿£¿

Ä㻹²»ÈçÖ±½ÓÓÃsqlserverÄØ

º¯Êý¡¢´æ´¢¹ý³Ì¶¼µÃ¸ÄÁË¡£

sqlserverûÔõôÓùý¡£Ò²Ã»Óа²× ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ