{"id":30377,"date":"2024-02-28T05:54:00","date_gmt":"2024-02-28T04:54:00","guid":{"rendered":"https:\/\/expert-only.com\/?p=30377"},"modified":"2024-03-01T10:03:52","modified_gmt":"2024-03-01T09:03:52","slug":"comment-appeler-une-fonction-sql-server","status":"publish","type":"post","link":"https:\/\/expert-only.com\/fr\/t-sql\/comment-appeler-une-fonction-sql-server\/","title":{"rendered":"Comment Appeler une Fonction SQL Server ?"},"content":{"rendered":"\n<h4 class=\"wp-block-heading has-text-align-left\" id=\"h-comment-appeler-des-fonctions-sql-server-depuis-des-scripts-transact-sql\"><strong><em>Comment appeler des fonctions SQL Server depuis des scripts Transact-SQL ?<\/em><\/strong><\/h4>\n\n\n\n<p>Tutoriel sur comment utiliser une fonction SQL Server avec des scripts T-SQL, avec ou sans param\u00e8tres. En effet, la syntaxe T-SQL pour appeler une fonction diff\u00e8re de celle pour appeler une proc\u00e9dure stock\u00e9e. Utilisez la fonction SQL Server de la m\u00eame mani\u00e8re que vous s\u00e9lectionnez des donn\u00e9es depuis une table. Apprendre \u00e0 appeler une fonction SQL Server d\u00e9finie par l&rsquo;utilisateur avec un script T-SQL est essentiel pour optimiser la maintenance de votre base de donn\u00e9es et faciliter la manipulation des donn\u00e9es.<\/p>\n\n\n\n<p>Dans ce tutoriel SQL, nous examinerons comment utiliser une fonction d\u00e9finie par l&rsquo;utilisateur et comment personnaliser la sortie de la fonction pour r\u00e9pondre \u00e0 des besoins sp\u00e9cifiques. Une <a href=\"https:\/\/expert-only.com\/fr\/t-sql\/creer-fonction-sql-server-avec-un-script\/\"><strong>fonction SQL Server d\u00e9finie par l&rsquo;utilisateur<\/strong><\/a> est un programme Transact-SQL qui accepte des param\u00e8tres d&rsquo;entr\u00e9e. Lorsqu&rsquo;elle est appel\u00e9e, elle effectue des actions, telles que la lecture d&rsquo;une table SQL Server, et retourne un r\u00e9sultat de sortie.<\/p>\n\n\n\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_82_2 ez-toc-wrap-center counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<span class=\"ez-toc-title-toggle\"><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/expert-only.com\/fr\/t-sql\/comment-appeler-une-fonction-sql-server\/#1-le-parametre-dentree-nest-pas-obligatoire-dans-une-fonction-sql-server\" >1. Le param\u00e8tre d&rsquo;entr\u00e9e n&rsquo;est pas obligatoire dans une fonction SQL Server<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/expert-only.com\/fr\/t-sql\/comment-appeler-une-fonction-sql-server\/#2-le-resultat-de-sortie-est-obligatoire-dans-les-fonctions-t-sql\" >2. Le r\u00e9sultat de sortie est obligatoire dans les fonctions T-SQL<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/expert-only.com\/fr\/t-sql\/comment-appeler-une-fonction-sql-server\/#3-appeler-une-fonction-sql-server-et-renommer-la-colonne-de-sortie\" >3. Appeler une fonction SQL Server et renommer la colonne de sortie<\/a><\/li><\/ul><\/nav><\/div>\n<h2 class=\"wp-block-heading\" id=\"h-1-le-parametre-d-entree-n-est-pas-obligatoire-dans-une-fonction-sql-server\"><span class=\"ez-toc-section\" id=\"1-le-parametre-dentree-nest-pas-obligatoire-dans-une-fonction-sql-server\"><\/span>1. Le param\u00e8tre d&rsquo;entr\u00e9e n&rsquo;est pas obligatoire dans une fonction SQL Server<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Une fonction n&rsquo;a pas n\u00e9cessairement besoin d&rsquo;un param\u00e8tre d&rsquo;entr\u00e9e. Cependant, une fonction SQL Server d\u00e9finie par l&rsquo;utilisateur <a href=\"https:\/\/opac.imist.ma\/cgi-bin\/koha\/opac-detail.pl?biblionumber=39629\" target=\"_blank\" rel=\"noreferrer noopener\">retourne des donn\u00e9es<\/a>, qui peuvent \u00eatre un ensemble de r\u00e9sultats vide, une seule ligne ou plusieurs colonnes. Par exemple, appelons la fonction cr\u00e9\u00e9e dans ce tutoriel pour cr\u00e9er une fonction MS SQL avec un script. Par exemple, si vous appelez la fonction int\u00e9gr\u00e9e pour afficher la date dans SQL Server, le syst\u00e8me retourne la date actuelle.<\/p>\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=\"\">SELECT GETDATE();\n<\/pre>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-2-le-resultat-de-sortie-est-obligatoire-dans-les-fonctions-t-sql\"><span class=\"ez-toc-section\" id=\"2-le-resultat-de-sortie-est-obligatoire-dans-les-fonctions-t-sql\"><\/span>2. Le r\u00e9sultat de sortie est obligatoire dans les fonctions T-SQL<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>En effet, une fonction est d\u00e9finie par le fait qu&rsquo;elle retourne un r\u00e9sultat. Pour appeler une fonction, ouvrez SSMS et adaptez le code de la fonction si n\u00e9cessaire. Consid\u00e9rez ce script pour cr\u00e9er une fonction appel\u00e9e dbo.ufnDisplayCustomers en T-SQL :<\/p>\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 FUNCTION dbo.ufnDisplayCustomers(@CustomerID INTEGER)\nRETURNS NVARCHAR(20)\nAS \nBEGIN \n  DECLARE @CustomerName  AS NVARCHAR(20);\n  SELECT  @CustomerName = [Name]\n  FROM    [dbo].[Customers]\n  WHERE   [CustomerID] = @CustomerID;\n  RETURN  @CustomerName;\nEND\nGO\n<\/pre>\n\n\n\n<p>Pour appeler une fonction SQL Server, utilisez la syntaxe suivante :<\/p>\n\n\n\n<p><em><strong>SELECT dbo.FunctionName(Parameters);<\/strong><\/em><\/p>\n\n\n\n<p>La fonction ci-dessous affiche le nom d&rsquo;un client associ\u00e9 au num\u00e9ro de client pass\u00e9 en param\u00e8tre. Bien s\u00fbr, nous supposons que vous avez une table avec au moins ces deux colonnes, comme dans l&rsquo;exemple.<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>CustomerID<\/li>\n\n\n\n<li>Name<\/li>\n<\/ol>\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=\"\">\/* Expert-Only.com *\/ \nSELECT [CustomerID]\n      ,[Name]\n  FROM [Expert-Only].[dbo].[Customers];\n\n\n\/* Expert-Only.com *\/ \nSELECT dbo.ufnDisplayCustomers(1);\n<\/pre>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"640\" height=\"580\" src=\"https:\/\/expert-only.com\/wp-content\/uploads\/2023\/07\/sql-server-function-from-t-sql-query.jpg\" alt=\"Exemple de requ\u00eate pour appeler une fonction SQL Server depuis T-SQL\" class=\"wp-image-30356\" srcset=\"https:\/\/expert-only.com\/wp-content\/uploads\/2023\/07\/sql-server-function-from-t-sql-query.jpg 640w, https:\/\/expert-only.com\/wp-content\/uploads\/2023\/07\/sql-server-function-from-t-sql-query-300x272.jpg 300w\" sizes=\"auto, (max-width: 640px) 100vw, 640px\" \/><figcaption class=\"wp-element-caption\"><em>Exemple de requ\u00eate pour appeler une fonction SQL Server en T-SQL<\/em><\/figcaption><\/figure><\/div>\n\n\n<figure class=\"wp-block-embed aligncenter 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=\"phF6DCxi5t\"><a href=\"https:\/\/expert-only.com\/en\/t-sql\/how-to-create-a-sql-server-function\/\">How to create a SQL Server function with a 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\u00a0How to create a SQL Server function with a script ?\u00a0\u00bb &#8212; Tutoriels SQL et IT\" src=\"https:\/\/expert-only.com\/en\/t-sql\/how-to-create-a-sql-server-function\/embed\/#?secret=nzkNwYokqb#?secret=phF6DCxi5t\" data-secret=\"phF6DCxi5t\" width=\"500\" height=\"282\" frameborder=\"0\" marginwidth=\"0\" marginheight=\"0\" scrolling=\"no\"><\/iframe>\n<\/div><\/figure>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"h-3-appeler-une-fonction-sql-server-et-renommer-la-colonne-de-sortie\"><span class=\"ez-toc-section\" id=\"3-appeler-une-fonction-sql-server-et-renommer-la-colonne-de-sortie\"><\/span>3. Appeler une fonction SQL Server et renommer la colonne de sortie<span class=\"ez-toc-section-end\"><\/span><\/h2>\n\n\n\n<p>Avec ce deuxi\u00e8me exemple d&rsquo;appel, nous pouvons \u00e9galement renommer la colonne de r\u00e9sultat pour personnaliser la sortie. Pour ce faire, utilisez la syntaxe g\u00e9n\u00e9rique ci-dessous :<\/p>\n\n\n\n<p><em><strong>SELECT dbo.FunctionName(Parameters) AS [NewColumnName];<\/strong><\/em><\/p>\n\n\n\n<p>Voici un exemple pratique, utilisant les donn\u00e9es des clients, donc la fonction est utilis\u00e9e pour afficher le nom des clients en fonction de l&rsquo;ID client, puis la colonne de r\u00e9sultat est renomm\u00e9e en <em>CustomerName<\/em>, de la m\u00eame mani\u00e8re que les colonnes sont renomm\u00e9es dans les requ\u00eates SELECT de SQL Server.<\/p>\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=\"\">SELECT dbo.ufnDisplayCustomers(1) AS [CustomerName]; \n<\/pre>\n\n\n\n<p>Dans cet autre tutoriel, nous expliquons <a href=\"https:\/\/expert-only.com\/fr\/t-sql\/modifier-une-fonction-sql-server\/\"><strong>comment modifier une fonction SQL Server existante<\/strong><\/a>. Pour des informations plus approfondies et officielles sur les fonctions utilisateurs SQL Server, lisez directement la <a href=\"https:\/\/learn.microsoft.com\/en-us\/sql\/relational-databases\/user-defined-functions\/user-defined-functions?view=sql-server-2017\" target=\"_blank\" rel=\"noreferrer noopener nofollow\">documentation<\/a> MS sur le site de Microsoft. La documentation en anglais est g\u00e9n\u00e9ralement plus riche et plus compl\u00e8te que dans d&rsquo;autres langues, y compris le fran\u00e7ais. Le forum officiel Microsoft sur les bases de donn\u00e9es et les pages de support en anglais sont \u00e9galement beaucoup plus actifs que dans d&rsquo;autres langues.<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"h-a-propos-de-l-appel-des-fonctions-sql-server-depuis-des-scripts-t-sql\">\u00c0 propos de l&rsquo;appel des fonctions SQL Server depuis des scripts T-SQL<\/h3>\n\n\n\n<p>En conclusion, nous avons vu comment appeler une fonction SQL Server \u00e0 partir d&rsquo;un script T-SQL, c&rsquo;est une op\u00e9ration n\u00e9cessaire pour optimiser et surtout r\u00e9utiliser efficacement le code dans votre base de donn\u00e9es. Ce tutoriel vous a montr\u00e9 comment cr\u00e9er, appeler et personnaliser les fonctions SQL Server. En ma\u00eetrisant ces techniques, vous pourrez tirer le meilleur parti de votre base de donn\u00e9es SQL Server et am\u00e9liorer significativement la performance de vos applications.<\/p>\n\n\n\n<figure class=\"wp-block-embed aligncenter 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=\"maX70L90bm\"><a href=\"https:\/\/expert-only.com\/en\/t-sql\/manage-sql-server-user-defined-functions\/\">Manage SQL Server user defined functions<\/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\u00a0Manage SQL Server user defined functions\u00a0\u00bb &#8212; Tutoriels SQL et IT\" src=\"https:\/\/expert-only.com\/en\/t-sql\/manage-sql-server-user-defined-functions\/embed\/#?secret=Z67NMGZgnQ#?secret=maX70L90bm\" data-secret=\"maX70L90bm\" 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 appeler des fonctions SQL Server depuis des scripts Transact-SQL ? Tutoriel sur comment utiliser une fonction SQL Server avec des scripts T-SQL, avec ou sans param\u00e8tres. En effet, la syntaxe T-SQL pour appeler une fonction diff\u00e8re de celle <a class=\"mh-excerpt-more\" href=\"https:\/\/expert-only.com\/fr\/t-sql\/comment-appeler-une-fonction-sql-server\/\" title=\"Comment Appeler une Fonction SQL Server ?\">&#8230;<\/a><\/p>\n<\/div>","protected":false},"author":1,"featured_media":26335,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[12],"tags":[],"class_list":{"0":"post-30377","1":"post","2":"type-post","3":"status-publish","4":"format-standard","5":"has-post-thumbnail","7":"category-t-sql"},"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>Comment Appeler une Fonction SQL Server ? T-SQL<\/title>\n<meta name=\"description\" content=\"Pour appeler une fonction SQL Server depuis un script T-SQL et afficher les donn\u00e9es renvoy\u00e9es par la fonction, utiliser une requ\u00eate SELECT.\" \/>\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\/comment-appeler-une-fonction-sql-server\/\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Comment Appeler une Fonction SQL Server ?\" \/>\n<meta property=\"og:description\" content=\"Pour appeler une fonction SQL Server depuis un script T-SQL et afficher les donn\u00e9es renvoy\u00e9es par la fonction, utiliser une requ\u00eate SELECT.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/expert-only.com\/fr\/t-sql\/comment-appeler-une-fonction-sql-server\/\" \/>\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=\"2024-02-28T04:54:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-01T09:03:52+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/inspiration_dark_new-york-city-F323EDDD185_1920x1080.jpeg\" \/>\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\/comment-appeler-une-fonction-sql-server\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/comment-appeler-une-fonction-sql-server\/\"},\"author\":{\"name\":\"Expert-Only\",\"@id\":\"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef\"},\"headline\":\"Comment Appeler une Fonction SQL Server ?\",\"datePublished\":\"2024-02-28T04:54:00+00:00\",\"dateModified\":\"2024-03-01T09:03:52+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/comment-appeler-une-fonction-sql-server\/\"},\"wordCount\":710,\"publisher\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#organization\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/comment-appeler-une-fonction-sql-server\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/inspiration_dark_new-york-city-F323EDDD185_1920x1080.jpeg\",\"articleSection\":[\"T-SQL\"],\"inLanguage\":\"fr-FR\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/comment-appeler-une-fonction-sql-server\/\",\"url\":\"https:\/\/expert-only.com\/fr\/t-sql\/comment-appeler-une-fonction-sql-server\/\",\"name\":\"Comment Appeler une Fonction SQL Server ? T-SQL\",\"isPartOf\":{\"@id\":\"https:\/\/expert-only.com\/fr\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/comment-appeler-une-fonction-sql-server\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/comment-appeler-une-fonction-sql-server\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/inspiration_dark_new-york-city-F323EDDD185_1920x1080.jpeg\",\"datePublished\":\"2024-02-28T04:54:00+00:00\",\"dateModified\":\"2024-03-01T09:03:52+00:00\",\"description\":\"Pour appeler une fonction SQL Server depuis un script T-SQL et afficher les donn\u00e9es renvoy\u00e9es par la fonction, utiliser une requ\u00eate SELECT.\",\"breadcrumb\":{\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/comment-appeler-une-fonction-sql-server\/#breadcrumb\"},\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/expert-only.com\/fr\/t-sql\/comment-appeler-une-fonction-sql-server\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/comment-appeler-une-fonction-sql-server\/#primaryimage\",\"url\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/inspiration_dark_new-york-city-F323EDDD185_1920x1080.jpeg\",\"contentUrl\":\"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/inspiration_dark_new-york-city-F323EDDD185_1920x1080.jpeg\",\"width\":1920,\"height\":1080},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/expert-only.com\/fr\/t-sql\/comment-appeler-une-fonction-sql-server\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Accueil\",\"item\":\"https:\/\/expert-only.com\/fr\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Comment Appeler une Fonction SQL Server ?\"}]},{\"@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":"Comment Appeler une Fonction SQL Server ? T-SQL","description":"Pour appeler une fonction SQL Server depuis un script T-SQL et afficher les donn\u00e9es renvoy\u00e9es par la fonction, utiliser une requ\u00eate SELECT.","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\/comment-appeler-une-fonction-sql-server\/","og_locale":"fr_FR","og_type":"article","og_title":"Comment Appeler une Fonction SQL Server ?","og_description":"Pour appeler une fonction SQL Server depuis un script T-SQL et afficher les donn\u00e9es renvoy\u00e9es par la fonction, utiliser une requ\u00eate SELECT.","og_url":"https:\/\/expert-only.com\/fr\/t-sql\/comment-appeler-une-fonction-sql-server\/","og_site_name":"Tutoriels SQL et IT","article_publisher":"https:\/\/www.facebook.com\/ExpertOnlyCom\/","article_published_time":"2024-02-28T04:54:00+00:00","article_modified_time":"2024-03-01T09:03:52+00:00","og_image":[{"width":1920,"height":1080,"url":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/inspiration_dark_new-york-city-F323EDDD185_1920x1080.jpeg","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\/comment-appeler-une-fonction-sql-server\/#article","isPartOf":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/comment-appeler-une-fonction-sql-server\/"},"author":{"name":"Expert-Only","@id":"https:\/\/expert-only.com\/fr\/#\/schema\/person\/406a9576b52944f018739a42046873ef"},"headline":"Comment Appeler une Fonction SQL Server ?","datePublished":"2024-02-28T04:54:00+00:00","dateModified":"2024-03-01T09:03:52+00:00","mainEntityOfPage":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/comment-appeler-une-fonction-sql-server\/"},"wordCount":710,"publisher":{"@id":"https:\/\/expert-only.com\/fr\/#organization"},"image":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/comment-appeler-une-fonction-sql-server\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/inspiration_dark_new-york-city-F323EDDD185_1920x1080.jpeg","articleSection":["T-SQL"],"inLanguage":"fr-FR"},{"@type":"WebPage","@id":"https:\/\/expert-only.com\/fr\/t-sql\/comment-appeler-une-fonction-sql-server\/","url":"https:\/\/expert-only.com\/fr\/t-sql\/comment-appeler-une-fonction-sql-server\/","name":"Comment Appeler une Fonction SQL Server ? T-SQL","isPartOf":{"@id":"https:\/\/expert-only.com\/fr\/#website"},"primaryImageOfPage":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/comment-appeler-une-fonction-sql-server\/#primaryimage"},"image":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/comment-appeler-une-fonction-sql-server\/#primaryimage"},"thumbnailUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/inspiration_dark_new-york-city-F323EDDD185_1920x1080.jpeg","datePublished":"2024-02-28T04:54:00+00:00","dateModified":"2024-03-01T09:03:52+00:00","description":"Pour appeler une fonction SQL Server depuis un script T-SQL et afficher les donn\u00e9es renvoy\u00e9es par la fonction, utiliser une requ\u00eate SELECT.","breadcrumb":{"@id":"https:\/\/expert-only.com\/fr\/t-sql\/comment-appeler-une-fonction-sql-server\/#breadcrumb"},"inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/expert-only.com\/fr\/t-sql\/comment-appeler-une-fonction-sql-server\/"]}]},{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/expert-only.com\/fr\/t-sql\/comment-appeler-une-fonction-sql-server\/#primaryimage","url":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/inspiration_dark_new-york-city-F323EDDD185_1920x1080.jpeg","contentUrl":"https:\/\/expert-only.com\/wp-content\/uploads\/2017\/08\/inspiration_dark_new-york-city-F323EDDD185_1920x1080.jpeg","width":1920,"height":1080},{"@type":"BreadcrumbList","@id":"https:\/\/expert-only.com\/fr\/t-sql\/comment-appeler-une-fonction-sql-server\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Accueil","item":"https:\/\/expert-only.com\/fr\/"},{"@type":"ListItem","position":2,"name":"Comment Appeler une Fonction SQL Server ?"}]},{"@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\/30377","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=30377"}],"version-history":[{"count":2,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/posts\/30377\/revisions"}],"predecessor-version":[{"id":30383,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/posts\/30377\/revisions\/30383"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/media\/26335"}],"wp:attachment":[{"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/media?parent=30377"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/categories?post=30377"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/expert-only.com\/fr\/wp-json\/wp\/v2\/tags?post=30377"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}