Sql Server 2000Òì³£±¸·Ý - MS-SQL Server / ÒÉÄÑÎÊÌâ
ÓÐÁ½Ì¨·þÎñÆ÷£¬Ò»Ì¨ÊÇÖ÷·þÎñÆ÷£¬Ò»Ì¨ÊDZ¸Ó÷þÎñÆ÷¡£
²»ÖªµÀ´Óʲôʱºò¿ªÊ¼£¬ÕâÁ½Ì¨·þÎñÆ÷£¬Ò»·ÖÖÓ±¸·ÝÒ»´ÎSQLµÄÊý¾Ý¿â£¬±¸·ÝÃû³ÆÈ磺¡°yyyyMMddHHmmss.bak¡±,ûÓж೤ʱ¼ä£¬´ÅÅ̾ÍÂúÁË¡£
´Ó¡°·þÎñ¹ÜÀíÆ÷¡±°ÑSql Server·þÎñ¹Ø±ÕÁË£¬¾Í»áÍ£Ö¹±¸·ÝÁË¡£·þÎñ¿ªÆôºó£¬Ò»»áÓÖ×Ô¶¯±¸·ÝÁË¡£²¢ÇÒÔÚ"ÆóÒµ¹ÜÀíÆ÷"µÄά»¤¼Æ»®ºÍ×÷ÒµÀﲢûÓÐÉèÖö¨Ê±±¸·Ý¡£
°ÑSql ServerÐ¶ÔØºó£¬ÔÙ°²×°ºó£¬Ò»»áÓÖ×Ô¶¯±¸·ÝÁË¡£ÎÒ¶¼Ææ¹ÖÁË¡£
Ó¦ÓóÌÐòʼþÏÔʾÈçÏÂÐÅÏ¢£º
ʼþÀàÐÍ: ÐÅÏ¢
ʼþÀ´Ô´: MSSQLSERVER
ʼþÖÖÀà: (6)
ʼþ ID: 17055
ÈÕÆÚ: 2010-5-5
ʼþ: 11:10:22
Óû§: N/A
¼ÆËã»ú: ZJ
ÃèÊö:
18264:
Êý¾Ý¿âÒѱ¸·Ý: Êý¾Ý¿â: ScalePubFlat£¬´´½¨ÈÕÆÚ£¨Ê±¼ä£©: 2010/05/05(10:27:37)£¬×ª´¢µÄÒ³Êý: 32834£¬µÚÒ»¸ö LSN: 17533:25:1£¬×îºóÒ»¸ö LSN: 17533:27:1£¬×ª´¢É豸µÄÊýÄ¿: 1£¬É豸ÐÅÏ¢: (FILE=1, TYPE=DISK: {'d:\ScaleBackup\20100505110953.bak'})¡£
Óйظü¶àÐÅÏ¢£¬Çë²ÎÔÄÔÚ http://go.microsoft.com/fwlink/events.asp µÄ°ïÖúºÍÖ§³ÖÖÐÐÄ¡£
Êý¾Ý:
0000: 58 47 00 00 0a 00 00 00 XG......
0008: 03 00 00 00 5a 00 4a 00 ....Z.J.
0010: 00 00 0d 00 00 00 53 00 ......S.
0018: 63 00 61 00 6c 00 65 00 c.a.l.e.
0020: 50 00 75 00 62 00 46 00 P.u.b.F.
0028: 6c 00 61 00 74 00 00 00 l.a.t...
ÈçºÎ½â¾ö£¬Çë´ó¼Ò¸øÕï¶Ïһϡ£
¡°±¸·Ýµ½¡°µÄ±¸·ÝÎļþÃû³ÆÒ²Ëæ×Åʱ¼ä±ä»¯¡£
¿´¿´ÊDz»ÊÇÓÐWindowsÅų̼ƻ®ÔÚ×ö±¸·Ý¡£
¿´¿´¼Æ»®ÈÎÎñÊDz»ÊÇÄãдÁËÅú´¦Àí ¶¨Ê±±¸·Ý ¿´ÏµÍ³¼Æ»®ÈÎÎñ ÓеĻ°È¡ÏûÄÇÄǸöÈÎÎñ »òÕ
Ïà¹ØÎÊ´ð£º
Ö´ÐеÄ˳Ðò£º
1£©Îļþä¯ÀÀ¿ò£¨Ñ¡ÔñÎļþʹÓã©
Ñ¡ÔñºÃÎļþºó
µã»÷Ò»¸öµ¼Èë°´Å¥µÄʱºò £¬°ÑÉÏÃæÉÏ´«¿òÀïµÄcsvÎļþÒÔÒ»¸öIDΪÎļþÃû£¬ÉÏ´«µ½**/**Îļþ¼ÐÏÂ
2£©¶ÁÈ¡Õâ¸öÎļþ¼ÐϵÄcsvµÄÎļþ£¬×ª»»³Ésql
3 ......
½ñÌì×öÁËÒ»¸ö´æ´¢¹ý³Ì »·¾³ÊÇSQL2000Êý¾Ý¿â
´óÖÂÈçÏÂ
½¨Á¢ÁÙʱ±í
¶¨ÒåÔ±¹¤Óαê
Ñ»·Ô±¹¤£¨ÊôÓÚ1¸ö¹«Ë¾)
......
´ÓÊý¾Ý¿âÖвéѯһÕűíµÄÊý¾Ý
select ²¿ÃÅ,ÐÕÃû from tb
ÈçºÎ²ÅÄÜÉú³ÉÏÂÃæµÄxml¸ñʽ
XML code:
<folder state="unchecked" label="È«²¿">
¡¡¡¡ <folder state="unchecked&qu ......
Çë½Ì¸ßÊÖ£º
ÒÔÏÂÊÇÊý¾Ý¿âÖеÄÈýÌõ¼Ç¼£¬Ó¢ÎÄΪ×Ö¶ÎÃû³Æ
id planname TaskBeginTime Status
329 2010Äê03 ......
²éѯѧÉúƽ¾ù³É¼¨¼°ÆäÃû´Î
SELECT 1+(SELECT COUNT( distinct ƽ¾ù³É¼¨)
from (SELECT S#,AVG(score) AS ƽ¾ù³É¼¨
from SC&n ......