Hi all,
From the book "Beginning Microsoft SQL Server 2012 Programming" written by Paul Atkinson & Robert Viera (published by Wrox, April 2012), I tried to learn the coding of Chap04.sql in my SQL Server 2012 Management Studio (SSMS2012). I copied
the code, deleted some code statements that are related to USE Chapter4DB that I don't have in my SSMS2012 and I executed the following revised code:
-- Chap04revisedSHC.sql ===> no USE Chapter4DB in this sql
-- 8 April 2015 14:40 PM
SELECT *
FROM Person.Person
INNER JOIN HumanResources.Employee
ON Person.Person.BusinessEntityID = HumanResources.Employee.BusinessEntityID
SELECT Person.BusinessEntity.*, JobTitle
FROM Person.BusinessEntity
INNER JOIN HumanResources.Employee
ON Person.BusinessEntity.BusinessEntityID = HumanResources.Employee.BusinessEntityID
SELECT Person.BusinessEntity.*, BusinessEntityID
FROM Person.BusinessEntity
...
Go to the complete details ...