encryption.sql

本程序中即有讲义

use pubs
go
CREATE view VIEW_author_title1
with encryption
AS
SELECT authors.au_lname, authors.au_fname, titles.title
FROM authors INNER JOIN
      titleauthor ON authors.au_id = titleauthor.au_id INNER JOIN
      titles ON titleauthor.title_id = titles.title_id
go
exec sp_helptext VIEW_author_title1
go
CREATE view VIEW_author_title2
--with encryption
AS
SELECT authors.au_lname, authors.au_fname, titles.title
FROM authors INNER JOIN
      titleauthor ON authors.au_id = titleauthor.au_id INNER JOIN
      titles ON titleauthor.title_id = titles.title_id
go
exec sp_helptext VIEW_author_title2