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µÄ¿ÉÄÜÐÔ»Ò³£´ó
Ϊʲôtextdata Ϊ null ÎÒÏëÖªµÀ´Ëʱ sql server ÔÚ×öʲô£¿
Ïà¹ØÎÊ´ð£º
select convert(varchar(50),cast(convert(numeric(18,2),1275674000000/100000000)as real))+'ÒÚ'
select cast(convert(numeric(18,2),1275674000000/100000000)as real)
ΪʲôÉÏÒ»¸öÓÃvarcharת»»ºó¾ÍÖ»±£ÁôÁËÒ ......
ÎÒÒ»¸öÏîÄ¿£¬Óиö²åÈë²Ù×÷£¬¾ßÌåÊÇÕâÑùµÄ£º
ÎÒÓнø»õÐÅÏ¢±í¡£ÔÚ³ö»õʱѡÔñÏàÓ¦µÄ½ø»õÐÅÏ¢£¬ÊäÈëÊýÁ¿£¬Ñ¡Ôñ²¿Ãź󣬵㱣´æ°´Å¥£¬ÓÉÓÚÍøÂçÑÓʱ£¬µãÒ»ÏÂûÓз´Ó³£¬ÓÚÊÇÓû§¾ÍÓÖµãһϣ¬µ¼ÖÂÒ»´Î²åÈëÁËÁ½Ìõ¼Ç¼:
Àý£º
......
ÏÖÔÚÓÐÁ½ÕÅ±í£ºÎÄÕÂÖ÷±íA(articleId,articleTitle)£¬ÎÄÕÂÆÀÂÛ±íB(commentId,articleId,commentTitle)
ÏÖÔÚÎÒÏëʵÏÖÕâÑùµÄ¹¦ÄÜ£ºÁгöÎÄÕÂÁÐ±í£¬ÆäÖÐÿƪÎÄÕ±êÌâÏÂÃæÁгö´ËÎÄÕµÄǰ2¸öÎÄÕÂÆÀÂÛ£¬ÇëÎÊsqlÓï¾äÔõôд°¡ ......