|
|
|
| SQL - Structured Query Language |
WITH ENCRYPTION - VIEWWITH ENCRYPTION option is used to convert the original text of the CREATE VIEW statement to complicate text format. The following query is used to create view that helps to list out Employee Detail with Department Name by using SQL join concept. -- Example 58 --
USE EBusiness GO
CREATE VIEW EmpDept WITH ENCRYPTION AS SELECT EMP.Emp_Code, EMP.Emp_Name, EMP.Dept_Code, DEPT.Dept_Name FROM EMP, DEPT WHERE EMP.Dept_Code = DEPT.Dept_Code GO
SELECT * FROM EmpDept Query Output Screen |
* * * * *
|
|
|
|
Copyrights © . Data-e-Education. All Rights Reserved.
Your Comment To AUTHOR