Ò׽ؽØͼÈí¼þ¡¢µ¥Îļþ¡¢Ãâ°²×°¡¢´¿ÂÌÉ«¡¢½ö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×Ö¶Î. ÎÒ˵ÊÇ£¬ËûÕÕ×öÁË£¬ºóÀ´»ØÀ´Ëµ£¬Ì«ºÃÁË£¬ÎÊÌâ½â¾öÁË¡£


Ïà¹ØÎĵµ£º

oracleºÍsqlserver²éѯʱ×èÈûÇé¿ö

1.oracle»·¾³
create table test
(
id number(4),
name varchar2(20)
)
ÔÚÒ»¸ösessionÖÐ
insert into test values(1,'aa');
ÔÚÁíÒ»¸ösessionÖÐ
select * from test1;
²éѯû±»×èÈû
2.sqlserver»·¾³
ÔÚÒ»¸ösessionÖÐ
insert into test values(1,'aa');
ÔÚÁíÒ»¸ösessionÖÐ
select * from test1;
²éѯ±»×èÈû(Ê ......

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Óû§È¨ÏÞ¹ÜÀíÊý¾Ý¿â

Óû§È¨ÏÞ¹ÜÀí
Ò»¡¢·þÎñÆ÷µÇ¼ÕʺźÍÓû§ÕʺŹÜÀí
1.SQL Server·þÎñÆ÷µÇ¼¹ÜÀí
²»¹ÜʹÓÃÄÄÖÖÈÏ֤ģʽ£¬Óû§¶¼±ØÐëÏȾ߱¸ÓÐЧµÄÓû§µÇ¼Õʺš£SQL ServerÓÐÈý¸öĬÈϵÄÓû§µÇ¼Õʺţº¼´sa¡¢Builtin\administratorsºÍguest¡£saÊÇϵͳ¹ÜÀíÔ±(system administrator)µÄ¼ò³Æ£¬ÊÇÒ»¸öÌØÊâµÄÓû§£¬ÔÚSQL ServerϵͳºÍËùÓÐÊý¾Ý¿âÖÐÓ ......

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ºÅ