sql 2000 ·þÎñÆô¶¯²»ÁË
Ö±½ÓÆô¶¯ µãÁ˵ÈÒ»»á¶ù¾Íû·´Ó¦ÁË È¥·þÎñÄÇÀïÆô¶¯»á³öÏÖÈçÏÂÌáʾ
³öÏÖ¡°±¾µØ¼ÆËã»úÉϵÄMSSQLSERVER·þÎñÆô¶¯ºóÓÖÍ£Ö¹ÁË¡£Ò»Ð©·þÎñ×Ô¶¯Í£Ö¹£¬Èç¹ûËüÃÇûÓÐʲô¿É×öµÄ
È»ºó»¹ÓÐʲôʲô²»´æÔÚ
Õâ¸öÊÇ´íÎóÈÕÖ¾
2009-11-04 10:47:24.03 server Microsoft SQL Server 2000 - 8.00.194 (Intel X86)
Aug 6 2000 00:57:48
Copyright (c) 1988-2000 Microsoft Corporation
Personal Edition on Windows NT 5.2 (Build 3790: Service Pack 1)
2009-11-04 10:47:24.03 server Copyright (C) 1988-2000 Microsoft Corporation.
2009-11-04 10:47:24.03 server All rights reserved.
2009-11-04 10:47:24.03 server Server Process ID is 2876.
2009-11-04 10:47:24.03 server Logging SQL Server messages in file 'd:\Program Files\Microsoft SQL Server\MSSQL\log\ERRORLOG'.
2009-11-04 10:47:24.32 server SQL Server is starting at priority class 'normal'(1 CPU detected).
2009-11-04 10:47:24.46 server Performance monitor shared memory setup failed: -1
2009-11-04 10:47:24.57 server SQL Server configured for thread mode processing.
2009-11-04 10:47:24.57 server Using dynamic lock allocation. [500] Lock Blocks, [1000] Lock Owner Blocks.
2009-11-04 10:47:24.67 spid3 Starting up database 'master'.
2009-11-04 10:47:56.14 spid3 Error: 823, Severity: 24, State: 2.
2009-11-04 10:47:56.14 spid3 Error: 3313, Severity: 21, State: 2.
2009-11-04 10:47:56.20 spid3 Cannot recove
Ïà¹ØÎÊ´ð£º
´ó¼ÒºÃ£¬ÇëÎÊÔÚ±íMÖÐÓÐ×ֶΣºa b c d e
ÎÒÏë²é³öÆäÖÐÂú×ãÏÂÃæÈÎÒâÒ»ÏîµÄÊý¾Ý£¬1.×Ö¶Îa µÄÖµ²»ÊÇ ¡®Êé»ò±Ê»ò±¾¡¯ÖÐÈÎÒ»£¬2.aΪÊéµÄʱºò×Ö¶Îb,cÊÇ¿Õ;3.µ±aֵΪ±ÊµÄʱºòdÊÇ¿Õ;4.µ±aΪ±¾µÄʱºòb,d,e¶¼ÊÇ¿Õ;5.È ......
ÎÒÓжà¸ö±íA B C ½á¹¹ÊÇÒ»ÑùµÄ£¬¶¼ÓÐ2¸ö×Ö¶ÎnameºÍcontent,ÎÒÒªËÑË÷ËùÒÔ±íËùÓÐ×Ö¶ÎÖаüº¬¡°Öйú¡±µÄÄÚÈÝ Õâ¸öSQLÓï¾äÔõôд
ÈçºÎ½«¶à¸ö±íµÄ²éѯ½á¹ûÁ¬³ÉÒ»¸ö±í Õâ¸öSQLÓï¾äÔõôд ±íµÄ½á¹¹ÊÇÒ»ÑùµÄ
ÀýÈç£ ......
ÔÊý¾Ý
ÉÌÆ· Ô¼Û ´òÕÛ·½Ê½1 ÕÛ¿Û1 ´òÕÛ·½Ê½2 ÕÛ¿Û2
±Ê¼Ç±¾ 10000 NULL 0 NULL&nb ......
±ía
Ïß·´úÂë Ïß·Ãû³Æ Main_ID
cir11 cirA 1
cir21 cirB 1
cir13 ......