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
相关文档：
锁机制
NOLOCK和READPAST的区别。
1. 开启一个事务执行插入数据的操作。
BEGIN TRAN t
INSERT INTO Customer
SELECT 'a','a'
2. 执行一条查询语句。
SELECT * from Customer WITH (NOLOCK)
结果中显示"a"和"a"。当1中事务回滚后，那么a将成为脏数据。(注:1中的事务未提交) 。NOLOCK表明没有对数据表添加共� ......
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 ......
-----------------------------------------------------------------------------------------------------------------------
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 ......
常用： 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 ......
