SqlServerÖÐÓÃ@@IDENTITYÈ¡×îÐÂID²»×¼µÄÎÊÌâ
Ò»¸öÍøÓÑÎÊÎÒÒ»¸ö¹ØÓÚ@@IDENTITYµÄÎÊÌâ¡£ËûµÄÊý¾Ý¿âÖÐÓÐÒ»¸ö´æ´¢¹ý³Ì£¬ÓÐ insertÓï¾ä£¬È»ºóÂíÉϾÍÓÃSELECT @@IDENTITYÈ¡¸Õ²åÈëµÄIDÖµ£¬Í¨³£ÕâÊÇûÓÐÎÊÌâµÄ£¬µ«ÊÇÎÊÌâÊÇIDʵ¼ÊÉÏÒѾ´ïµ½ÁË100¶àÍòÁË£¬¶ø SELECT @@IDENTITY ·µ»ØµÄÖ»ÓкÜСµÄÖµ(²Å30¶à)£¬ÁîÈ˷ѽ⡣
ÎÒ¿ªÊ¼Ò²²»Ì«Ã÷°×£¬ÎÊËûÏȱð¹Ü@@IDENTITY£¬Ð²åÈë¼Ç¼£¬IDÊǶàÉÙ¡£Ëû˵IDÊÇ100¶àÍòÄÇô´óµÄÊý¡£²»ÊDzż¸Ê®ÄÇôС¡£ÎÒ°ïËû·ÖÎö¿ÉÄÜÐÔ£¬ÊDz»ÊÇidentityµ½ÁË×î´óÏÞ£¬ÇÒidentity×î´óÊÇ2µÄ64´Î·½¡£Ëû˵int ×î´óÖµÊÇ 2,147,483,647£¬ËûµÄIDÀëÒç³ö»¹ÔçÄØ£¬ µ«ÊÇ return @@IDENTITY ¾ÍÊÇ ºÜСµÄÖµ£¨Ö»Óм¸Ê®)¡£ÎÒÈ»ºóÓÖ°ïËû·ÖÎöµÀ£¬ÊDz»ÊÇIDµÄÖµ±»ÖØÖùý£¿Ëû˵²»ÊÇ£¬Ëû˵ÏÖÔÚвåÈëµÄ id ¾ÍÊÇ 170¶àÍò¡£Ëµµ½ÕâÀÎÒÁ˽âÁËÒ»µãÁË¡£ÎÒ½¨ÒéËûÓÃscope_identity(table_name)º¯ÊýÀ´È¡Ö¸¶¨±íµÄIDENTITY¡£ÎÒÃÇÒÔǰÓйý¾Ñ飬@@IDENTITYºÍIDENTITY_CURRENT()¶¼²»ÊǺÜÀíÏ룬ÒòΪËüÃÇ»áÊܵ±Ç°±íµÄ·¶Î§Ó°Ï졣ͨ³£Óд¥·¢Æ÷¾Í»áÒýÆð@@IDENTITY²»ÄÜÕýÈ·µØÈ¡Öµ£¬IDENTITY_CURRENT()Ò²ÊÇÈç´Ë¡£ÐÒºÃÓÐscope_identity(table_name)º¯Êý¡£ÔÚÕâÖÖÇé¿öϾÍÖ»ÄÜÓÃÕâ¸ö¡£ÕâʱËû²ÅÏëÆðÀ´£¬ËûµÄ±íÓд¥·¢Æ÷¡£ºÇºÇ£¬³ÙÁ˵㡣ÎÒ½¨ÒéËû×îºÃ²»ÒªÓô¥·¢Æ÷¡£ÄܱÜÃâ¾Í±ÜÃâ¡£Ëû˵Õâ¸ö´¥·¢Æ÷ÊÇ¿ÉÒÔÓñðµÄ·½Ê½´úÌæµÄ¡£Ëû»áÊÔÒ»ÏÂÓÃscope_identity(table_name)º¯ÊýºÍÈ¥³ý´¥·¢Æ÷¡£
Ïà¹ØÎĵµ£º
È«ÎļìË÷ÊǶԴóÊý¾ÝÎı¾½øÐÐË÷Òý£¬ÔÚ½¨Á¢µÄË÷ÒýÖжÔÒª²éÕҵĵ¥´Ê½øÐнøÐÐËÑË÷£¬¶¨Î»ÄÄЩÎı¾Êý¾Ý°üÀ¨ÒªËÑË÷µÄµ¥´Ê¡£Òò´Ë£¬È«ÎļìË÷µÄÈ«²¿¹¤×÷¾ÍÊǽ¨Á¢Ë÷ÒýºÍÔÚË÷ÒýÖÐËÑË÷¶¨Î»£¬ËùÓеŤ×÷¶¼ÊÇÎ§ÈÆÕâÁ½¸öÀ´½øÐеġ£ÏÂÃæ¾ÍÖð¸ö½éÉÜ¡£
¡¡¡¡½¨Á¢È«ÎÄË÷ÒýÖÐÓÐÁ½Ïî·Ç³£ÖØÒª£¬Ò»¸öÊÇÈçºÎ¶ÔÎı¾½øÐзִʣ¬Ò»Êǽ¨Á¢Ë÷ÒýµÄÊý¾Ý½á¹¹¡ ......
Oracle´æ´¢¹ý³Ìת³ÉSqlserver´æ´¢¹ý³Ì
1.ÈÕÆÚת»»
Oracle£º TO_NUMBER(TO_CHAR(SYSDATE, 'YYYYMMDD'))
SqlServer£ºCAST(CONVERT(CHAR(8),GETDATE(), 112) AS INT)
×¢£ºÆäÖБYYYYMMDD’¸ñʽ ¶ÔÓ¦112
2.ROWIDת»»
Oracle£º ROWID
SqlServer: PRIMARY KEY(±íÖ÷¼ü)
3.ROWNUM ......
1.°²×°ºÃSQLServer 2005Êý¾Ý¿âÈí¼þ£¬½Ó×Å×îÖØÒªµÄ¾ÍÊǰ²×°Êý¾Ý¿âÇý¶¯SQL Server 2005 driver for JDBC£¬¿ÉÒÔµ½:http://download.microsoft.com/download/8/B/D/8BDABAE2-B6EA-41D4-B903-7916EF3690EF/sqljdbc_1.2.2323.101_enu.exeÏÂÔØ
2.½«JDBC½âѹµ½ÈÎÒâµÄλÖã¬ÔÚ°²×°Ä¿Â¼ÀïÕÒµ½sqljdbc.jarÎļþ£¬ÒÔǰµÄÎÄÕÂÖÐÒѾ½²¹ ......
1.°²×°ºÃSQLServer 2005Êý¾Ý¿âÈí¼þ£¬½Ó×Å×îÖØÒªµÄ¾ÍÊǰ²×°Êý¾Ý¿âÇý¶¯SQL Server 2005 driver for JDBC£¬¿ÉÒÔµ½:http://download.microsoft.com/download/8/B/D/8BDABAE2-B6EA-41D4-B903-7916EF3690EF/sqljdbc_1.2.2323.101_enu.exeÏÂÔØ
2.½«JDBC½âѹµ½ÈÎÒâµÄλÖã¬ÔÚ°²×°Ä¿Â¼ÀïÕÒµ½sqljdbc.jarÎļþ£¬ÒÔǰµÄÎÄÕÂÖÐÒѾ½²¹ý» ......