Ò׽ؽØÍ¼Èí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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ͨÓ÷ÖÒ³´æ´¢¹ý³Ì£¬×Ö·û·Ö¸ôº¯Êý

·ÖÒ³´æ´¢¹ý³Ì
sp_QueryPaging
set ANSI_NULLS ON
set QUOTED_IDENTIFIER ON
go
-- =============================================
-- Author:
-- Create date:
-- Description: ·ÖÒ³²éѯ
-- ·µ»ØµÄÊý¾ÝÖÐ×ÜÊÇÔÚÿÌõ¼Ç¼ǰ¼ÓÉÏÐкÅRowNumberÁС£
-- Èç¹ûδָ¶¨@StrSelect²ÎÊý£¬Ï൱ÓÚÉèÖÃËüΪ'*'
-- Èç¹ûδ ......

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

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

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

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

SQLServerÔ¶³Ì·ÃÎÊÅäÖÃ

ÏÂÎçÐèÒªÅäÖñ¾»ú°²×°µÄmssqlÊý¾Ý¿âÄܹ»ÔÚÔ¶³Ì·ÃÎÊ£¬ÔÚÍøÉÏËÑË÷µÄ·½·¨£ºhttp://weste.net/2009/5-20/21244518910.html
°´ÕÕÕâ¸ö²½ÖèÒ»²½Ò»²½ÅäÖÃÏÂȥȴ·¢ÏÖÈÔÈ»²»ÄÜ·ÃÎÊ¡£Èç¹ûÅäÖÃprotocolµÄʱºòlisten all ÉèÖÃΪno£¬ÖØÆômssql·þÎñϵͳ»áÌáʾmssql·þÎñ×Ô¶¯Í£Ö¹£»Èç¹ûÉèÖÃΪyes¿ÉÒÔÆô¶¯È´ÔÚnetstatÁбíÖÐÎÞ·¨¼ì²éµ½¶Ô1433¶ ......

c#ÖиßЧµÄexcelµ¼ÈësqlserverµÄ·½·¨

±¾ÎÄת×Ô£ºhttp://blog.csdn.net/jinjazz/archive/2008/07/14/2650506.aspx
    ½«oledb¶ÁÈ¡µÄexcelÊý¾Ý¿ìËÙ²åÈëµÄsqlserverÖУ¬ºÜ¶àÈËͨ¹ýÑ­»·À´Æ´½Ósql£¬ÕâÑù×ö²»µ«ÈÝÒ׳ö´í¶øÇÒЧÂʵÍÏ£¬×îºÃµÄ°ì·¨ÊÇʹÓÃbcp£¬Ò²¾ÍÊÇSystem.Data.SqlClient.SqlBulkCopy ÀàÀ´ÊµÏÖ¡£²»µ«Ëٶȿ죬¶øÇÒ´úÂë¼òµ¥£¬ÏÂÃæ²âÊÔ´ú ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ