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

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»ÊÇÄãдÁËÅú´¦Àí ¶¨Ê±±¸·Ý ¿´ÏµÍ³¼Æ»®ÈÎÎñ ÓеĻ°È¡ÏûÄÇÄǸöÈÎÎñ »òÕ


Ïà¹ØÎÊ´ð£º

csvÎļþת»»³Ésqlµ¼Èëµ½Êý¾Ý¿â£¬Ã»ÓÐÊý¾ÝΪºÎ£¿

Ö´ÐеÄ˳Ðò£º
1£©Îļþä¯ÀÀ¿ò£¨Ñ¡ÔñÎļþʹÓã©
Ñ¡ÔñºÃÎļþºó
µã»÷Ò»¸öµ¼Èë°´Å¥µÄʱºò £¬°ÑÉÏÃæÉÏ´«¿òÀïµÄcsvÎļþÒÔÒ»¸öIDΪÎļþÃû£¬ÉÏ´«µ½**/**Îļþ¼ÐÏÂ
2£©¶ÁÈ¡Õâ¸öÎļþ¼ÐϵÄcsvµÄÎļþ£¬×ª»»³Ésql
3 ......

SQLÈçºÎÓÅ»¯ÎÊÌâ - MS-SQL Server / ÒÉÄÑÎÊÌâ

½ñÌì×öÁËÒ»¸ö´æ´¢¹ý³Ì   »·¾³ÊÇSQL2000Êý¾Ý¿â  
´óÖÂÈçÏÂ
½¨Á¢ÁÙʱ±í
¶¨ÒåÔ±¹¤Óαê
        Ñ­»·Ô±¹¤£¨ÊôÓÚ1¸ö¹«Ë¾)  
        ......

Êý¾ÝÒÔxml¸ñʽ·µ»Ø - MS-SQL Server / Ó¦ÓÃʵÀý

´ÓÊý¾Ý¿âÖвéѯһÕűíµÄÊý¾Ý
select ²¿ÃÅ,ÐÕÃû from tb
ÈçºÎ²ÅÄÜÉú³ÉÏÂÃæµÄxml¸ñʽ
XML code:
<folder state="unchecked" label="È«²¿">
¡¡¡¡ <folder state="unchecked&qu ......

SQLÓï¾äÎÊÌâ - MS-SQL Server / ÒÉÄÑÎÊÌâ

Çë½Ì¸ßÊÖ£º
 ÒÔÏÂÊÇÊý¾Ý¿âÖеÄÈýÌõ¼Ç¼£¬Ó¢ÎÄΪ×Ö¶ÎÃû³Æ  
  id planname TaskBeginTime Status
329 2010Äê03 ......

SQL²»Ã÷°× - MS-SQL Server / Ó¦ÓÃʵÀý

²éѯѧÉúƽ¾ù³É¼¨¼°ÆäÃû´Î 
  SELECT 1+(SELECT COUNT( distinct ƽ¾ù³É¼¨) 
  from (SELECT S#,AVG(score) AS ƽ¾ù³É¼¨ 
  from SC&n ......
© 2009 ej38.com All Rights Reserved. ¹ØÓÚE½¡ÍøÁªÏµÎÒÃÇ | Õ¾µãµØÍ¼ | ¸ÓICP±¸09004571ºÅ