sqlserverµÄ´æ´¢¹ý³ÌµÄÎÊÌâ - MS-SQL Server / »ù´¡Àà
sqlserverµÄ´æ´¢¹ý³ÌÓÐoracleµÄÄÇÖÖ°üµÄ¸ÅÄîô£¿ ¾ÍÊǺܶà¸öÂß¼ÉÏÓÐÁªÏµµÄ´æ´¢¹ý³ÌÊÇ¿ÉÒÔ·ÅÔÚÒ»¸öpackageÀïÃæµÄ£¿
oracle²»¶®¡£ ûÍæ¹ýOµÄ£¬°ï¶¥¡£ ÄÇsqlserver µÄ´æ´¢¹ý³Ì¾ÍÊÇÒ»¸ö¸öµ¥¶ÀµÄÈ«²¿ÁÐÔÚ¡°´æ´¢¹ý³Ì¡±Îļþ¼ÐÏÂÃæÁË£¿£¿Ò²²»·ÖÀàµÄ£¿ UP. (¡Ño¡Ñ)¡.......... ÄÇ´ó¼Òд´æ´¢¹ý³ÌµÄʱºò£¬¶¼ÊÇÔõô¹ÜÀíµÄÄØ£¿ ±ÈÈçºÜ¶à¸ö´æ´¢¹ý³Ì£¬¾ÍÄÇôÈÓÔÚÄÇÒ»¶Ñô£¿ ¾ÍÊÇÒ»¶Ñ en ÒýÓà (¡Ño¡Ñ)¡.......... ÄÇ´ó¼Òд´æ´¢¹ý³ÌµÄʱºò£¬¶¼ÊÇÔõô¹ÜÀíµÄÄØ£¿ ±ÈÈçºÜ¶à¸ö´æ´¢¹ý³Ì£¬¾ÍÄÇôÈÓÔÚÄÇÒ»¶Ñô£¿ ÔΣ¬²»»áµÄ°É...ÒýÓà ûÍæ¹ýOµÄ£¬°ï¶¥¡£ ·¹ý ÎÒÃÇÕâÀï×öÏîÄ¿ Êý¾Ý¿âÀïÃæÓм¸°Ù¸ö´æ´¢¹ý³Ì ¶¼ÊǶªÔÚÒ»ÆðµÎ ´æ´¢¹ý³ÌÆðÃûÆðµÄÓйéÀà¾ÍÐÐÁË SQL Server»¹ÊÇÓÐЩ¶«Î÷ûOracleÄÇô×ÐϸµÄ ¶í£¬Á˽âÁË£¬Ð»Ð»¸÷λ~~
Ïà¹ØÎÊ´ð£º
¿ÉÄÜÒòΪ¹¤×÷µÄÔÒò ½Ó´¥Êý¾Ý¿âÕâ¿é±È½ÏÉÙ£¬Ö®Ç°¶¼ÊÇ×ö³ÌÐòÕâ¿é£¬Êý¾Ý¿âÕâ¿é¶¼ÓÐרÃŵÄÈËÀ´×ö ·Ö¹¤¶¼ºÜÃ÷ϸ ËùÒÔ¶ÔÊý¾Ý¿âÕâÒ»¿éÍêÈ«²»Á˽⡣ǰ¶Îʱ¼ä È¥ÃæÊÔÁ˼¸¼Ò¹«Ë¾ ¼¸ºõ¶¼ÊÇÔÚÊý¾Ý¿âÕâ¿é¹ÒµôµÄ Á¬¸ö¼òµ¥µÄSQ ......
Çó¸övbÖеÄsqlÓï¾äµÄд·¨£¬´ÎsqlÓï¾äµÄÓ÷¨ÊÇ·ÖÒ³³ÌÐò ÎÒдµÄÈçÏ£ºÆäÖÐAÊÇÓÃÀ´½ÓÊÕÿҳÏÔʾµÄ¼Ç¼µÄÌõÊý£¬BÊÇÓÃÀ´½ÓÊÕÏÔʾµÄµ±Ç°µÄÒ³Ãæ. sqltext="select top A * from log where id not in(select top ( ......
ÕâÀïÏëÁ˽âÏ£¬¹ØÓÚSQL ServerÖзÖÒ³ºÍOracleÖзÖÒ³£» ƽ³£Ð´Ó¦ÓóÌÐòµÄʱºò£¬±ÈÈçÓõÄÓïÑÔÊÇJava£¬ÓиöÁбíÒ³Ã棬ÐèÒª¶ÔÊý¾Ý·ÖÒ³ÏÔʾ£» ÕâÀïÒª·ÖÒ³ÄѵÀ²»ÐèÒª½èÖúJava£¬¶øÖ±½ÓsqlÄÜÖªµÀ·ÖÒ³Âð£¬ÆðÂëÒ²Òª´«¸öÒ³Âë½ ......
ÏÖÔÚÓÐÒ»¸ö²¿Ãűídept£¨²¿ÃÅÃû³Æ£¬²¿Ãźš£¡££©ÓÐÒ»¸öÈËÔ±±íemp£¨ÐÕÃû£¬ÈËÔ±±àºÅ£¬Ö°Î»£¬Ð½×Ê£¬²¿ÃÅ£© emp±íÖеÄÄÚÈÝÊÇÕâÑùµÄ£º a 1 ¹¤³Ìʦ 3000 Èí¼þ²¿ b 2 ÆÕͨԱ¹¤ 2000 Ó²¼þ²¿ c 3 ¹¤³Ìʦ 4000 Ó²¼þ²¿ d ......