Akshaya arumugam

Akshaya arumugam

  • 1.8k
  • 116
  • 18.6k

How to create SP for table with encrypted columns?

May 29 2018 12:31 AM
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)