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

SqlServer²åÈëÂýµÄÎÊÌâ½â¾ö

Õâ¸öÊÇÎÒ¼ÓÈëµÄQQȺÀïÃæÒ»¸öÍøÓÑÎʵÄÎÊÌâ¡£Ëû˵һ¸ö±í×öÒ»¸öINSERT¶¼»á³¬Ê±¡£ÕýÀ§»óÄØ£¬ÏòȺÀïÃæµÄÈËÇóÖú¡£ÎҸպöÔÕâ·½ÃæÖªµÀµã£¬¾Í»Ø´ðÁË˵ҪÓÅ»¯¾Û¼¯Ë÷Òý¡£Ëû²»Ã÷°×¾ßÌå¸ÃÔõô×ö£¬ËƺõÒ²²»ÖªµÀʲôÊǾۼ¯Ë÷Òý¡£ÎÒ¶ÔËû˵Äã¿ÉÒÔ¿´¿´Äã²åÈë¼Ç¼ʱµÄ´ÅÅÌIOÊÇ·ñ±È½Ï¶à£¬Ëû˵ËûµÄ´ÅÅÌÒѾ­»»³ÉÁËRAID£¬²»ºÃ²é¿´´ÅÅÌIO¡£OK, ÎÒ¼ÌÐøÌæËû·ÖÎöµÀ: ÄãÄǸöinsertÂýÊÇÒòΪÄãÿ´Î²åмǼ£¬Êý¾Ý¿â·þÎñÆ÷¶¼ÒªÔÚÖмäµÄÒ»¸öλÖòåÈ룬ÒýÆð´ÅÅÌÎļþµÄ´óÁ¿¶Áд. Ëû˵: ÈçºÎ½â¾ö?  ÎÒµÄÓ²¼þÅäÖÃÒѾ­Ã»·¨Éý¼¶ÁË. ÎÒ˵: Äã¿ÉÒÔ¿´¿´¾Û¼¯Ë÷Òý, ÒªÓÅ»¯¾Û¼¯Ë÷Òý. ËûËƺõ²»Ì«Ã÷°×, дÁËÏÂÃæÕâ䶫Î÷:
ÊÇÕâ¸öÂð£º
use WanerSoft2007
declare @table_id int
set @table_id=object_id('dbo.Ws_UserProInfo')
dbcc showcontig(@table_id)
dbcc dbreindex('dbo.Ws_UserProInfo','',0)
ÎÒ¿´ÁËÒ»ÏÂ, ˵ÕâÊÇÖØ×öË÷ÒýµÄÅú´¦Àí£¬²»ÊǾۼ¯Ë÷Òý.ÎÒ¼ÌÐø˵µÀ:¾Û¼¯Ë÷ÒýÊÇÖ¸¼Ç¼µÄÎïÀí°Ú·Å´ÎÐò¼´°´ÕÕ¾Û¼¯Ë÷ÒýÀ´×öµÄ¡£ÊÇ×îÖØÒªµÄÒ»¸öË÷Òý£¬¾Û¼¯Ë÷ÒýÉè¼ÆµÄºÃ£¬¶àÖÖÊý¾Ý¿â²Ù×÷¶¼¿ÉÒÔ»ñµÃºÃµÄÐÔÄÜ¡£Éè¼ÆµÄ²»ºÃ¾Í»áÒýÆðÐÔÄÜÉϵľ޴ó²îÒì, ±ÈÈç²åÈë²Ù×÷, Éè¼ÆµÃºÃʱ£¬Ð¼Ç¼ֻÐèÒªÔÚÎïÀíµÄ×îºóÌí¼Ó¾Í¿ÉÒÔÁË£¬²»ÐèÒªÒƶ¯ºÜ¶à¼Ç¼£¬ËùÒԿ죬Éè¼ÆµÃ²»ºÃʱ£¬Ð¼Ç¼¾ÍÊÇÔÚÎïÀíÉϵÄÖмäij¸öλÖòåÈ룬ÄÇô¾Í±ØÐëÒƶ¯ºÜ¶à¼Ç¼£¬¾Í»áÓдóÁ¿µÄ´ÅÅÌIO¡£ËûÈ¥ÕÒÁËÒ»»á£¬»ØÀ´¸øÎÒÌùÁ˸öͼ:
ÎÒ¿´ÁËͼ£¬¶ÔËû˵¾Û¼¯Ë÷ÒýҪѡÓö̵Ä×ֶΣ¬»¹Òªµ¥ÏòµÝÔö£¬¿ÉÒÔÑ¡ÈÕÆÚ£¬identityµÈ¡£ËûÕâ»Ø¾ÍÃ÷°×ÁË£¬ÎÊÊDz»ÊǾۼ¯Ë÷ÒýÀïÃæÈ¥µôbookidºÍnclassid×Ö¶Î. ÎÒ˵ÊÇ£¬ËûÕÕ×öÁË£¬ºóÀ´»ØÀ´Ëµ£¬Ì«ºÃÁË£¬ÎÊÌâ½â¾öÁË¡£


Ïà¹ØÎĵµ£º

È«ÎÄË÷ÒýÔ­Àí¼°ÆäʾÀý£¨sqlserver£©

È«ÎļìË÷ÊǶԴóÊý¾ÝÎı¾½øÐÐË÷Òý£¬ÔÚ½¨Á¢µÄË÷ÒýÖжÔÒª²éÕҵĵ¥´Ê½øÐнøÐÐËÑË÷£¬¶¨Î»ÄÄЩÎı¾Êý¾Ý°üÀ¨ÒªËÑË÷µÄµ¥´Ê¡£Òò´Ë£¬È«ÎļìË÷µÄÈ«²¿¹¤×÷¾ÍÊǽ¨Á¢Ë÷ÒýºÍÔÚË÷ÒýÖÐËÑË÷¶¨Î»£¬ËùÓеŤ×÷¶¼ÊÇΧÈÆÕâÁ½¸öÀ´½øÐеġ£ÏÂÃæ¾ÍÖð¸ö½éÉÜ¡£
¡¡¡¡½¨Á¢È«ÎÄË÷ÒýÖÐÓÐÁ½Ïî·Ç³£ÖØÒª£¬Ò»¸öÊÇÈçºÎ¶ÔÎı¾½øÐзִʣ¬Ò»Êǽ¨Á¢Ë÷ÒýµÄÊý¾Ý½á¹¹¡ ......

Oracle´æ´¢¹ý³Ìת³ÉSqlserver´æ´¢¹ý³Ì

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 ......

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¶ ......

ʹÓÃT SQL»ñÈ¡µ½SQLServer IpºÍ¶Ë¿ÚºÅ

ÔÚƽʱµÄ¹¤×÷¹ý³ÌÖУ¬×÷ΪDBA½ÇÉ«¹ÜÀíÊý¾Ý¿â£¬Í·ÄÔÖеÄÓ¡ÏóÍùÍùÊÇÊý¾Ý¿âʵÀýÃû³Æ£¬¶ø²»»áÈ¥¹ØÐÄServerµÄIP£¬¶ø×÷ΪDeveloperµÄ½ÇÉ«£¬ËûÃÇÍùÍùÏëÖªµÀÖªµÀServer IpºÍ¶Ë¿ÚºÅ¡£ËùÒÔ£¬DBA»á¾­³£±»Îʼ°µ½£ºXXXʵÀýµÄIPºÍ¶Ë¿ÚºÅÊÇʲô£¿
Õâ¸öÎÊÌ⣬µ±È»ÎÒÃÇ¿ÉÒÔLoginµ½OS²é¿´IP¡¢Ê¹ÓÃÅäÖƹÜÀí¹¤¾ß»ñÈ¡µ½¶Ë¿ÚºÅ¡£µ«ÊÇ£¬Õâ¸ö·½·¨·Ç ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØͼ | ¸ÓICP±¸09004571ºÅ