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
相关文档：
从Table 表中取出第 m 条到第 n 条的记录：(Not In 版本)
SELECT TOP n-m+1 *
from Table
WHERE (id NOT IN (SELECT TOP m-1 id from Table ))
--从TABLE表中取出第m到n条记录 (Exists版本)
SELECT TOP n-m+1 * from TABLE AS a WHERE Not Exists
(Select * from (Select Top m-1 * from TABLE orde ......
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' ......
-----------------------------------------------------------------------------------------------------------------------
create table tb(id varchar(3) , pid varchar(3) , name varchar(10))
insert into tb values('001' , null , '广东省')
insert into tb values('002' , '001' , '广州市')
insert i ......
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 ......
