¹ØÓÚMSSQLÖ´Ðиú×ÙÆ÷ÉèÖÃ
ÔÚʹÓÃmssqlserver profiler¸ú×ÙÕÐÖ´µÄSQLʱ,ÎÒÏëÖ±½Ó¸ú×ÙÖ´ÐÐʱ¼ä´óÓÚ3ÃëµÄSQLÓï¾ä,ÈçºÎÉèÖÃ?
¶ÔÓÚ¹ýÂËʱѡÔñ£ºtextData ÀàËÆÓÚʱ£¬ ÀïÃæÒª²»Òª¼Ó%%£¬ÈçÎÒ¸ú×Ù¶Ô±í£º OUSR µÄËùÓÐÖ´ÐÐÓï¾ä£¬ÀàËÆÓÚÀïÃæÊÇÖ±½Ó¼Èë OUSR »¹ÊÇ %OUSR%
Çë¸÷λÅóÓѰïæ£¬Ð»Ð»£¡
%OUSR%
?
%OUSR%
%OUSR%
%OUSR%
ÊǼÈë3»¹ÊÇ3000»¹ÊÇ3000000?
ÁíÍâ, ʼþÑ¡ÔñÖÐÑ¡Ôñ:SQL:BatchCompleted »¹ÊÇSQL:BatchStarting ,»¹ÊÇÁ½¸ö¶¼Ñ¡?
Ïà¹ØÎÊ´ð£º
ÏÖÔÚÁ¬µÄÒ»Ô¶³Ìmssql£¬Ã¿´Î²éѯ±È½ÏÂý£¬ÏÖÔÚÏëһϰÑËùÓмǼ²éѯ³öÀ´ÓÃÊý¾Ý¼¯±£´æÆðÀ´£¬È»ºóÕë¶ÔÊý¾Ý¼¯Ôٴβéѯɸѡ¡£
ÏÖÔÚÎÊÏÂÄǸöÊý¾Ý¼¯ÈçºÎ±£´æ²éѯ¼Ç¼£¬¶øÔٴβéѯ£¬¶àлÁË¡£
¿ÉÒÔ°ÑÊý¾Ý¼¯ÖеÄÊý¾Ý·Åµ½ÄÚ´ ......
Ìṩһ¸öÍêÕûµÄ¼òµ¥Ê¾Àý
µã»÷×¢²áµÄʱºò£¬°ÑÐÅϢͬʱע²áµ½mysqlµÄA±íºÍmssqlµÄA±í лл
×¢²á¹¦ÄÜ?? ÊÇʲôÒâ˼
ÒýÓÃ
PHP code//Á¬½Ómysql$insertmysql="insert into A values('$name', ......
¸ßнƸMsSQL DBA - ÉϺ£ - 5+¾Ñé - Ó¢Óï¿É¹µÍ¨
н×Ê20wÒÔÉÏ£¬ÍêÈ«open
..
ºÙºÙ£¬ÓÐÐËȤ¡£
ӦƸ¹ý..µ«ÊÇÓ¢Óï²»¹ý¹Ø...ÓôÃÆËÀÎÒÁË...
̫Զ
ÍêÈ«open ɶÒâ˼ ˸ø½âÊÍÏÂ
·¹ý£¬¿Éϧ£¬È¥²»ÁË
һР......
ÎÒÏëʹÓÃ×Ô¶¯±àºÅ£¬µ«ÊDz»ÖªµÀÈçºÎʹÓÃÖ¸¶¨µÄÀàÐÍ×÷Ϊ×Ô¶¯±àºÅѽ¡£
±ÈÈç˵ÎÒÏëÎÒµÄ×Ô¶¯±àºÅÊÇ£º
A001
A002
A003
ÕâÑùÓ¦¸ÃÈçºÎ²Ù×÷ѽ£¬¸ßÊÖÖ¸µã¡£
ÐèÒª×Ô¼ºÐ´´úÂëÍê³É×Ô¶¯±àºÅ
´¥·¢Æ÷ º¯Êý ´æ´¢¹ý ......
ƽ°²Ò¹¸øÃ»ÊÕµ½ÀñÎïµÄGG &&MM ÎÒÀ´ËÍÀñÎïÀ²¡£
ÊÕµ½ÀñÎïµÄ¾Í±ð½Ó·ÖÁË£¡ÒªÊǽӲ»µ½°Ñ×Ô¼ºµÄ³ôÍà×ÓÄóöÀ´£¬µÈÊ¥µ®ÀÏÈËÍíÉÏËÍÄã°É£¡
SF
bd
sf
À´jfµÄ
²»´©Íà×Ó
JAVA php JS MYSQL C# °æ¶¼·¢Í ......