SQL Server Transact Basic to Expert - Create basic View with Encryption

SQL Server Transact Basic to Expert - Create basic View with Encryption

This blog shows how to create a simple view with a basic encryption

Syntax:

CREATE VIEW Viewname
WITH ENCRYPTION
AS
Select statement


Example:

CREATE VIEW vemptable
WITH ENCRYPTION
AS
Select empname, empid, empsal
GO