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

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)º¯ÊýºÍÈ¥³ý´¥·¢Æ÷¡£


Ïà¹ØÎĵµ£º

sqlserver bcpÃüÁ¿ìËÙ´¦Àí´óÊý¾Ý

bcpÃüÁîÊÇSQL ServerÌṩµÄÒ»¸ö¿ì½ÝµÄÊý¾Ýµ¼Èëµ¼³ö¹¤¾ß¡£Ê¹ÓÃËü²»ÐèÒªÆô¶¯ÈκÎͼÐιÜÀí¹¤¾ß¾ÍÄÜÒÔ¸ßЧµÄ·½Ê½µ¼Èëµ¼³öÊý¾Ý¡£bcpÊÇSQL ServerÖиºÔðµ¼Èëµ¼³öÊý¾ÝµÄÒ»¸öÃüÁîÐй¤¾ß£¬ËüÊÇ»ùÓÚDB-LibraryµÄ£¬²¢ÇÒÄÜÒÔ²¢Ðеķ½Ê½¸ßЧµØµ¼Èëµ¼³ö´óÅúÁ¿µÄÊý¾Ý¡£bcp¿ÉÒÔ½«Êý¾Ý¿âµÄ±í»òÊÓͼֱ½Óµ¼³ö£¬Ò²ÄÜͨ¹ýSELECT fromÓï¾ä¶Ô±í»òÊÓ ......

MyEclipseÖÐÅäÖÃSQLServer 2005Êý¾Ý¿â


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Îļþ£¬ÒÔǰµÄÎÄÕÂÖÐÒѾ­½²¹ ......

PHP²éѯÏÔʾSqlServerÖеÄÖÐÎÄ

ÒòΪ¹¤×÷ÐèÒª£¬Êý¾Ý¿âʹÓõÄMS SQL Server2005£¬¶øÄ¬ÈϵÄÅÅÐò¹æÔòÊÇSQL_Latin1_General_CP1_CI_AS¡£´´½¨ÁËÒ»¸ö±í£¬ÒòΪÐèÒª´æ´¢ÖÐÎÄÐÅÏ¢£¬Address×ֶεÄÀàÐÍÊÇnvarchar(255)¡£
´ËʱʹÓÃphpÀ´Á¬½Ósql server£¬Ò³ÃæµÄ±àÂëºÍÎļþµÄ±àÂë¶¼ÊÇUTF-8£¬²éѯ´ËAddress×ֶΣ¬ÏÔʾÔÚÒ³ÃæÉÏÊÇ???Ö®ÀàµÄ¡£Ôõô½â¾ö£¿
ʹÓÃ
iconv('iso- ......

SQLSERVER¾Û¼¯Ë÷ÒýÓë·Ç¾Û¼¯Ë÷Òý£¨×ª£©

΢ÈíµÄSQL SERVERÌṩÁËÁ½ÖÖË÷Òý£º¾Û¼¯Ë÷Òý(clustered index£¬Ò²³Æ¾ÛÀàË÷Òý¡¢´Ø¼¯Ë÷Òý)ºÍ·Ç¾Û¼¯Ë÷Òý(nonclustered index£¬Ò²³Æ·Ç¾ÛÀàË÷Òý¡¢·Ç´Ø¼¯Ë÷Òý)……
(Ò»)ÉîÈëdz³öÀí½âË÷Òý½á¹¹
ʵ¼ÊÉÏ£¬Äú¿ÉÒÔ°ÑË÷ÒýÀí½âΪһÖÖÌØÊâµÄĿ¼¡£Î¢ÈíµÄSQL SERVERÌṩÁËÁ½ÖÖË÷Òý£º¾Û¼¯Ë÷Òý(clustered index£¬Ò²³Æ¾ÛÀàË÷Òý¡¢´ ......

SQLserverʱ¼ä¶Î²éѯ

eg:
select * from Exception_Log where DATEDIFF(day,OPER_DATE,getdate())<30 ;
/*
oper_date Ϊ±íÖвéѯ³öÀ´µÄʱ¼ä
getdate()ΪSQLServerÀïÃæ»ñµÃϵͳʱ¼äµÄº¯Êý
º¬Ò壺µ±Ç°Ê±¼ä-²éѯ³öÀ´µÄʱ¼äСÓÚ30Ìì
DateDiff¾ßÌåÓ÷¨£º
*/
DateDiff º¯Êý
·µ»ØÁ½¸öÈÕÆÚÖ®¼äµÄʱ¼ä¼ä¸ô¡£
DateDiff(interval, date1, da ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ