sqlserverµÄ´æ´¢¹ý³ÌµÄÎÊÌâ - MS-SQL Server / »ù´¡Àà
sqlserverµÄ´æ´¢¹ý³ÌÓÐoracleµÄÄÇÖÖ°üµÄ¸ÅÄîô£¿
¾ÍÊǺܶà¸öÂß¼ÉÏÓÐÁªÏµµÄ´æ´¢¹ý³ÌÊÇ¿ÉÒÔ·ÅÔÚÒ»¸öpackageÀïÃæµÄ£¿
oracle²»¶®¡£
ûÍæ¹ýOµÄ£¬°ï¶¥¡£
ÄÇsqlserver µÄ´æ´¢¹ý³Ì¾ÍÊÇÒ»¸ö¸öµ¥¶ÀµÄÈ«²¿ÁÐÔÚ¡°´æ´¢¹ý³Ì¡±Îļþ¼ÐÏÂÃæÁË£¿£¿Ò²²»·ÖÀàµÄ£¿
UP.
(¡Ño¡Ñ)¡..........
ÄÇ´ó¼Òд´æ´¢¹ý³ÌµÄʱºò£¬¶¼ÊÇÔõô¹ÜÀíµÄÄØ£¿
±ÈÈçºÜ¶à¸ö´æ´¢¹ý³Ì£¬¾ÍÄÇôÈÓÔÚÄÇÒ»¶Ñô£¿
¾ÍÊÇÒ»¶Ñ en
ÔΣ¬²»»áµÄ°É...
·¹ý
ÎÒÃÇÕâÀï×öÏîÄ¿ Êý¾Ý¿âÀïÃæÓм¸°Ù¸ö´æ´¢¹ý³Ì ¶¼ÊǶªÔÚÒ»ÆðµÎ
´æ´¢¹ý³ÌÆðÃûÆðµÄÓйéÀà¾ÍÐÐÁË
SQL Server»¹ÊÇÓÐЩ¶«Î÷ûOracleÄÇô×ÐϸµÄ
¶í£¬Á˽âÁË£¬Ð»Ð»¸÷λ~~
Ïà¹ØÎÊ´ð£º
×Ö¶Î1,×Ö¶Î2.....×Ö¶ÎN,Status,ParentID
1,Name1....test1,1,99
1,Name1....test1,3,99
1,Name2....test2,1,101
1,Name2....test2,3,101
1,Name3....test3,2,101
1,Name1....test1,4,101
ÏëÒªµÄ½á¹ûÊÇ:
1,Na ......
ÎÒ¾õµÃmysqlºÍsqlserverÓй²Í¬µÄµØ·½£º
ÓиöÎÊÌâÊǹØÓÚ±íµÄËøÎÊÌ⣺
½ø³ÌA ½ø³ÌB
select * from user where id in lock share mode£¨¹²ÏíËø)
&nb ......
ÓÐÕâÑùÒ»ÌõSQL
Select Get_Costtaxrate(col1), Get_Tcostvalue(col1) from a
ÆäÖÐGet_Costtaxrate¡¢Get_Tcostvalue¶¼ÊǺ¯Êý£¬ÕâÁ½¸öº¯ÊýÀïÃ涼ÊDzéÕÒÒ»¸ö´ó±í£¬Get_Tcostvalue»¹ÐèÒªµ÷ÓÃGet_C ......
ÕâÀïÏëÁ˽âÏ£¬¹ØÓÚSQL ServerÖзÖÒ³ºÍOracleÖзÖÒ³£»
ƽ³£Ð´Ó¦ÓóÌÐòµÄʱºò£¬±ÈÈçÓõÄÓïÑÔÊÇJava£¬ÓиöÁбíÒ³Ã棬ÐèÒª¶ÔÊý¾Ý·ÖÒ³ÏÔʾ£»
ÕâÀïÒª·ÖÒ³ÄѵÀ²»ÐèÒª½èÖúJava£¬¶øÖ±½ÓsqlÄÜÖªµÀ·ÖÒ³Âð£¬ÆðÂëÒ²Òª´«¸öÒ³Âë½ ......