Generated using SQL Data Dictionary demo version.


View HumanResources.vEmployeeDepartment


Returns employee name, title, and current department.


Column Data Type Nullable
BusinessEntityID int
Title nvarchar(8) X
FirstName Name(nvarchar(50))
MiddleName Name(nvarchar(50)) X
LastName Name(nvarchar(50))
Suffix nvarchar(10) X
JobTitle nvarchar(50)
Department Name(nvarchar(50))
GroupName Name(nvarchar(50))
StartDate date

Uses: