Database Reference
In-Depth Information
dbo.vwVisibleLabels ON dbo.GetLabelID
(dbo.SeaViewEmployee.TC) = dbo.
vwVisibleLabels.ID
GO
CREATE VIEW [dbo].[UserVisibleJSEmployee]
AS
SELECT dbo.JSEmployee.name, dbo.JSEmployee.CName, dbo.
JSEmployee.Department, dbo.JSEmployee.Salary, dbo.
JSEmployee.TC
FROM dbo.JSEmployee INNER JOIN
dbo.vwVisibleLabels ON dbo.GetLabelID(dbo.
JSEmployee.TC) = dbo.vwVisibleLabels.ID
GO
CREATE VIEW [dbo].[SmithEmployee]
AS
SELECT name, dbo.[GetCLabel](CName) CName, Department,
Salary,dbo.[GetCLabel](CName) TC
FROM dbo.[Smith-Employee]
GO
CREATE VIEW [dbo].[SeaViewEmployee]
AS
SELECT d b o.[D2-u].n am e, d b o.[G etCLa b el](d b o.[D2-u].C Nam e)
C Nam e, d b o.[D2-u].Depar tm e nt, d b o.[G etCLa b el]
(d b o.[D2-u].C D ept) C D ept, d b o.[D3-u].Salar y,
dbo .[GetCLabel](dbo.[D3-u].CSalary)
CSalary, dbo.[GetCLabel]([dbo].
[GetTCLabel](4, dbo.[D2-u].CName, dbo.
[D2-u].CDept, dbo.[D3-u].CSalary)) TC
FROM dbo.[D2-u] JOIN
dbo.[D3-u] ON dbo.[D2-u].Name = dbo.
[D3-u].Name
UNION
SELECT d b o.[D2-u].n am e, d b o.[G etCLa b el](d b o.[D2-u].C Nam e)
CName, dbo.[D2-u].Department, dbo.[GetCLabel](dbo.
[D2-u].C D ept) C D ept, d b o.[D3-c].Salar y,
dbo .[GetCLabel](dbo.[D3-c].CSalary)
CSalary, dbo.[GetCLabel]([dbo].
[GetTCLabel](4, dbo.[D2-u].CName, dbo.
[D2-u].CDept, dbo.[D3-c].CSalary)) TC
FROM dbo.[D2-u] JOIN
dbo.[D3-c] ON dbo.[D2-u].Name = dbo.[D3-c].Name
UNION
SELECT d b o.[D2-u].n am e, d b o.[G etCLa b el](d b o.[D2-u].C Nam e)
C Nam e, d b o.[D2-u].Depar tm e nt, d b o.[G etCLa b el]
(d b o.[D2-u].C D ept) C D ept, d b o.[D3-s].Salar y,
Search WWH ::




Custom Search