练习 2：使用错误列表
在本练习中，您将看到SQL Server 2008版本的集成开发环境的错误列表功能。
启动 SQL Server Management Studio
点击Start | All Programs | Microsoft SQL Server 2008 | SQL Management Studio ，启动SQL Server Management Studio。
在Connect to Server对话框中输入下列信息，然后点击 Connect 按钮：
Server type: Database Engine
Server name: (local)
Authentication: Windows Authentication
Server name: (local)
Authentication: Windows Authentication
查看错误列表
点击 New Query，打开新的查询窗口。
在菜单中，选择View，Error List，这样可以看到错误列表。
在新打开的查询窗口中，输入下列代码。
USE Northwind
GO
SELECT Orders.OrderID, Employees.LastName + Employees.FirstName AS Employee Name, Customers.CompanyName AS Customer
FROM Employees INNER JOIN
Order ON Employees.EmployeeID = Orders.EmployeeID INNER JOIN
Customers ON Orders.CustomerID = Customers.CustomerID
GO
SELECT Orders.OrderID, Employees.LastName + Employees.FirstName AS Employee Name, Customers.CompanyName AS Customer
FROM Employees INNER JOIN
Order ON Employees.EmployeeID = Orders.EmployeeID INNER JOIN
Customers ON Orders.CustomerID = Customers.CustomerID
这时，查看Error List面板，可以看到下面四个错误：
注意，有些错误是由其它错误引起的。
将代码修改为下面的样式，以改正所有错误：
USE Northwind
GO
SELECT Orders.OrderID, Employees.LastName + Employees.FirstName AS "Employee Name", Customers.CompanyName AS Customer
FROM Employees INNER JOIN
Orders ON Employees.EmployeeID = Orders.EmployeeID INNER JOIN
Customers ON Orders.CustomerID = Customers.CustomerID
GO
SELECT Orders.OrderID, Employees.LastName + Employees.FirstName AS "Employee Name", Customers.CompanyName AS Customer
FROM Employees INNER JOIN
Orders ON Employees.EmployeeID = Orders.EmployeeID INNER JOIN
Customers ON Orders.CustomerID = Customers.CustomerID
这时，注意到，Error List面板中的所有错误都被消除了。
