, . , , , . , , , . Microsoft SQL Server .
, , . .
. , , UNION SELECT , . , , , , . , ; .
, , .
, , :
Employee(Name, BirthDate, Salary, Department, BuildingName)
, :
Employee2(Name, BirthDate, Salary, DeptId)
Department(DeptId, BuildingName)
, - Employee, Employee :
CREATE VIEW Employee AS
SELECT Name, BirthDate, Salary, BuildingName
FROM Employee2 e, Department d
WHERE e.DeptId = d.DeptId
, Employee, Employee. Employee, . , , Employee, INSTEAD OF INSERT, DELETE UPDATE . 5, SQL Server DML- DML . , DML (INSTEAD OF).
, . , , , .
, , , . , , .