T-SQL 2005 recommended not to use a book for beginners

Category: MS-SQL Server -> Others Author: huaxiamoyun Date: 2003-06-17 19:03:37
 
huaxiamoyun
2003-06-17 19:03:37
Title "SQL Server 2005 from entry to .."
Author: MG,
JLJ,
DWT
Translation: Q
L
M
book has too many errors, For example:
Page 133
"use Adventureworks
SELECT Humanresources.Department.Name,
SUM (HumanResources.Employee.VacationHours)
; as TotalVacation
From HumanResources.Employee
INNER JOIN HumanResources.Department
ON HumanResources.Employee.DepartmentID =
HumanResources.Department.DepartmentID
GROUP BY HumanResources.Department.Name
"
Employee table does not exist DepartmentID! ! ! !
reason for posting is because I now use this book to learn, can not stand these stupid mistake, so remind the brothers want to buy this book, do not waste money and time.
housen130
2003-06-17 19:18:49
buy pirated books the!
wsmwsm1744
2003-06-17 19:24:25

I do this is by no means pirated books.
acattle
2003-06-17 19:36:18
this is correct:
use Adventureworks
SELECT HumanResources.Department.Name,
SUM (HumanResources.Employee.VacationHours)
as TotalVacation
From HumanResources.Employee
INNER JOIN HumanResources.EmployeeDepartmentHistory
ON HumanResources.Employee.EmployeeID =
HumanResources.EmployeeDepartmentHistory. EmployeeID
INNER JOIN HumanResources.Department
ON HumanResources.EmployeeDepartmentHistory.DepartmentID =
HumanResources.Department.DepartmentID
GROUP BY HumanResources.Department.Name