Database Reference
In-Depth Information
UNION
SELECT dbo.[D2-ts].name, dbo.[GetCLabel](dbo.[D2-ts].CName)
CName, dbo.[D2-ts].Department, dbo.[GetCLabel](dbo.
[D2-ts].CDept) CDept, dbo.[D3-ts].Salary,
dbo .[GetCLabel](dbo.[D3-ts].CSalary)
CSalary, dbo.[GetCLabel]([dbo].
[GetTCLabel](4, dbo.[D2-ts].CName, dbo.
[D2-ts].CDept, dbo.[D3-ts].CSalary)) TC
FROM dbo.[D2-ts] JOIN
dbo.[D3-ts] ON dbo.[D2-ts].Name = dbo.
[D3-ts].Name
GO
CREATE VIEW [dbo].[JSEmployee]
AS
SELECT name, dbo.[GetCLabel](CName) CName, Department,
dbo.[GetCLabel](CDept) CDept, Salary,
dbo.[GetCLabel](CSalary) CSalary, dbo.
[GetCLabel]([dbo].[GetTCLabel](4,
CName, CDept, CSalary)) TC
FROM dbo.Du
UNION
SELECT name, dbo.[GetCLabel](CName) CName, Department,
dbo.[GetCLabel](CDept) CDept, Salary,
dbo.[GetCLabel](CSalary) CSalary, dbo.
[GetCLabel]([dbo].[GetTCLabel]
(4, CName, CDept, CSalary)) TC
FROM dbo.Dc
UNION
SELECT name, dbo.[GetCLabel](CName) CName, Department,
dbo.[GetCLabel](CDept) CDept, Salary,
dbo.[GetCLabel](CSalary) CSalary, dbo.
[GetCLabel]([dbo].[GetTCLabel](4,
CName, CDept, CSalary)) TC
FROM dbo.Ds
UNION
SELECT name, dbo.[GetCLabel](CName) CName, Department,
dbo.[GetCLabel](CDept) CDept, Salary,
dbo.[GetCLabel](CSalary) CSalary, dbo.
[GetCLabel]([dbo].[GetTCLabel](4,
CName, CDept, CSalary)) TC
FROM dbo.Dts
GO
CREATE VIEW [dbo].[VwEmployee-Encryption]
Search WWH ::




Custom Search