Çó½Ì¸÷λDBA´ó´ó£¬ÄãÃÇÈÕ³£¹¤×÷ÖÐÈçºÎ²é¿´ÊÂÎñÈÕÖ¾£¬ÔÚÓÐÈ˸ÉÁË»µÊºóÈçºÎ×·×Ùµ½ÔðÈÎÈË£¬ÈçºÎ»Ø¹öÕâЩÊÂÎñ£¿
ÎÒÔÚLumigent¹ÙÍøÉÏÒѾÕÒ²»µ½ÈκÎLog ExploreµÄÐÅÏ¢£¬´úÀíÉ̵ÄÍøÕ¾ÉÏÒ²Ö»ÓÐÕë¶Ôsql server 7.0 ºÍsql server 2000 sp2µÄ°æ±¾¡£
ÎÒÆ½Ê±ÓÃLog Explore for sql server 2005µÄÆÀ¹À°æ£¬²»ÊÇÄÇôºÃÓ㬶øÇÒË ......
ÓÐÕâÑùһЩ×Ö·û´®£¬±ÈÈ磺
001£¬002£¬003£¬004£¬005£¬006
001£¬002£¬005
002£¬006£¬007
005£¬006
008
001£¬005£¬006£¬009
ÿ¸ö×Ö·û´®ÓöººÅ¸ô¿ª¡£
ÏÖÔÚ¡£
1¡¢Èç¹ûÎÒÃÇÊäÈë002£¬003 £¬Ëü×Ô¶¯ÕÒµ½×îÏàËÆµÄ 001£¬002£¬003£¬004£¬005£¬006
2¡¢Èç¹ûÎÒÃÇÊäÈë001£¬002£¬Ëü×Ô¶¯ÕÒµ½
001£¬002£ ......
¡°/¡±Ó¦ÓóÌÐòÖеķþÎñÆ÷´íÎó¡£
--------------------------------------------------------------------------------
ÔÚ½¨Á¢Óë·þÎñÆ÷µÄÁ¬½Óʱ³ö´í¡£ÔÚÁ¬½Óµ½ SQL Server 2005 ʱ£¬ÔÚĬÈϵÄÉèÖÃÏ SQL Server ²»ÔÊÐí½øÐÐÔ¶³ÌÁ¬½Ó¿ÉÄܻᵼÖ´Ëʧ°Ü¡£ (provider: ÃüÃû¹ÜµÀÌṩ³ÌÐò, error: 40 - ÎÞ·¨´ò¿ªµ½ SQL S ......
±íAÓÐÈçÏÂ×Ö¶Î
ID NAME TIME1 TIME2
1 ºÇºÇ 2010-01 2010-02
2 ¹þ¹þ 2010-02 NULL
3 ......
ÔÚ½¨Á¢Óë·þÎñÆ÷µÄÁ¬½Óʱ³ö´í¡£ÔÚÁ¬½Óµ½ SQL Server 2005 ʱ£¬ÔÚĬÈϵÄÉèÖÃÏ SQL Server ²»ÔÊÐí½øÐÐÔ¶³ÌÁ¬½Ó¿ÉÄܻᵼÖ´Ëʧ°Ü¡£ (provider: ÃüÃû¹ÜµÀÌṩ³ÌÐò, error: 40 - ÎÞ·¨´ò¿ªµ½ SQL Server µÄÁ¬½Ó)
ÐÐ 23: SqlDataAdapter dataAp = new SqlDataAdapter(comd);
ÐÐ 24: DataSet dt = new Dat ......
ÎÒÏÖÔÚ×öÒ»¸öµÇ½ µ«ÊÇÒª´ÓÈýÕűíÖжÁÈ¡Êý¾Ý½øÐбȽÏ
ÆäÖÐÓÐÒ»ÕűíµÄÊý¾ÝÂú×ãµÇ½ ¾Í¿ÉÒԵǼ½øÈ¥ Õâ¸ösql Ôõôд£¿
È磺±íA ÓÐ×Ö¶Î loginName pwd ±íB ÓÐ×Ö¶Î UserName password ±íCÓÐ×Ö¶Î LoginUserName password
ÄÇôֻҪÂú×ãÆäÖÐÒ»ÕűíµÄ ......