declare @trigname varchar(20)
set @trigname=@new_tname+'T'
declare @var nvarchar(max)
declare @var2 varbinary(max)
declare @var3 varbinary(max)
declare @sqlv2 nvarchar(max)

set @sqlv2=N'create trigger['+@trigname+
']on['+ @view +
']instead of insert, update
 as 
begin
 open symmetric key['+@keyname+
 ']decryption by password=['+@passw+']
  DECLARE klient_cursor CURSOR GLOBAL SCROLL
		KEYSET FOR
        SELECT column_name
        FROM INFORMATION_SCHEMA.COLUMNS
        WHERE TABLE_NAME=['+@syst+']   
			OPEN klient_cursor
			WHILE @@FETCH_STATUS = 0
			begin
			FETCH NEXT FROM klient_cursor 
			INTO  '+@var+
 			'set['+@var2+']=(select convert(varbinary(max),'+@var+') from inserted)
			set['+ @var3+']=ENCRYPTBYKEY(Key_GUID(['+@keyname+']),['+@var2+'])
			insert into ['+@view+'](['+@var+']) values (['+@var3+'])
			end
CLOSE klient_cursor
DEALLOCATE klient_cursor'
exec SP_EXECUTESQL @sqlv2
end

declare @var2 varbinary(max)
declare @var3 varbinary(max)

if OBJECT_ID('dbo._TestEncryption') is not null drop table dbo._TestEncryption
create table dbo._TestEncryption(id int not null primary key identity(1,1),EncryptionName varbinary(100))
GO
if OBJECT_ID('dbo.vw_TestEncryption') is not null drop view dbo.vw_TestEncryption
GO
CREATE VIEW vw_TestEncryption AS
 select id, EncryptionName from dbo._TestEncryption
GO
CREATE SYMMETRIC KEY TestEncryption WITH ALGORITHM = AES_256
    ENCRYPTION BY PASSWORD = 'Test_Password_256' 
GO
create trigger Insert__TestEncryption on dbo._TestEncryption
instead of insert, update
as 
begin
	OPEN SYMMETRIC KEY TestEncryption DECRYPTION BY PASSWORD = 'Test_Password_256';	
	UPDATE d SET EncryptionName = EncryptByKey(Key_GUID('TestEncryption'),I.EncryptionName)
	from INSERTED I
	JOIN dbo._TestEncryption D ON d.ID = I.ID

	IF NOT EXISTS(SELECT * FROM DELETED)
	INSERT INTO dbo._TestEncryption(EncryptionName)
	SELECT EncryptByKey(Key_GUID('TestEncryption'),I.EncryptionName)
	from INSERTED I

	CLOSE SYMMETRIC KEY TestEncryption
end
GO

insert into vw_TestEncryption (EncryptionName) select cast('one' as varbinary(100)) union select cast('two' as varbinary(100))

select * from dbo._TestEncryption


OPEN SYMMETRIC KEY TestEncryption DECRYPTION BY PASSWORD = 'Test_Password_256';

SELECT ID
    ,EncryptionName
    ,CONVERT(varchar(50), DecryptByKey(EncryptionName))AS DecryptedName
FROM dbo._TestEncryption



CLOSE SYMMETRIC KEY TestEncryption
DROP SYMMETRIC KEY TestEncryption