encrypted view

[Som Nath Shukla]

create table hi
( Fname varchar(10)
lname varchar(10)
)

create view employee_V
AS
select EncryptByPassPhrase('aa',Lname) Lname, Fname from Hi

select * from employee_V

insert into employee_V values
('som','nath')

Hi I have table containing two ccloumn. due to security reason i have
created a view in encrypted form. Now i want to insert into table through
view but it show error.
Update or insert of view or function 'employee_V' failed because it contains
a derived or constant field.


plz help me asap.

 

[Marc Gravell]

This is not a C# question, so I'm going to say two things:
a: an "instead of" trigger
b: microsoft.public.sqlserver.*

Marc