sqlserverµÄ´æ´¢¹ý³ÌµÄÎÊÌâ - MS-SQL Server / »ù´¡Àà
sqlserverµÄ´æ´¢¹ý³ÌÓÐoracleµÄÄÇÖÖ°üµÄ¸ÅÄîô£¿
¾ÍÊǺܶà¸öÂß¼ÉÏÓÐÁªÏµµÄ´æ´¢¹ý³ÌÊÇ¿ÉÒÔ·ÅÔÚÒ»¸öpackageÀïÃæµÄ£¿
oracle²»¶®¡£
Ã»Íæ¹ýOµÄ£¬°ï¶¥¡£
ÄÇsqlserver µÄ´æ´¢¹ý³Ì¾ÍÊÇÒ»¸ö¸öµ¥¶ÀµÄÈ«²¿ÁÐÔÚ¡°´æ´¢¹ý³Ì¡±Îļþ¼ÐÏÂÃæÁË£¿£¿Ò²²»·ÖÀàµÄ£¿
UP.
(¡Ño¡Ñ)¡..........
ÄÇ´ó¼Òд´æ´¢¹ý³ÌµÄʱºò£¬¶¼ÊÇÔõô¹ÜÀíµÄÄØ£¿
±ÈÈçºÜ¶à¸ö´æ´¢¹ý³Ì£¬¾ÍÄÇôÈÓÔÚÄÇÒ»¶Ñô£¿
¾ÍÊÇÒ»¶Ñ en
ÔΣ¬²»»áµÄ°É...
·¹ý
ÎÒÃÇÕâÀï×öÏîÄ¿ Êý¾Ý¿âÀïÃæÓм¸°Ù¸ö´æ´¢¹ý³Ì ¶¼ÊǶªÔÚÒ»ÆðµÎ
´æ´¢¹ý³ÌÆðÃûÆðµÄÓйéÀà¾ÍÐÐÁË
SQL Server»¹ÊÇÓÐЩ¶«Î÷ûOracleÄÇô×ÐϸµÄ
¶í£¬Á˽âÁË£¬Ð»Ð»¸÷λ~~
Ïà¹ØÎÊ´ð£º
ÎÒÓжà¸ö±íA B C ½á¹¹ÊÇÒ»ÑùµÄ£¬¶¼ÓÐ2¸ö×Ö¶ÎnameºÍcontent,ÎÒÒªËÑË÷ËùÒÔ±íËùÓÐ×Ö¶ÎÖаüº¬¡°Öйú¡±µÄÄÚÈÝ Õâ¸öSQLÓï¾äÔõôд
ÈçºÎ½«¶à¸ö±íµÄ²éѯ½á¹ûÁ¬³ÉÒ»¸ö±í Õâ¸öSQLÓï¾äÔõôд ±íµÄ½á¹¹ÊÇÒ»ÑùµÄ
ÀýÈç£ ......
ÎÒÓÐÒ»¸ö±í£¬½á¹¹ÊÇÕâÑù¡£
ת³ö µ¥Î» תÈ뵥λ ±ÊÊý ½ð¶î
date(Ö÷) outid(Ö÷) inid(Ö÷) num amt
2009 1 2 1 500 Ϊ 1 µ¥Î» ÔÚ2009Ä ......
ÏÖÔÚÓÐÁ½ÕÅ±í£ºÎÄÕÂÖ÷±íA(articleId,articleTitle)£¬ÎÄÕÂÆÀÂÛ±íB(commentId,articleId,commentTitle)
ÏÖÔÚÎÒÏëʵÏÖÕâÑùµÄ¹¦ÄÜ£ºÁгöÎÄÕÂÁÐ±í£¬ÆäÖÐÿƪÎÄÕ±êÌâÏÂÃæÁгö´ËÎÄÕµÄǰ2¸öÎÄÕÂÆÀÂÛ£¬ÇëÎÊsqlÓï¾äÔõôд°¡ ......
Çë½Ì¸ßÊÖ£º
ÒÔÏÂÊÇÊý¾Ý¿âÖеÄÈýÌõ¼Ç¼£¬Ó¢ÎÄΪ×Ö¶ÎÃû³Æ
id planname TaskBeginTime Status
329 2010Äê03 ......
ÓÐÕâÑùÒ»ÌõSQL
Select Get_Costtaxrate(col1), Get_Tcostvalue(col1) from a
ÆäÖÐGet_Costtaxrate¡¢Get_Tcostvalue¶¼ÊǺ¯Êý£¬ÕâÁ½¸öº¯ÊýÀïÃæ¶¼ÊDzéÕÒÒ»¸ö´ó±í£¬Get_Tcostvalue»¹ÐèÒªµ÷ÓÃGet_C ......