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×Ö¶Î. ÎÒ˵ÊÇ£¬ËûÕÕ×öÁË£¬ºóÀ´»ØÀ´Ëµ£¬Ì«ºÃÁË£¬ÎÊÌâ½â¾öÁË¡£
Ïà¹ØÎĵµ£º
È«ÎļìË÷ÊǶԴóÊý¾ÝÎı¾½øÐÐË÷Òý£¬ÔÚ½¨Á¢µÄË÷ÒýÖжÔÒª²éÕҵĵ¥´Ê½øÐнøÐÐËÑË÷£¬¶¨Î»ÄÄЩÎı¾Êý¾Ý°üÀ¨ÒªËÑË÷µÄµ¥´Ê¡£Òò´Ë£¬È«ÎļìË÷µÄÈ«²¿¹¤×÷¾ÍÊǽ¨Á¢Ë÷ÒýºÍÔÚË÷ÒýÖÐËÑË÷¶¨Î»£¬ËùÓеŤ×÷¶¼ÊÇΧÈÆÕâÁ½¸öÀ´½øÐеġ£ÏÂÃæ¾ÍÖð¸ö½éÉÜ¡£
¡¡¡¡½¨Á¢È«ÎÄË÷ÒýÖÐÓÐÁ½Ïî·Ç³£ÖØÒª£¬Ò»¸öÊÇÈçºÎ¶ÔÎı¾½øÐзִʣ¬Ò»Êǽ¨Á¢Ë÷ÒýµÄÊý¾Ý½á¹¹¡ ......
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 ......
ÒòΪ¹¤×÷ÐèÒª£¬Êý¾Ý¿âʹÓõÄMS SQL Server2005£¬¶øĬÈϵÄÅÅÐò¹æÔòÊÇSQL_Latin1_General_CP1_CI_AS¡£´´½¨ÁËÒ»¸ö±í£¬ÒòΪÐèÒª´æ´¢ÖÐÎÄÐÅÏ¢£¬Address×ֶεÄÀàÐÍÊÇnvarchar(255)¡£
´ËʱʹÓÃphpÀ´Á¬½Ósql server£¬Ò³ÃæµÄ±àÂëºÍÎļþµÄ±àÂ붼ÊÇUTF-8£¬²éѯ´ËAddress×ֶΣ¬ÏÔʾÔÚÒ³ÃæÉÏÊÇ???Ö®ÀàµÄ¡£Ôõô½â¾ö£¿
ʹÓÃ
iconv('iso- ......
ÏÂÎçÐèÒªÅäÖñ¾»ú°²×°µÄmssqlÊý¾Ý¿âÄܹ»ÔÚÔ¶³Ì·ÃÎÊ£¬ÔÚÍøÉÏËÑË÷µÄ·½·¨£ºhttp://weste.net/2009/5-20/21244518910.html
°´ÕÕÕâ¸ö²½ÖèÒ»²½Ò»²½ÅäÖÃÏÂȥȴ·¢ÏÖÈÔÈ»²»ÄÜ·ÃÎÊ¡£Èç¹ûÅäÖÃprotocolµÄʱºòlisten all ÉèÖÃΪno£¬ÖØÆômssql·þÎñϵͳ»áÌáʾmssql·þÎñ×Ô¶¯Í£Ö¹£»Èç¹ûÉèÖÃΪyes¿ÉÒÔÆô¶¯È´ÔÚnetstatÁбíÖÐÎÞ·¨¼ì²éµ½¶Ô1433¶ ......
ÔÚƽʱµÄ¹¤×÷¹ý³ÌÖУ¬×÷ΪDBA½ÇÉ«¹ÜÀíÊý¾Ý¿â£¬Í·ÄÔÖеÄÓ¡ÏóÍùÍùÊÇÊý¾Ý¿âʵÀýÃû³Æ£¬¶ø²»»áÈ¥¹ØÐÄServerµÄIP£¬¶ø×÷ΪDeveloperµÄ½ÇÉ«£¬ËûÃÇÍùÍùÏëÖªµÀÖªµÀServer IpºÍ¶Ë¿ÚºÅ¡£ËùÒÔ£¬DBA»á¾³£±»Îʼ°µ½£ºXXXʵÀýµÄIPºÍ¶Ë¿ÚºÅÊÇʲô£¿
Õâ¸öÎÊÌ⣬µ±È»ÎÒÃÇ¿ÉÒÔLoginµ½OS²é¿´IP¡¢Ê¹ÓÃÅäÖƹÜÀí¹¤¾ß»ñÈ¡µ½¶Ë¿ÚºÅ¡£µ«ÊÇ£¬Õâ¸ö·½·¨·Ç ......