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

SQL SERVERµÄÈÕÖ¾²éѯ¼°Undo

Çó½Ì¸÷λDBA´ó´ó£¬ÄãÃÇÈÕ³£¹¤×÷ÖÐÈçºÎ²é¿´ÊÂÎñÈÕÖ¾£¬ÔÚÓÐÈ˸ÉÁË»µÊºóÈçºÎ×·×Ùµ½ÔðÈÎÈË£¬ÈçºÎ»Ø¹öÕâЩÊÂÎñ£¿

ÎÒÔÚLumigent¹ÙÍøÉÏÒѾ­ÕÒ²»µ½ÈκÎLog ExploreµÄÐÅÏ¢£¬´úÀíÉ̵ÄÍøÕ¾ÉÏÒ²Ö»ÓÐÕë¶Ôsql server 7.0 ºÍsql server 2000 sp2µÄ°æ±¾¡£
ÎÒÆ½Ê±ÓÃLog Explore for sql server 2005µÄÆÀ¹À°æ£¬²»ÊÇÄÇôºÃÓ㬶øÇÒËæ×ÅÊý¾Ý¿âµÄ°æ±¾²»¶ÏÉý¼¶£¬Ò²ÎÞ·¨ÔÙ¼ÌÐøÊ¹ÓÃÁË¡£
redgate ÓÐÒ»¿îSQL Log Rescue,²»ÖªµÀÄÄλ´ó´óÓùý£¬×îºÃÊÇÕýʽ°æ£¬Ì¸Ò»Ï¿ÉÓÃÐÔ£¬¶àл¡£

Çë¸÷λÓÐÐËȤµÄ¸½Ò»ÏÂÄúÏÖÔÚÊý¾Ý¿â°æ±¾¼°×·×Ù¹¤¾ß£¬´ó¼Ò½»Á÷ѧϰһÏ£¬Ð»Ð»¡«
ѧϰ,Õâ¶«Î÷²»¶®

SQL 2005
RML·ÖÎö¹¤¾ß

Êý¾Ý¿âÒýÇæÓÅ»¯¹ËÎÊ

SQL SERVER PROFILER

ÎÒÒ»°ãÊÇн¨±í¼Ç¼Óû§²Ù×÷ÈÕÖ¾

ÒýÓÃ
ÎÒÒ»°ãÊÇн¨±í¼Ç¼Óû§²Ù×÷ÈÕÖ¾


Õâ¸ö£¬ÄãÔõô¼Ç¼°¡£¬sql profileÒ»Ö±¿ª×Ű¡£¿

profiler + ÐÔÄܼàÊÓÆ÷ + ÁíÍ⽨Á¢Ò»¸öÓû§µÇ¼¼Ç¼±í

Ò»°ã¶¼»¹¿ÉÒÔ¶ÔÓ¦¡£

¿ØÖƺÃȨÏÞ

ÒýÓÃ
profiler + ÐÔÄܼàÊÓÆ÷ + ÁíÍ⽨Á¢Ò»¸öÓû§µÇ¼¼Ç¼±í

Ò»°ã¶¼»¹¿ÉÒÔ¶ÔÓ¦¡£


ȨÏÞÊǿ϶¨Òª¿ØÖƵ쬵«ÊÇ×ܲ»ÄܱÜÃâÓÐÈËż¶ûԽȨ²Ù×÷£¬³öÁËÎÊÌâ¾ÍҪ׷¾¿ÔðÈÎÈ˰¡¡£
ÎÒÏÖÔÚÒѾ­½¨Á¢ÁËÒ»Ì×Êý¾Ý¿âµÇ¼µÄ¼à¿Ø£¬·¢ÏÖÓÐÈËԽȨµÇ¼ÂíÉÏ×Ô¶¯·¢Óʼþ¾¯¸æËû¡£
µ«ÊdzöÁËÎÊÌâÒÔºóҪ׷²éÖ»ÄÜ·­ÈÕÖ¾ÁË¡£

ÒýÓÃ
profiler + ÐÔÄܼàÊÓÆ÷ + ÁíÍ⽨Á¢Ò»¸öÓû§µÇ¼¼Ç¼±í

Ò»°ã¶¼»¹¿ÉÒÔ¶ÔÓ¦¡£


ÕâЩÊDZØÒªµÄ£¬µ«ÊDz»Äܽâ¾ö×·¾¿ÔðÈεÄÎÊÌ⣬Óû§µ


Ïà¹ØÎÊ´ð£º

jspÁ´½Ósql2000µÄÒÉÎÊ£¿



type Exception report


message

description The server encountered an internal error () that prevented it from fulfilling this request.

exception

org.apache.jas ......

¹ØÓÚSQLSERVERµ×²ãÎÊÌâ - MS-SQL Server / ÒÉÄÑÎÊÌâ

ÇëÎÊһϣ¬ÍâÍøÁ½Ì¨SQLSERVERʵÀýÊý¾Ý´«Ê䣬ÓÐûÓвÉÓÃÊý¾ÝѹËõºÍ¼ÓÃÜ¡£Ñ¹Ëõ±ÈÊǶàÉÙ£¬¼ÓÃÜÊÇʲô¼ÓÃÜËã·¨£¿Ïà¹ØÎĵµÄÄÀï¿ÉÒÔÕÒµ½£¿Ð»Ð»


ÎÒÒ²ÏëÖªµÀ£¡¹Ø×¢´ËÌù£¡

¹Ø×¢¡«¡«

Êý¾Ý¿â´óÅ£¶¼ÄÄÈ¥Á˰¡£¿
......

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

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

ÇóÒ»ÌõSQL - MS-SQL Server / ÒÉÄÑÎÊÌâ

--drop table #T1
--drop table #T2
create Table #T1(ID int,
QueryID nvarchar(20),
ResultID1 nvarchar(20),
ResultID2 nvarchar(20))
create Table #T2(SortNo int,
QueryID nvarchar(20),
ResultID1 nv ......

ÇóÒ»sqlÓï¾ä - MS-SQL Server / »ù´¡Àà

±í
id bh  
1 10
2 11
3 12 
4 15
5 16
6 22
7 25
8 26
9 27
10 28
½«bh°´Á¬Ðø·Ö¶Î³öÀ´·µ»Ø×Ö·û´®£º
10~12£¬15~16£¬22£¬25~28
SQL code:


declare @t tabl ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ