1
Answer

How to create SP for table with encrypted columns?

CREATE TABLE [dbo].[patientdetails](
[PatientID] [nvarchar](50) NULL,
[PatientName] [nvarchar](50) NULL,
[DOB] [nvarchar](50) COLLATE Latin1_General_BIN2 ENCRYPTED WITH (COLUMN_ENCRYPTION_KEY = [CEK_Auto1], ENCRYPTION_TYPE = Deterministic, ALGORITHM = 'AEAD_AES_256_CBC_HMAC_SHA_256') NULL,
[Gender] [nvarchar](50) NULL,
[SSN] [varchar](100) COLLATE Latin1_General_BIN2 ENCRYPTED WITH (COLUMN_ENCRYPTION_KEY = [CEK_Auto1], ENCRYPTION_TYPE = Deterministic, ALGORITHM = 'AEAD_AES_256_CBC_HMAC_SHA_256') NULL,
[Phone] [nvarchar](50) NULL
) ON [PRIMARY]
GO
 
I have a table like this .How to create Stored Procedure for this table? 
Answers (1)