SQL Server 2005无法启动~！！！！
2010-05-05 13:35:52.06 Server Microsoft SQL Server 2005 - 9.00.1399.06 (Intel X86)
Oct 14 2005 00:33:37
Copyright (c) 1988-2005 Microsoft Corporation
Developer Edition on Windows NT 5.1 (Build 2600: Service Pack 3)
2010-05-05 13:35:52.06 Server (c) 2005 Microsoft Corporation.
2010-05-05 13:35:52.06 Server All rights reserved.
2010-05-05 13:35:52.06 Server Server process ID is 2848.
2010-05-05 13:35:52.06 Server Logging SQL Server messages in file 'C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG'.
2010-05-05 13:35:52.06 Server This instance of SQL Server last reported using a process ID of 3348 at 2010-5-5 13:35:11 (local) 2010-5-5 5:35:11 (UTC). This is an informational message only; no user action is required.
2010-05-05 13:35:52.06 Server Registry startup parameters:
2010-05-05 13:35:52.06 Server -d C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\master.mdf
2010-05-05 13:35:52.06 Server -e C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\LOG\ERRORLOG
2010-05-05 13:35:52.06 Server -l C:\Program Files\Microsoft SQL Server\MSSQL.1\MSSQL\DATA\mastlog.ldf
2010-05-05 13:35:52.10 服务器 SQL Server is starting at normal priority base (=7). This is an informational message only. No user action is required.
2010-05-05 13:35:52.10 服务器 Detected 2 CPUs. This is an informational message; no user action is required.
2010-05-05 13:35:52.51 服务器 Using dynamic lock allocation. Initial allocation of 2500 Lock blocks and 5000 Lock Owner blocks per node. This is an informational message only. No user action is required.
2010-05-05 13:35:52.54 服务器 Attempting to initialize Microsoft Distributed Transaction Coordinator (MS DTC). This is an informational message only. No user action is required.
2010-05-05 13:35:52.56 服务器 The Microsoft Distributed Transaction Coordinator (MS DTC) service could not be contacted. If you would like
相关文档：
Student(S#,Sname,Sage,Ssex) 学生表
Course(C#,Cname,T#) 课程表
SC(S#,C#,score) 成绩表
Teacher(T#,Tname) 教师表
问题：
1、查询“001”课程比“002”课程成绩高的所有学生的学号；
select a.S# from (select s#,score from SC where C#='001') a,(select s#,score
fr ......
上回说到，操作Object Array
其实还可以这样操作：
var Room = [
{
ID: 'bot',
name: 'test' ......
sql server出现选定的用户拥有对象而无法删除的处理
2006-4-5 19:50:00
方法一
首先你需要做的第一件事
企业管理器-〉选择服务器-〉属***-〉服务器设置-〉挑上允许对系统目录。。。-〉确定
第二步
找到你的数据库找到sysusers表那你以前的用户删除
第三步回去吧属***值改回来
第四部重建用户即可
方法二
� ......
常用： Select CONVERT(varchar(100), GETDATE(), 8): 10:57:46
Select CONVERT(varchar(100), GETDATE(), 24): 10:57:47
Select CONVERT(varchar(100), GETDATE(), 108): 10:57:49
Select CONVERT(varchar(100), GETDATE(), 12): 060516 Select CONVERT(varchar(100), GETDATE(), 23): 2006-05-16 ......
1、查询两个时间之间
select * from [tablename] where date between \'value1\' and \'value2\'
2、显示最后回复时间
select a.title,a.username,b.adddate from table a,(select max(adddate) adddate from table where table.title=a.title) b
3、日程安排提前5分钟提醒
select * from 日程安排 w ......
