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

sql server ÐÔÄÜ

´óÏÀ£¬°ïÎÒ·ÖÎöһϠprofiler Êý¾Ý¡£.Net SqlClient Data Provider Ϊʲô»áºÄʱÕâô³¤£¿¶øtextdata Ϊ null
ÕâÊÇ×öʲôµÄ£¿
http://img153.ph.126.net/5ZTOFky7l6Ien9Nrvs5yNw==/3032048449128539202.jpg
ÎÞͼÎÞÕæÏà



Ã×ͼƬ,×Ô¼º·ÖÎöÒ»ÏÂÖ´Ðмƻ®,¿´ÄĸöÏûºÄ¶à

ÎÞͼÎÞÕæÏà............

Êý¾ÝÈçÏ£º
EventClass:15
TextData:NULL
ApplicationName:.Net SqlClient Data Provider
LoginName:sa
CPU:0
Reads:3441
Writes:57
Duration:2341780
ClientProcessID:3812
SPID:103

Ҫô±»¿¨ÁË
Ҫôio ³öÁËÎÊÌâ

Duration:2341780

±»blockµÄ¿ÉÄÜÐÔ»Ò³£´ó

ÒýÓÃ
Duration:2341780

±»blockµÄ¿ÉÄÜÐÔ»Ò³£´ó


Ϊʲôtextdata Ϊ null  ÎÒÏëÖªµÀ´Ëʱ sql server ÔÚ×öʲô£¿


Ïà¹ØÎÊ´ð£º

sqlת»»ÎÊÌ⣬¼±£¡ - ÉçÇøÖ§³Ö / ¡¶³ÌÐòÔ±¡·ÔÓÖ¾

select convert(varchar(50),cast(convert(numeric(18,2),1275674000000/100000000)as real))+'ÒÚ'
select cast(convert(numeric(18,2),1275674000000/100000000)as real)
ΪʲôÉÏÒ»¸öÓÃvarcharת»»ºó¾ÍÖ»±£ÁôÁËÒ ......

Asp+sql serverÎÊÌâ - Web ¿ª·¢ / ASP

ÎÒÒ»¸öÏîÄ¿£¬Óиö²åÈë²Ù×÷£¬¾ßÌåÊÇÕâÑùµÄ£º
ÎÒÓнø»õÐÅÏ¢±í¡£ÔÚ³ö»õʱѡÔñÏàÓ¦µÄ½ø»õÐÅÏ¢£¬ÊäÈëÊýÁ¿£¬Ñ¡Ôñ²¿Ãź󣬵㱣´æ°´Å¥£¬ÓÉÓÚÍøÂçÑÓʱ£¬µãÒ»ÏÂûÓз´Ó³£¬ÓÚÊÇÓû§¾ÍÓÖµãһϣ¬µ¼ÖÂÒ»´Î²åÈëÁËÁ½Ìõ¼Ç¼:
Àý£º ......

ÇóÒ»sqlÓï¾ä - MS-SQL Server / ÒÉÄÑÎÊÌâ

ÏÖÔÚÓÐÁ½ÕÅ±í£ºÎÄÕÂÖ÷±íA(articleId,articleTitle)£¬ÎÄÕÂÆÀÂÛ±íB(commentId,articleId,commentTitle)
ÏÖÔÚÎÒÏëʵÏÖÕâÑùµÄ¹¦ÄÜ£ºÁгöÎÄÕÂÁÐ±í£¬ÆäÖÐÿƪÎÄÕ±êÌâÏÂÃæÁгö´ËÎÄÕµÄǰ2¸öÎÄÕÂÆÀÂÛ£¬ÇëÎÊsqlÓï¾äÔõôд°¡ ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ