IF EXISTS (SELECT * FROM dbo.sysobjects WHERE id = object_id(N'[dbo].[Yourfn_CRYPT_PBKDF2_VARBINARY_SHA1]') AND xtype IN (N'FN', N'IF', N'TF')) @Password VARBINARY ...
exec sp_executesql N'INSERT INTO [dbo].[event_store] (payload, options, headers) VALUES (@p1, @p2, @p3)', N'@p1 varbinary(12), @p2 varbinary(113), <===== @p3 nvarchar ...
Where last week I wrote the script as a stored procedure, I’ve now implemented both the encryption and decryption as ...