{"id":2040,"date":"2022-08-04T07:21:24","date_gmt":"2022-08-04T05:21:24","guid":{"rendered":"https:\/\/expert-only.com\/?p=2040"},"modified":"2022-09-19T16:57:00","modified_gmt":"2022-09-19T14:57:00","slug":"creer-vue-sql-server-avec-encryptage","status":"publish","type":"post","link":"https:\/\/expert-only.com\/fr\/t-sql\/creer-vue-sql-server-avec-encryptage\/","title":{"rendered":"Cr\u00e9er une vue SQL Server avec encryptage"},"content":{"rendered":"\n<p>Comment cr\u00e9er une vue SQL Server avec l&rsquo;option d&rsquo;encryptage ? L&rsquo;option WITH ENCRYPTION en Anglais ou chiffrement en Fran\u00e7ais permet de masquer le code la vue. Voici un exemple de code en langage T-SQL pour cr\u00e9er une vue avec l&rsquo;option WITH ENCRYPTION.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-creer-une-vue-sql-server-avec-l-option-d-encryptage\">Cr\u00e9er une vue SQL Server avec l&rsquo;option d&rsquo;encryptage<\/h2>\n\n\n\n<p>Tout d&rsquo;abord, voici le tutoriel original avec le script de cr\u00e9ation de la <a href=\"https:\/\/expert-only.com\/transact-sql\/creer-vue-sql-server-avec-script\/\">vue des ventes<\/a> utilis\u00e9e dans l&rsquo;exemple et dans bien d&rsquo;autres tutoriels.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">D\u00e9finition du chiffrement<\/h3>\n\n\n\n<p>De plus, avant de voir le code de la vue avec chiffrement et son principe, que signifie le chiffrement ? Le chiffrement, au sens classique signifie de masquer des donn\u00e9es en rempla\u00e7ant chaque lettre par une autre lettre. Pour cela un syst\u00e8me de chiffrement utilise deux types de clefs : <\/p>\n\n\n\n<ul class=\"wp-block-list\"><li><strong>Une cl\u00e9 publique<\/strong> (ou fonction \u00e0 sens unique) qui permet uniquement d&rsquo;encrypter un message sans le d\u00e9chiffrer<\/li><li><strong>Une cl\u00e9 priv\u00e9e<\/strong> qui permet de d\u00e9chiffrer un message<\/li><\/ul>\n\n\n\n<p>Ainsi par s\u00e9curit\u00e9 communique la clef publique et jamais la clef priv\u00e9e.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">Script SQL pour cr\u00e9er une vue avec l&rsquo;option de chiffrement<\/h3>\n\n\n\n<p>Utiliser le code SQL suivant pour cr\u00e9er une vue SQL Server avec CREATE VIEW et l&rsquo;option WITH ENCRYPTION. Cette option masque donc le code T-SQL dans la table <a href=\"https:\/\/langue-francaise.tv5monde.com\/decouvrir\/dictionnaire\/s\/systeme\" target=\"_blank\" rel=\"noreferrer noopener\">syst\u00e8me<\/a> <strong>sys.syscomments<\/strong>. <\/p>\n\n\n\n<p>Dans l&rsquo;exemple ci-dessous, cr\u00e9er deux vues : <\/p>\n\n\n\n<ul class=\"wp-block-list\"><li>La vue V_SALES qui est une vue classique c&rsquo;est \u00e0 dire sans l&rsquo;option d&rsquo;encryptage<\/li><li>La vue V_SALES_E avec l&rsquo;option de chiffrement activ\u00e9.<\/li><\/ul>\n\n\n\n<pre class=\"EnlighterJSRAW\" data-enlighter-language=\"mssql\" data-enlighter-theme=\"\" data-enlighter-highlight=\"\" data-enlighter-linenumbers=\"\" data-enlighter-lineoffset=\"\" data-enlighter-title=\"\" data-enlighter-group=\"\">CREATE VIEW [dbo].[V_SALES]\nAS \n\tSELECT [Year]\n\t\t  ,[MonthName]\n\t\t  ,[MonthCurrent]\n\t\t  ,[NumberMonth]\n\t\t  ,[EmployeeNumber]\n\t\t  ,[NumberOfClients]\n\t\t  ,[NumberOfSales]\n\t\t  ,[Amount_ET]\n\t\t  ,[Amount_IT]\n\t  FROM [dbo].[SALES];\nGO\n\nCREATE VIEW [dbo].[V_SALES_E]\nWITH ENCRYPTION \nAS \n\tSELECT [Year]\n\t\t  ,[MonthName]\n\t\t  ,[MonthCurrent]\n\t\t  ,[NumberMonth]\n\t\t  ,[EmployeeNumber]\n\t\t  ,[NumberOfClients]\n\t\t  ,[NumberOfSales]\n\t\t  ,[Amount_ET]\n\t\t  ,[Amount_IT]\n\t  FROM [dbo].[SALES];\nGO\n<\/pre>\n\n\n\n<p>Ainsi l&rsquo;option WITH ENCRYPTION chiffre et masque simplement le code SQL de la vue dans la table syst\u00e8me&nbsp;sys.syscomments pour que la vue ne soit pas publi\u00e9e si la r\u00e9plication SQL Server est utilis\u00e9e.<\/p>\n\n\n\n<p>Pour v\u00e9rifier le fonctionnement de cette option il suffit d&rsquo;ex\u00e9cuter une requ\u00eate sur la table syst\u00e8me sys.syscomments:<\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"968\" height=\"279\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/08\/sql-server-view-with-encryption.jpg\" alt=\"Cr\u00e9er une vue avec encryptage masque le code dans la table syst\u00e8me\" class=\"wp-image-9471\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/08\/sql-server-view-with-encryption.jpg 968w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/08\/sql-server-view-with-encryption-300x86.jpg 300w, https:\/\/expert-only.com\/wp-content\/uploads\/2022\/08\/sql-server-view-with-encryption-768x221.jpg 768w\" sizes=\"auto, (max-width: 968px) 100vw, 968px\" \/><figcaption><strong>Cr\u00e9er une vue avec encryptage masque le code dans la table syst\u00e8me<\/strong><\/figcaption><\/figure><\/div>\n\n\n<p>Le code de la premi\u00e8re vue est bien visible tandis que celui de la deuxi\u00e8me vue avec le chiffrement activ\u00e9 ne l&rsquo;est pas.  <\/p>\n\n\n\n<p>Note: L&rsquo;option n&rsquo;encrypte donc pas les donn\u00e9es mais le code de la vue. Pour cela il existe des fonctions de chiffrement SQL Server pour masquer et chiffre les donn\u00e9es sensibles dans les bases MSSQL.<\/p>\n\n\n\n<p>Pour aller plus loin et d\u00e9couvrir des vues avec des agr\u00e9gations et des conditions, voici un tutoriel pour <a href=\"https:\/\/expert-only.com\/transact-sql\/creer-vue-sql-server-avec-script\/\">cr\u00e9er des vues SQL Server avec des scripts<\/a>.<\/p>\n\n\n\n<figure class=\"wp-block-embed is-type-wp-embed is-provider-tutoriels-sql-et-it wp-block-embed-tutoriels-sql-et-it\"><div class=\"wp-block-embed__wrapper\">\n<blockquote class=\"wp-embedded-content\" data-secret=\"DQkTSmLOTI\"><a href=\"https:\/\/expert-only.com\/fr\/t-sql\/creer-vue-sql-server-avec-script\/\">Cr\u00e9er une vue SQL Server avec un script<\/a><\/blockquote><iframe loading=\"lazy\" class=\"wp-embedded-content\" sandbox=\"allow-scripts\" security=\"restricted\" style=\"position: absolute; clip: rect(1px, 1px, 1px, 1px);\" title=\"\u00ab\u00a0Cr\u00e9er une vue SQL Server avec un script\u00a0\u00bb &#8212; Tutoriels SQL et IT\" src=\"https:\/\/expert-only.com\/fr\/t-sql\/creer-vue-sql-server-avec-script\/embed\/#?secret=zP1BhujnPH#?secret=DQkTSmLOTI\" data-secret=\"DQkTSmLOTI\" width=\"500\" height=\"282\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>\n<\/div><\/figure>\n","protected":false},"excerpt":{"rendered":"<div class=\"mh-excerpt\"><p>Comment cr\u00e9er une vue SQL Server avec l&rsquo;option d&rsquo;encryptage ? L&rsquo;option WITH ENCRYPTION en Anglais ou chiffrement en Fran\u00e7ais permet de masquer le code la vue. Voici un exemple de code en langage T-SQL pour cr\u00e9er une vue avec <a class=\"mh-excerpt-more\" href=\"https:\/\/expert-only.com\/fr\/t-sql\/creer-vue-sql-server-avec-encryptage\/\" title=\"Cr\u00e9er une vue SQL Server avec encryptage\">&#8230;<\/a><\/p>\n<\/div>","protected":false},"author":1,"featured_media":10497,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[12],"tags":[53],"class_list":{"0":"post-2040","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-t-sql","8":"tag-create"},"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.7 (Yoast SEO v26.2) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Cr\u00e9er une vue SQL Server avec encryptage - T-SQL<\/title>\n<meta name=\"description\" content=\"Cr\u00e9er une vue SQL Server avec encryptage permet un chiffrement du code SQL de la vue dans la table syst\u00e8me sys.syscomments.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/expert-only.com\/fr\/t-sql\/creer-vue-sql-server-avec-encryptage\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Cr\u00e9er une vue SQL Server avec encryptage\" \/>\n<meta property=\"og:description\" content=\"Cr\u00e9er une vue SQL Server avec encryptage permet un chiffrement du code SQL de la vue dans la table syst\u00e8me sys.syscomments.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/expert-only.com\/fr\/t-sql\/creer-vue-sql-server-avec-encryptage\/\" \/>\n<meta property=\"og:site_name\" content=\"Tutoriels SQL et IT\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/ExpertOnlyCom\/\" \/>\n<meta property=\"article:published_time\" content=\"2022-08-04T05:21:24+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-09-19T14:57:00+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/clock-6830535_1920x1080.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1920\" \/>\n\t<meta property=\"og:image:height\" content=\"1080\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Expert-Only\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@expert_only\" \/>\n<meta name=\"twitter:site\" content=\"@expert_only\" \/>\n<meta name=\"twitter:label1\" content=\"\u00c9crit par\" \/>\n\t<meta name=\"twitter:data1\" content=\"Expert-Only\" \/>\n\t<meta name=\"twitter:label2\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\n\t<meta name=\"twitter:data2\" content=\"3 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/creer-vue-sql-server-avec-encryptage\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/creer-vue-sql-server-avec-encryptage\/\"},\"author\":{\"name\":\"Expert-Only\",\"@id\":\"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef\"},\"headline\":\"Cr\u00e9er une vue SQL Server avec encryptage\",\"datePublished\":\"2022-08-04T05:21:24+00:00\",\"dateModified\":\"2022-09-19T14:57:00+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/creer-vue-sql-server-avec-encryptage\/\"},\"wordCount\":452,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#organization\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/creer-vue-sql-server-avec-encryptage\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/clock-6830535_1920x1080.jpg\",\"keywords\":[\"create\"],\"articleSection\":[\"T-SQL\"],\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/expert-only.com\/fr\/t-sql\/creer-vue-sql-server-avec-encryptage\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/creer-vue-sql-server-avec-encryptage\/\",\"url\":\"https:\/\/expert-only.com\/fr\/t-sql\/creer-vue-sql-server-avec-encryptage\/\",\"name\":\"Cr\u00e9er une vue SQL Server avec encryptage - T-SQL\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/creer-vue-sql-server-avec-encryptage\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/creer-vue-sql-server-avec-encryptage\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/clock-6830535_1920x1080.jpg\",\"datePublished\":\"2022-08-04T05:21:24+00:00\",\"dateModified\":\"2022-09-19T14:57:00+00:00\",\"description\":\"Cr\u00e9er une vue SQL Server avec encryptage permet un chiffrement du code SQL de la vue dans la table syst\u00e8me sys.syscomments.\",\"breadcrumb\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/creer-vue-sql-server-avec-encryptage\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/expert-only.com\/fr\/t-sql\/creer-vue-sql-server-avec-encryptage\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/creer-vue-sql-server-avec-encryptage\/#primaryimage\",\"url\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/clock-6830535_1920x1080.jpg\",\"contentUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/clock-6830535_1920x1080.jpg\",\"width\":1920,\"height\":1080},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/creer-vue-sql-server-avec-encryptage\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/expert-only.com\/fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Cr\u00e9er une vue SQL Server avec encryptage\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/expert-only.com\/fr\/#website\",\"url\":\"https:\/\/expert-only.com\/fr\/\",\"name\":\"Tutoriels SQL et IT\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/expert-only.com\/fr\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"fr-FR\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/expert-only.com\/fr\/#organization\",\"name\":\"Expert-Only\",\"url\":\"https:\/\/expert-only.com\/fr\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/expert-only.com\/fr\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg\",\"contentUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg\",\"width\":381,\"height\":174,\"caption\":\"Expert-Only\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/ExpertOnlyCom\/\",\"https:\/\/x.com\/expert_only\",\"https:\/\/www.youtube.com\/channel\/UCMS5sR_FwAetB0FmciNvUaA\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef\",\"name\":\"Expert-Only\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/expert-only.com\/fr\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g\",\"caption\":\"Expert-Only\"}}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"Cr\u00e9er une vue SQL Server avec encryptage - T-SQL","description":"Cr\u00e9er une vue SQL Server avec encryptage permet un chiffrement du code SQL de la vue dans la table syst\u00e8me sys.syscomments.","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/expert-only.com\/fr\/t-sql\/creer-vue-sql-server-avec-encryptage\/","og_locale":"fr_FR","og_type":"article","og_title":"Cr\u00e9er une vue SQL Server avec encryptage","og_description":"Cr\u00e9er une vue SQL Server avec encryptage permet un chiffrement du code SQL de la vue dans la table syst\u00e8me sys.syscomments.","og_url":"https:\/\/expert-only.com\/fr\/t-sql\/creer-vue-sql-server-avec-encryptage\/","og_site_name":"Tutoriels SQL et IT","article_publisher":"https:\/\/www.facebook.com\/ExpertOnlyCom\/","article_published_time":"2022-08-04T05:21:24+00:00","article_modified_time":"2022-09-19T14:57:00+00:00","og_image":[{"width":1920,"height":1080,"url":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/clock-6830535_1920x1080.jpg","type":"image\/jpeg"}],"author":"Expert-Only","twitter_card":"summary_large_image","twitter_creator":"@expert_only","twitter_site":"@expert_only","twitter_misc":{"\u00c9crit par":"Expert-Only","Dur\u00e9e de lecture estim\u00e9e":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/expert-only.com\/fr\/t-sql\/creer-vue-sql-server-avec-encryptage\/#article","isPartOf":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/creer-vue-sql-server-avec-encryptage\/"},"author":{"name":"Expert-Only","@id":"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef"},"headline":"Cr\u00e9er une vue SQL Server avec encryptage","datePublished":"2022-08-04T05:21:24+00:00","dateModified":"2022-09-19T14:57:00+00:00","mainEntityOfPage":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/creer-vue-sql-server-avec-encryptage\/"},"wordCount":452,"commentCount":0,"publisher":{"@id":"https:\/\/expert-only.com\/fr\/#organization"},"image":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/creer-vue-sql-server-avec-encryptage\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/clock-6830535_1920x1080.jpg","keywords":["create"],"articleSection":["T-SQL"],"inLanguage":"fr-FR","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/expert-only.com\/fr\/t-sql\/creer-vue-sql-server-avec-encryptage\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/expert-only.com\/fr\/t-sql\/creer-vue-sql-server-avec-encryptage\/","url":"https:\/\/expert-only.com\/fr\/t-sql\/creer-vue-sql-server-avec-encryptage\/","name":"Cr\u00e9er une vue SQL Server avec encryptage - T-SQL","isPartOf":{"@id":"https:\/\/expert-only.com\/fr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/creer-vue-sql-server-avec-encryptage\/#primaryimage"},"image":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/creer-vue-sql-server-avec-encryptage\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/clock-6830535_1920x1080.jpg","datePublished":"2022-08-04T05:21:24+00:00","dateModified":"2022-09-19T14:57:00+00:00","description":"Cr\u00e9er une vue SQL Server avec encryptage permet un chiffrement du code SQL de la vue dans la table syst\u00e8me sys.syscomments.","breadcrumb":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/creer-vue-sql-server-avec-encryptage\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/expert-only.com\/fr\/t-sql\/creer-vue-sql-server-avec-encryptage\/"]}]},{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/expert-only.com\/fr\/t-sql\/creer-vue-sql-server-avec-encryptage\/#primaryimage","url":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/clock-6830535_1920x1080.jpg","contentUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2022\/09\/clock-6830535_1920x1080.jpg","width":1920,"height":1080},{"@type":"BreadcrumbList","@id":"https:\/\/expert-only.com\/fr\/t-sql\/creer-vue-sql-server-avec-encryptage\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/expert-only.com\/fr\/"},{"@type":"ListItem","position":2,"name":"Cr\u00e9er une vue SQL Server avec encryptage"}]},{"@type":"WebSite","@id":"https:\/\/expert-only.com\/fr\/#website","url":"https:\/\/expert-only.com\/fr\/","name":"Tutoriels SQL et IT","description":"","publisher":{"@id":"https:\/\/expert-only.com\/fr\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/expert-only.com\/fr\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"fr-FR"},{"@type":"Organization","@id":"https:\/\/expert-only.com\/fr\/#organization","name":"Expert-Only","url":"https:\/\/expert-only.com\/fr\/","logo":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/expert-only.com\/fr\/#\/schema\/logo\/image\/","url":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg","contentUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/09\/cropped-logo_Expert-Only.jpg","width":381,"height":174,"caption":"Expert-Only"},"image":{"@id":"https:\/\/expert-only.com\/fr\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/ExpertOnlyCom\/","https:\/\/x.com\/expert_only","https:\/\/www.youtube.com\/channel\/UCMS5sR_FwAetB0FmciNvUaA"]},{"@type":"Person","@id":"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef","name":"Expert-Only","image":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/expert-only.com\/fr\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/084b15660763ff5b13bb60b2f52f97bb?s=96&d=identicon&r=g","caption":"Expert-Only"}}]}},"_links":{"self":[{"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/posts\/2040","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/comments?post=2040"}],"version-history":[{"count":0,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/posts\/2040\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/media\/10497"}],"wp:attachment":[{"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/media?parent=2040"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/categories?post=2040"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/tags?post=2040"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}