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

¹ØÓÚMSSQLÖ´Ðиú×ÙÆ÷ÉèÖÃ

ÔÚʹÓÃmssqlserver profiler¸ú×ÙÕÐÖ´µÄSQLʱ,ÎÒÏëÖ±½Ó¸ú×ÙÖ´ÐÐʱ¼ä´óÓÚ3ÃëµÄSQLÓï¾ä,ÈçºÎÉèÖÃ?

¶ÔÓÚ¹ýÂËʱѡÔñ£ºtextData ÀàËÆÓÚʱ£¬ ÀïÃæÒª²»Òª¼Ó%%£¬ÈçÎÒ¸ú×Ù¶Ô±í£º  OUSR µÄËùÓÐÖ´ÐÐÓï¾ä£¬ÀàËÆÓÚÀïÃæÊÇÖ±½Ó¼Èë OUSR »¹ÊÇ %OUSR%

Çë¸÷λÅóÓѰïæ£¬Ð»Ð»£¡




%OUSR%
?

%OUSR%



%OUSR%

%OUSR%


ÊǼÈë3»¹ÊÇ3000»¹ÊÇ3000000?
ÁíÍâ, ʼþÑ¡ÔñÖÐÑ¡Ôñ:SQL:BatchCompleted »¹ÊÇSQL:BatchStarting ,»¹ÊÇÁ½¸ö¶¼Ñ¡?


Ïà¹ØÎÊ´ð£º

vc²Ù×÷mssqlһСÎÊÌâ

ÏÖÔÚÁ¬µÄÒ»Ô¶³Ìmssql£¬Ã¿´Î²éѯ±È½ÏÂý£¬ÏÖÔÚÏëһϰÑËùÓмǼ²éѯ³öÀ´ÓÃÊý¾Ý¼¯±£´æÆðÀ´£¬È»ºóÕë¶ÔÊý¾Ý¼¯Ôٴβéѯɸѡ¡£
ÏÖÔÚÎÊÏÂÄǸöÊý¾Ý¼¯ÈçºÎ±£´æ²éѯ¼Ç¼£¬¶øÔٴβéѯ£¬¶àлÁË¡£
¿ÉÒÔ°ÑÊý¾Ý¼¯ÖеÄÊý¾Ý·Åµ½ÄÚ´ ......

Ò»¸öÁ¬½ÓmysqlºÍmssqlµÄ×¢²á¹¦ÄÜ£¡100·Ö

Ìṩһ¸öÍêÕûµÄ¼òµ¥Ê¾Àý
µã»÷×¢²áµÄʱºò£¬°ÑÐÅϢͬʱע²áµ½mysqlµÄA±íºÍmssqlµÄA±í лл
×¢²á¹¦ÄÜ?? ÊÇʲôÒâ˼


ÒýÓÃ
PHP code//Á¬½Ómysql$insertmysql="insert into A values('$name', ......

¸ßнƸMsSQL DBA - ÉϺ£ - 5+¾­Ñé - Ó¢Óï¿É¹µÍ¨

¸ßнƸMsSQL DBA - ÉϺ£ - 5+¾­Ñé - Ó¢Óï¿É¹µÍ¨
н×Ê20wÒÔÉÏ£¬ÍêÈ«open
..

ºÙºÙ£¬ÓÐÐËȤ¡£

ӦƸ¹ý..µ«ÊÇÓ¢Óï²»¹ý¹Ø...ÓôÃÆËÀÎÒÁË...

̫Զ

ÍêÈ«open ɶÒâ˼ Ë­¸ø½âÊÍÏÂ

·¹ý£¬¿Éϧ£¬È¥²»ÁË

һР......

MSSQLµÄ×Ô¶¯±àºÅ£¬ÈçºÎÖ¸¶¨Ìض¨µÄÀàÐÍѽ£¿

ÎÒÏëʹÓÃ×Ô¶¯±àºÅ£¬µ«ÊDz»ÖªµÀÈçºÎʹÓÃÖ¸¶¨µÄÀàÐÍ×÷Ϊ×Ô¶¯±àºÅѽ¡£
±ÈÈç˵ÎÒÏëÎÒµÄ×Ô¶¯±àºÅÊÇ£º
A001
A002
A003
ÕâÑùÓ¦¸ÃÈçºÎ²Ù×÷ѽ£¬¸ßÊÖÖ¸µã¡£
ÐèÒª×Ô¼ºÐ´´úÂëÍê³É×Ô¶¯±àºÅ
´¥·¢Æ÷ º¯Êý ´æ´¢¹ý ......

ƽ°²Ò¹¸øÃ»ÊÕµ½ÀñÎïµÄGG &&MM ËÍ·Ö -MSSQL°æ

ƽ°²Ò¹¸øÃ»ÊÕµ½ÀñÎïµÄGG &&MM ÎÒÀ´ËÍÀñÎïÀ²¡£
ÊÕµ½ÀñÎïµÄ¾Í±ð½Ó·ÖÁË£¡ÒªÊǽӲ»µ½°Ñ×Ô¼ºµÄ³ôÍà×ÓÄóöÀ´£¬µÈÊ¥µ®ÀÏÈËÍíÉÏËÍÄã°É£¡
SF

bd

sf

À´jfµÄ

²»´©Íà×Ó

JAVA php JS MYSQL C# °æ¶¼·¢Í ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ