SQL Server 2008 编程入门经典 第10章练习
CREATE VIEW HumanResources.Managers AS SELECT he.* FROM HumanResources.Employee he WHERE he.EmployeeID IN ( SELECT DISTINCT ManagerID FROM…
SQL 的一些语法规则
CREATE VIEW PortlandAreaAddresses_vw AS SELECT AddressID, AddressLine1, City, StateProvinceID, PostalCode, ModifiedDate FROM Person.Address…
使用SQL创建视图的语法结构
CREATE VIEW CustomerPhoneList_vw AS SELECT CustomerName, Contact, Phone FROM Customers