Êý¾Ý¿â»Ö¸´¹¤¾ß£¬Log Explorer for SQL Server v4.0
SQLÊý¾Ý»Ö¸´Èí¼þ Log Explorer for SQL Server v4.0
log explorerʹÓõļ¸¸öÎÊÌâ
¡¡¡¡1)¶ÔÊý¾Ý¿â×öÁËÍêÈ« ²îÒì ºÍÈÕÖ¾±¸·Ý
¡¡¡¡±¸·ÝʱѡÓÃÁËɾ³ýÊÂÎñÈÕÖ¾Öв»»î¶¯µÄÌõÄ¿
¡¡¡¡ÔÙÓÃLog explorer´òÊÔͼ¿´ÈÕ־ʱ
¡¡¡¡ÌáʾNo log recorders found that match the filter£¬would you like to view unfiltered data
¡¡¡¡Ñ¡Ôñyes ¾Í¿´²»µ½¸Õ²ÅµÄ¼Ç¼ÁË
¡¡¡¡Èç¹û²»Ñ¡ÓÃÁËɾ³ýÊÂÎñÈÕÖ¾Öв»»î¶¯µÄÌõÄ¿
¡¡¡¡ÔÙÓÃLog explorer´òÊÔͼ¿´ÈÕ־ʱ£¬¾ÍÄÜ¿´µ½ÔÀ´µÄÈÕÖ¾
¡¡¡¡2)ÐÞ¸ÄÁËÆäÖÐÒ»¸ö±íÖеIJ¿·ÖÊý¾Ý£¬´ËʱÓÃLog explorer¿´ÈÕÖ¾£¬¿ÉÒÔ×÷ÈÕÖ¾»Ö¸´
¡¡¡¡3)È»ºó»Ö¸´±¸·Ý£¬(×¢Òâ:»Ö¸´ÊǶϿªlog explorerÓëÊý¾Ý¿âµÄÁ¬½Ó£¬»òÁ¬½Óµ½ÆäËûÊý¾ÝÉÏ£¬
¡¡¡¡·ñÔò»á³öÏÖÊý¾Ý¿âÕýÔÚʹÓÃÎÞ·¨»Ö¸´)
¡¡¡¡»Ö¸´Íêºó£¬ÔÙ´ò¿ªlog explorer ÌáʾNo log recorders found that match the filter£¬would you like to view unfiltered data
¡¡¡¡Ñ¡Ôñyes ¾Í¿´²»µ½¸Õ²ÅÔÚ2ÖÐÐ޸ĵÄÈÕÖ¾¼Ç¼£¬ËùÒÔÎÞ·¨×ö»Ö¸´.
¡¡¡¡4)²»ÒªÓÃSQLµÄ±¸·Ý¹¦Äܱ¸·Ý,¸ã²»ºÃÄãµÄÈÕÖ¾¾ÍÆÆ»µÁË.
¡¡¡¡ÕýÈ·µÄ±¸·Ý·½·¨ÊÇ:
¡¡¡¡Í£Ö¹SQL·þÎñ,¸´ÖÆÊý¾ÝÎļþ¼°ÈÕÖ¾Îļþ½øÐÐÎļþ±¸·Ý.
¡¡¡¡È»ºóÆô¶¯SQL·þÎñ,ÓÃlog explorer»Ö¸´Êý¾Ý
¡¡¡¡5)Èç¹ûÄãµÄÊý¾Ý¿âµÄÈÕÖ¾»Ö¸´Ä£ÐÍÊÇsimple,ÄǾͲ»¿ÉÄÜÓÃlog explorer»Ö¸´
¡¡¡¡6)Log explorer±ØÐë°²×°ÔÚÒª»Ö¸´Êý¾Ý¿âµÄsql server·þÎñÆ÷ÉÏ,»òÕßÔÚsql server·þÎñÆ÷ÉÏ°²×°·þÎñ¶Ë,ÔÚ²Ù×÷µÄµçÄÔÉÏ°²×°¿Í»§¶Ë½øÐÐÊý¾Ý»Ö¸´
ÏÂÔصØÖ·£ºhttp://download.csdn.net/source/1485023
Ïà¹ØÎĵµ£º
±í½á¹¹ºÍÊý¾ÝÈçÏ£¨±íÃûTest£©£º
NO VALUE NAME
1 a ²âÊÔ1
1 b ²âÊÔ2
1 c ......
1.°´ÐÕÊϱʻÅÅÐò:
Select * from TableName Order By CustomerName Collate Chinese_PRC_Stroke_ci_as
2.·ÖÒ³SQLÓï¾ä
select * from(select (row_number() OVER (ORDER BY tab.ID Desc)) as rownum,tab.* from ±íÃû As tab) As t where rownum between ÆðʼλÖà And ½áÊøλÖÃ
3.»ñÈ¡µ±Ç°Êý¾Ý¿âÖеÄËùÓÐÓû§± ......
getdate //»ñµÃϵͳµ±Ç°ÈÕÆÚ
datepart //»ñÈ¡ÈÕÆÚÖ¸¶¨²¿·Ö£¨ÄêÔÂÈÕʱ·Ö±í£©
getdate()º¯Êý£ºÈ¡µÃϵͳµ±Ç°µÄÈÕÆÚºÍʱ¼ä¡£·µ»ØֵΪdatetimeÀàÐ͵ġ£
Ó÷¨£ºgetdate()
Àý×Ó£º
select getdate() as dte,dateadd(day,-1,getdate()) as nowdat
Êä³ö½á¹û£º
dte nowdat
--------------------------- ----------------- ......
1.update a set a.nickname=b.nickname from tab1 a,tab2 b where a.username=b.username
2.Update student_score set
student_score.level=level_about.level from
level_about where student.score
between level_about.start_score and level_about.end_score ......
×ö¿ª·¢µÄ¹ý³ÌÖо³£Óõ½Êý¾Ý¿âÔ¶³ÌÁ¬½ÓµÄÎÊÌ⣬ÓÐʱºòŪÁË°ëÌìÒ²½â¾ö²»ÁË£¬ÕâÀï¸ù¾ÝÎÒ×Ô¼ºµÄÒ»µã¾Àú¶ÔSQL ServerÔ¶³ÌÁ¬½ÓÎÊÌâ×öÒ»×ܼơ£
Ê×ÏÈÕâÀïÖ÷Ҫ˵µÄÊÇSQL Server 2005²»ÊÇ2000£¬ÒòΪ2000ÓÐһЩСµÄÀýÍ⣬ÀýÈç°²×°sp4²¹¶¡µÈ£¬ÕâÀï²»ÔÙÌÖÂÛ¡£ÊÂʵÉÏÎÒ ......