Follow along with the video below to see how to install our site as a web app on your home screen.
Note: This feature may not be available in some browsers.
OPEN SYMMETRIC KEY PrivateData DECRYPTION BY PASSWORD ='Password'
CREATE TABLE UserData
(Data VARBINARY(255))
DECLARE @Key_GUID UNIQUEIDENTIFIER
SELECT @Key_GUID = Key_GUID
FROM sys.symmetric_keys
WHERE Name = 'PrivateData'
INSERT INTO UserData
(Data)
VALUES
(EncryptByKey(@Key_Guid, 'RawData', 1))
SELECT Data
FROM UserData
SELECT CONVERT(VARCHAR(20), DecryptByKey(UserData.Data, 1)) AS Data
FROM UserData
DROP TABLE UserData
CLOSE SYMMETRIC KEY PrivateData