SQL Server 2019

By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
CREATE CERTIFICATE MyTestCertificate 
FROM BINARY = 0x3082036B30820253A00302010202146472932AE654353AF660E02361C2062FC040FEE6300D06092A864886F70D01010B05003045310B30090603550406130241553113301106035504080C0A536F6D652D53746174653121301F060355040A0C18496E7465726E6574205769646769747320507479204C7464301E170D3233313132303137303835375A170D3234313131393137303835375A3045310B30090603550406130241553113301106035504080C0A536F6D652D53746174653121301F060355040A0C18496E7465726E6574205769646769747320507479204C746430820122300D06092A864886F70D01010105000382010F003082010A0282010100CF9CCF5AF133484FC7DC8FF41C1B9010FC7821B373D0352A57E76A0FA0456AE1F35FDCED60343551594FC0E636727AF868EC237978BBBAE8C366B955A507CB942A3380755F6565F1811BF4476948008F18F3BEBE852540C660A781B362DAD21E70567CE70363EB4DE0F281DB239381308C2A8664B066F7F3331038E62465FC837AF170346AB63D1D18CA0400A6FC41EEE87FEFFB80C01D2FF7B86A1E48F299FA4BECA495C8B33CCB3A9603731AC9CE6B6F55EA1EB91DD919DCCBB17833CB1FB67C97891AF9FAC34EFDB2E7777DF5DFD7E4172638ED65ECBAE08AB5E17EB7EA81937DAAA79F9B041BE3C05488423BB3EF1B26C91D91CF7FD9D7A42E8E5582DA5F0203010001A3533051301D0603551D0E041604145F7A25691BA68CF1D6B59AD50E8F2CA6D0403018301F0603551D230418301680145F7A25691BA68CF1D6B59AD50E8F2CA6D0403018300F0603551D130101FF040530030101FF300D06092A864886F70D01010B0500038201010064E1E3CB35A81CB136B599134D0F536A4D1776CE26B2822B33C415C8E65EE4A8A5E185668455DDF326A4219CAB87D12ED59E85BDA31521201998165F41979CA0DB6608AF2A5D5A3A7566082B6E7B1204666233312E0FFABFF427DDB8E37415559CD8B5405F13425078ACDC1C02AECD3DE372FDC9DE0DCE9A74F3716AF2D0D2ACD06F6070AB620A5E6A5575CA760AED728AAD8549B047345D4F286EA51CB005719B2396F5C0340FB94162EE9E7EAC247CE402169FC754EACAC818C08DAD0A796D336F4437D665CD7ABAB1ED9E30D6213ED2328859709884C35BE1143861429A84FA2CE530F95434554B33131AA66EC6ABC22091E91072242B466877ED6D82C137
WITH PRIVATE KEY ( BINARY = 0x1EF1B5B00000000001000000010000001000000094040000419A89BBB1027ACB5AACB15F8F6AFE370702000000A400009DAD54580C78F832882C12C35E4F44AA9EE8C7EF7A21BB43C39321652366CB79744507A27EF26DA872B8FA1EA9CB4BB67A1C4A819F988BE40162F2C652932DEEF06CD8C1D1DF009F26850407F2C7188D7D4DCB20D34042D4DFC05B60DF7C0046A77528721615F554152612658147DB4F9B8F80A0BEBCAC49B4C7078A40586450B426822AABBD38F2ED938BAE9223CC8EAAC9839448DC5AAC182FB56437EF36D9D492E7B057D1965666884606C99A36BB980DEA611791AD036A7686972736F569A3FE00EFBFE2088C09C1A27A01EC2D0A5D3C3CAB06E30F262BEB377C881F518C7165475A6FB4425FDC301F1EF4A29DB400A335335847EEE3BD3571F63AE8FAA9F6259D346B85B74EEB6AEF7374223E9548ACD7B496B588AFF3AC120A20F04E0F8B44EC5ACAA069671778DE4934224BF2F27AED3F7CFB553E22F843C85E6AE9BC946C9A8768EDD3EE44B08B53977F5B74EBD06110F8A2351CAE69FE4F80AE7E4FF7A9AB472D73E57342C60820D5010D0F7282372D209AA2BDEBD6D14AEF9225F98BFF8E8D237BA588F233CB65C56D57D280067C7B58DEF3B78692B07ED9C182210171B5CEE76DDDF2B441AF302C02E831344F8A56150957FA47DCEE1B7F8CFCAA66DA6D504E22217E7DA33D956AA41ABD92AF455C87BB3FB1032A0D9C08857FD1E6EF5BB1CD7A5958C641E2D723E34BE1A6F6028606BE5DDE3D2A4B89F1D0870E70195CFFEEB70D86C6394068BCB77C7144DE5C8A74BE858E16050C1C9BEF3DE14862FFC83B634675BE3E24F07DEE94FE5881B03AFCFDB82D3A05D2A0BEC96496611E8A02817FA27C4A93482A2B9149F778CFFB1B3BC593B375F304A670D839D136865519A2CA24CE7056DDDC4096CD3089D8CB9A82E971F333C7DE11674264E1A2B7C6E1CB4C75E3E3F62C7FB3E37D628C0358AE12777FB028A6DB66EF48DBD8E14286E6A5A086ABC88ED1C9398EBB2A639A4E8AFB21B000591EC4D45B7BE94FC5AEACDA5FDF9EEDCA1702A57B097B7E577EFCE955BD69C386CC4F8830B2950386B62878CFC8318665F0B02D9524B1BFBFFBDE7AF648E420BC980B38E4445AFC97A66B54E85E831D0EFC2E7B5F822C636A21DB8B28B70134EBA24C98DE0AF683805A9103C51AA9E3FA6C9EC8040AF1C1A6628C5C5C9BA58FA0089A55EB7D2F0121EEB8011485D4F2F479ABABC51AFE98103B4A1BBA090DDE6D18C41F01F5AEA8215D2BCD6F64CF05D451C7DD3DAD4EA8AD136813136AD456289618F829336997E09827CED0AA3F142CF2A1CBEB870020EF34D4465BDB72D93D911AF9DE194990D549E0DDC2DE203C1C6DE2CBC0D2E8FE1835FB2ED2A6CC01B2EDA7050ED0E9FA37251A8876C8A3AB19A6F6802B18E8FE30B4DD1F395F357A5A608BA30E4E39E72CAFB9274589705FF328CE8EA173FD12F188CBD0F6EF3CEA05453E3FB0871138D0F2AEE8C550C8C54D3E992FF88AE7FFE0FCDBD48C5A87A73B0A1984FA50D710A9322304590C294B8A1B7532E4F40A4C802CDAF4E5E053E9D75793319C76A4919F59ED4B40A4C9A42BF0B50536900A75A041305B14AF716984E315AA0A2BD4B40D951DC0B66C64E9935971FFBF4E5BA50940AFB5E7A3A512BD036C8EAA2FFB4B1B83AC9A07D0C51A45EA1BB9 ,
DECRYPTION BY PASSWORD = 'mypassword');
DECLARE @PlainText as varchar(max); 
DECLARE @Signature as varbinary(max); 
SET @PlainText = 'The quick brown fox jumps over the lazy dog';
SET @Signature = SignByCert(Cert_ID('MyTestCertificate'), @PlainText);
SELECT CONVERT([varchar](max), @Signature, 1);

(No column name)

0x01000502040000004D12072BAF34AC63C9F5FA5035313ED74DA9C3175A30B63D89ED48C0BCA78509C59CED887010B3FFDBBBF7C3257196FDC6AA10D7F7858292BC1A20E46998FB6135FD617FB66C16DCA1ABB5C383BFE293AB0FAFFE410D9B6076BF6A582EAB5C95E8928E5F0CC9ED3B0003D876F03DA210934013901610FC6FAA5C613488D8F53938B305F939A91793022A6C35550A86486D70820BBB51D48B2548B7558AD79BC13C58790796ADB688CA8FBB3077D7D4386A0447DF598F5963814D75F4306C78648C42DD4F175BED38EAF5BB9EB6064206308BB13D7901CE05F4FB0FF301AE5470041CD1C4BD649D49B1E2A629E88EAE3D7D215DFE5E654AD09D73C7DCF0CF8F87

DECLARE @PrivKey as varbinary(max); 
DECLARE @PubKey as varbinary(max); 
SET @PrivKey = CERTPRIVATEKEY(Cert_ID('MyTestCertificate'), 'MyTest!Mast3rP4ss')
SET @PubKey = CERTENCODED(Cert_ID('MyTestCertificate'));
SELECT CONVERT([varchar](max), @PrivKey, 1);
SELECT CONVERT([varchar](max), @PubKey, 1);

(No column name)

0x1EF1B5B00000000001000000010000001000000094040000FABDBAD52E1F22E9ACE86D48891B5F3E0702000000A400008FF22CFAD46005F05CD69E2EACDE80B462B198D257C7289933B4E4DEA07B8DB6F72F9561EA47870C7DC89114E460B1F04B90A01310D13663D8247D5FD5FB4016EF6B2004813006486F4D2A8E4794B56C57B7F973E40C64EAC2C270525789FA8A45CA30628BE6C75584DEDEC1102165760E05B39CD006BDFE26CCD0EB3B5E74169A27E7BBC3EDF326DE06962A8D3BC31EE94FA51A7BDC7DB7738D9E3060FF18D2A0F1F0B04D6D0485959944C15A5FBC03CCA3C0E5451C5CA71D0CAAB2FE1274EDA7371C85BE6143239CB455633FF069397133AA30440DC701318B8786FD0961347CC572279B95F38AF820452D60A7E03DDE8EFBC303FD789CDE41499587B9013C26FA2C8623C3781A4FA28521DC075FC3CBB9EAD69C541D2805602C03E9C01B5E91D03D5523DBD74A781FBB5B19E5816D88E291BB30F996BB68F3732EF655A076FF3FC37A1EC4D9BE0B64B00E9F05BDC26006773527D0CEA1D16131060111A91CC703CF99C2D7D45AAFBBB277278C5E2FF8B6BFFBDC590643F5D8494F46136C1069F5E478E18830A0EF2E265BE01AD83905E61B99DDAAFFCD89F49AC312D1C0EA74A65902D9AEBBED0CC3390CC6C9E214B7CEFC1FC9AE37180541744866E791A031FE3FAD900BCF9A54B71676F4E947C68D87B43FEB270887F398C6F16644DF0B1A6FEE521E6187B603F99CC72CADB90BE19119B2D71F9ECF3117C53B3D2309BD884D0C41F992E66ACBF876429F93ED337025B0D03CB118F88E00AFFA2CB91603BCF3E2F0E5A4A40A842205E0F10B33392BF7099AF25B29AEDA07C5A9DB52CF4B7A6069A4AC5B9AC489528381E45F00558F0DBB540C8718D0D01A37FCAC0254E5894B68E01E22905D7661E886116FD635FB696064007CD24DE26D47177CA6C9430E81E891B24A104C093F91E22FAECBE06B27E86503A9242610119F7181B04ECBC519D57218FAB3467812BDD7A9E33EC6B8F9E073F36349BBDF76327357CA452968A6156553D8F5CF88930195F2554ECC89E4216BD8960A72A508A4ADF5FE5E4178BEB7C1AC0F6D53FD680EE2BB043E641960E2EC2656AB1FB718AD5C8EC37A78FA3D5083B8315B806F569D542005A32609EEC406A103E833031108FA1C4EFD7A76FA00226762922CEA6CDF176A362993826492AC68A63097C070B0B20FA9E5692DA5A2044926AEDC6952B1E02531C8050E3A740B991A20E0624A768DF8990A18C51BC3402FDEC19C93A2F80455ADE1D005610A5B56075BB5E5C84E0DAF4C999D1D4A127EE689FE4BADB00277203D46E7CCF94094E4C3153F444D8EEE7F60410A925ABEBD385BBB4BE7E385446D4893C64A45A547ED621753C29D2AA61123DA1F4ADE8172F9AD72F2D92B0B6FA5BF91DA48877B8677BDD9C181B54863F4CBD43080993ACD9F07AECEB5FF272325240925A2DF30251D52457AA9C72F9CE5FC5AF828DC0BC4789E2FDA222F4B814C6C2AF1F87C470C4EB980051A1CF4D68E587E2927D02713A9C26A47934277FD9D997F30B60CE24E9A540A7FB1C445AC6BE75DC2760D23E72C575A23BE4E25F5EDB3DD1331A44A134A75EC71CF87FB8F5C166D1F07EFB815978CF08B36AC9ACA243C1FD6829BB06C585BB4E17EA401F1D3C3A6AD5B533CFDD0A8C3FDEA88D882

(No column name)

0x3082036B30820253A00302010202146472932AE654353AF660E02361C2062FC040FEE6300D06092A864886F70D01010B05003045310B30090603550406130241553113301106035504080C0A536F6D652D53746174653121301F060355040A0C18496E7465726E6574205769646769747320507479204C7464301E170D3233313132303137303835375A170D3234313131393137303835375A3045310B30090603550406130241553113301106035504080C0A536F6D652D53746174653121301F060355040A0C18496E7465726E6574205769646769747320507479204C746430820122300D06092A864886F70D01010105000382010F003082010A0282010100CF9CCF5AF133484FC7DC8FF41C1B9010FC7821B373D0352A57E76A0FA0456AE1F35FDCED60343551594FC0E636727AF868EC237978BBBAE8C366B955A507CB942A3380755F6565F1811BF4476948008F18F3BEBE852540C660A781B362DAD21E70567CE70363EB4DE0F281DB239381308C2A8664B066F7F3331038E62465FC837AF170346AB63D1D18CA0400A6FC41EEE87FEFFB80C01D2FF7B86A1E48F299FA4BECA495C8B33CCB3A9603731AC9CE6B6F55EA1EB91DD919DCCBB17833CB1FB67C97891AF9FAC34EFDB2E7777DF5DFD7E4172638ED65ECBAE08AB5E17EB7EA81937DAAA79F9B041BE3C05488423BB3EF1B26C91D91CF7FD9D7A42E8E5582DA5F0203010001A3533051301D0603551D0E041604145F7A25691BA68CF1D6B59AD50E8F2CA6D0403018301F0603551D230418301680145F7A25691BA68CF1D6B59AD50E8F2CA6D0403018300F0603551D130101FF040530030101FF300D06092A864886F70D01010B0500038201010064E1E3CB35A81CB136B599134D0F536A4D1776CE26B2822B33C415C8E65EE4A8A5E185668455DDF326A4219CAB87D12ED59E85BDA31521201998165F41979CA0DB6608AF2A5D5A3A7566082B6E7B1204666233312E0FFABFF427DDB8E37415559CD8B5405F13425078ACDC1C02AECD3DE372FDC9DE0DCE9A74F3716AF2D0D2ACD06F6070AB620A5E6A5575CA760AED728AAD8549B047345D4F286EA51CB005719B2396F5C0340FB94162EE9E7EAC247CE402169FC754EACAC818C08DAD0A796D336F4437D665CD7ABAB1ED9E30D6213ED2328859709884C35BE1143861429A84FA2CE530F95434554B33131AA66EC6ABC22091E91072242B466877ED6D82C137