{"id":216670,"date":"2023-11-08T06:30:00","date_gmt":"2023-11-08T06:30:00","guid":{"rendered":"https:\/\/datascientest.com\/?p=216670"},"modified":"2023-11-09T13:40:31","modified_gmt":"2023-11-09T13:40:31","slug":"sql-rowcount-tout-savoir","status":"publish","type":"post","link":"https:\/\/datascientest.com\/sql-rowcount-tout-savoir","title":{"rendered":"SQL ROWCOUNT : Tout savoir sur les formules SQL"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"216670\" class=\"elementor elementor-216670\" data-elementor-post-type=\"post\">\n\t\t\t\t\t\t\t<div class=\"elementor-element elementor-element-f88ecd8 e-flex e-con-boxed e-con\" data-id=\"f88ecd8\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-2be1b1e elementor-widget elementor-widget-heading\" data-id=\"2be1b1e\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-heading-title{padding:0;margin:0;line-height:1}.elementor-widget-heading .elementor-heading-title[class*=elementor-size-]>a{color:inherit;font-size:inherit;line-height:inherit}.elementor-widget-heading .elementor-heading-title.elementor-size-small{font-size:15px}.elementor-widget-heading .elementor-heading-title.elementor-size-medium{font-size:19px}.elementor-widget-heading .elementor-heading-title.elementor-size-large{font-size:29px}.elementor-widget-heading .elementor-heading-title.elementor-size-xl{font-size:39px}.elementor-widget-heading .elementor-heading-title.elementor-size-xxl{font-size:59px}<\/style><h2 class=\"elementor-heading-title elementor-size-default\">Les bases de donn\u00e9es SQL comptent g\u00e9n\u00e9ralement plusieurs centaines, voire plusieurs milliers de lignes. Mais bien souvent, les modifications, s\u00e9lections, mises \u00e0 jour et autres instructions ne concernent que quelques lignes. Pour savoir pr\u00e9cis\u00e9ment combien de lignes ont \u00e9t\u00e9 affect\u00e9es par vos diff\u00e9rentes op\u00e9rations, il est possible d\u2019utiliser SQL ROWCOUNT. D\u00e9cryptage. <\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-ea1f0d1 e-flex e-con-boxed e-con\" data-id=\"ea1f0d1\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-02b7ffd elementor-widget elementor-widget-heading\" data-id=\"02b7ffd\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">SQL ROWCOUNT pour compter les lignes<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-0048c9a elementor-widget elementor-widget-text-editor\" data-id=\"0048c9a\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-widget-text-editor.elementor-drop-cap-view-stacked .elementor-drop-cap{background-color:#69727d;color:#fff}.elementor-widget-text-editor.elementor-drop-cap-view-framed .elementor-drop-cap{color:#69727d;border:3px solid;background-color:transparent}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap{margin-top:8px}.elementor-widget-text-editor:not(.elementor-drop-cap-view-default) .elementor-drop-cap-letter{width:1em;height:1em}.elementor-widget-text-editor .elementor-drop-cap{float:left;text-align:center;line-height:1;font-size:50px}.elementor-widget-text-editor .elementor-drop-cap-letter{display:inline-block}<\/style>\t\t\t\t<p><span style=\"font-weight: 400;\">@ROWCOUNT est une requ\u00eate SQL destin\u00e9e \u00e0 <\/span><b>renvoyer le nombre de lignes affect\u00e9es par la derni\u00e8re instruction ex\u00e9cut\u00e9e<\/b><span style=\"font-weight: 400;\">. Il peut alors s\u2019agir de n\u2019importe quelle <a href=\"https:\/\/datascientest.com\/cinq-requetes-sql-a-connaitre\">instruction SQL<\/a>, comme INSERT, UPDATE, DELETE, SELECT&#8230;<\/span><\/p><p><span style=\"font-weight: 400;\">Pour que SQL ROWCOUNT fonctionne correctement, il faut imp\u00e9rativement que<\/span><b> les deux requ\u00eates<\/b><span style=\"font-weight: 400;\"> (ROWCOUNT et l\u2019instruction affectant les lignes)<\/span><b> soient dans la m\u00eame ex\u00e9cution.<\/b><span style=\"font-weight: 400;\"> Si elles sont ex\u00e9cut\u00e9es s\u00e9par\u00e9ment, la valeur renvoy\u00e9e sera 1 ; ce qui ne correspond pas au nombre de lignes affect\u00e9es par l\u2019instruction ex\u00e9cut\u00e9e pr\u00e9c\u00e9demment.\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">L\u2019objectif de @@ROWCOUNT est d\u2019<\/span><b>\u00e9viter les boucles infinies<\/b><span style=\"font-weight: 400;\"> lorsqu\u2019une <a href=\"https:\/\/datascientest.com\/base-de-donnees-definition\">base de donn\u00e9es<\/a> est analys\u00e9e en boucle. Ainsi, lorsque toutes les lignes ont \u00e9t\u00e9 trait\u00e9es, le processus d\u2019analyse s&rsquo;arr\u00eate automatiquement gr\u00e2ce \u00e0 SQL ROWCOUNT.\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">Outre le traitement des donn\u00e9es en boucle, cette requ\u00eate permet aussi de v\u00e9rifier le nombre de lignes affect\u00e9es dans une instruction. Ce faisant, ROWCOUNT<\/span><b> facilite la gestion des \u00e9ventuelles erreurs.<\/b><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-ab25c35 elementor-widget elementor-widget-image\" data-id=\"ab25c35\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<style>\/*! elementor - v3.15.0 - 02-08-2023 *\/\n.elementor-widget-image{text-align:center}.elementor-widget-image a{display:inline-block}.elementor-widget-image a img[src$=\".svg\"]{width:48px}.elementor-widget-image img{vertical-align:middle;display:inline-block}<\/style>\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"900\" height=\"500\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/10\/ROWCOUNT_SQL1.jpg\" class=\"attachment-full size-full wp-image-216711\" alt=\"\" loading=\"lazy\" srcset=\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/10\/ROWCOUNT_SQL1.jpg 900w, https:\/\/datascientest.com\/wp-content\/uploads\/2023\/10\/ROWCOUNT_SQL1-300x167.jpg 300w, https:\/\/datascientest.com\/wp-content\/uploads\/2023\/10\/ROWCOUNT_SQL1-768x427.jpg 768w\" sizes=\"(max-width: 900px) 100vw, 900px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-347c2dc elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"347c2dc\" data-element_type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-button-wrapper\">\n\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-sm elementor-animation-grow\" href=\"https:\/\/datascientest.com\/formation-sql\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t<span class=\"elementor-button-text\">Apprendre \u00e0 utiliser SQL ROWCOUNT<\/span>\n\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-701bc9a e-flex e-con-boxed e-con\" data-id=\"701bc9a\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-840b2c9 elementor-widget elementor-widget-heading\" data-id=\"840b2c9\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">5 exemples d\u2019utilisation de SQL ROWCOUNT<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-0038c29 elementor-widget elementor-widget-text-editor\" data-id=\"0038c29\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">SQL ROWCOUNT peut s\u2019ex\u00e9cuter avec tous types d&rsquo;instructions. Afin de vous aider \u00e0 mieux comprendre, voici quelques exemples. <\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-9d52e22 elementor-widget elementor-widget-heading\" data-id=\"9d52e22\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-medium\">ROWCOUNT et SELECT<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-4e0527a elementor-widget elementor-widget-text-editor\" data-id=\"4e0527a\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">L\u2019utilisation simultan\u00e9e de SQL ROWCOUNT et SELECT permet d\u2019identifier le nombre de lignes s\u00e9lectionn\u00e9es par la requ\u00eate initiale.\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">Voici comment cela se manifeste :\u00a0<\/span><\/p><pre style=\"padding-left: 40px;\"><b>SELECT TOP (100)<\/b><br \/><br \/><b>FROM [nom_de_table]<\/b><br \/><br \/><b>SELECT @@ROWCOUNT<\/b><\/pre><p><span style=\"font-weight: 400;\">Le nombre de lignes affect\u00e9es par la requ\u00eate SELECT appara\u00eetra alors en bas de la table.\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">Il est aussi possible d&rsquo;appeler @@ROWCOUNT apr\u00e8s avoir ex\u00e9cut\u00e9 deux commandes SELECT au cours d\u2019une m\u00eame op\u00e9ration.\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">Par exemple :\u00a0<\/span><\/p><pre style=\"padding-left: 40px;\"><b>SELECT TOP (100)<\/b><br \/><br \/><b>FROM [nom_de_table_1]<\/b><br \/><br \/><b>SELECT top 100<\/b><br \/><br \/><b>FROM [nom_de_table_1] -\u00a0 [nom_de_table_2]<\/b><\/pre><p><span style=\"font-weight: 400;\">Dans ce cas, la requ\u00eate SQL ROWCOUNT ne prend en consid\u00e9ration que la deuxi\u00e8me instruction.<\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-7c817ca elementor-widget elementor-widget-heading\" data-id=\"7c817ca\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-medium\">ROWCOUNT et UPDATE<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-8487b94 elementor-widget elementor-widget-text-editor\" data-id=\"8487b94\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">En appelant SQL ROWCOUNT apr\u00e8s l&rsquo;utilisation d\u2019une<\/span><a href=\"https:\/\/datascientest.com\/update-sql-tout-savoir\"><span style=\"font-weight: 400;\"> requ\u00eate UPDATE<\/span><\/a><span style=\"font-weight: 400;\">, vous pourrez identifier le nombre de lignes mises \u00e0 jour au cours de cette op\u00e9ration.\u00a0\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">Voici comment cette combinaison se pr\u00e9sente :\u00a0<\/span><\/p><pre style=\"padding-left: 40px;\"><b>UPDATE [nom_de_table]<\/b><br \/><br \/><b>SET [nom_de_colonne] = 'nouvelle valeur'<\/b><br \/><br \/><b>WHERE condition<\/b><br \/><br \/><b>SELECT @@ROWCOUNT<\/b><\/pre><p><span style=\"font-weight: 400;\">L\u00e0 encore, le nombre de lignes actualis\u00e9es appara\u00eet en dessous de la table. <\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-10a3def elementor-widget elementor-widget-image\" data-id=\"10a3def\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"900\" height=\"500\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/10\/ROWCOUNT_SQL2.jpg\" class=\"attachment-full size-full wp-image-216715\" alt=\"\" loading=\"lazy\" srcset=\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/10\/ROWCOUNT_SQL2.jpg 900w, https:\/\/datascientest.com\/wp-content\/uploads\/2023\/10\/ROWCOUNT_SQL2-300x167.jpg 300w, https:\/\/datascientest.com\/wp-content\/uploads\/2023\/10\/ROWCOUNT_SQL2-768x427.jpg 768w\" sizes=\"(max-width: 900px) 100vw, 900px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-e86043d elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"e86043d\" data-element_type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-button-wrapper\">\n\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-sm elementor-animation-grow\" href=\"https:\/\/datascientest.com\/formation-sql\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t<span class=\"elementor-button-text\">Ma\u00eetriser SQL ROWCOUNT<\/span>\n\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-ac4181a elementor-widget elementor-widget-heading\" data-id=\"ac4181a\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-medium\">ROWCOUNT et DELETE<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-6bbefc1 elementor-widget elementor-widget-text-editor\" data-id=\"6bbefc1\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">La combinaison de ROWCOUNT et DELETE permet d\u2019identifier le nombre de lignes supprim\u00e9es.\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">La syntaxe est la suivante :\u00a0<\/span><\/p><pre style=\"padding-left: 40px;\"><b>DELETE [nom_de_table]<\/b><br \/><br \/><b>WHERE condition<\/b><br \/><br \/><b>SELECT @@ROWCOUNT<\/b><\/pre>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-9dba27c elementor-widget elementor-widget-heading\" data-id=\"9dba27c\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-medium\">ROWCOUNT et INSERT<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-8c03b15 elementor-widget elementor-widget-text-editor\" data-id=\"8c03b15\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">Avec la <a href=\"https:\/\/datascientest.com\/insert-into-sql-tout-savoir\">requ\u00eate INSERT<\/a>, la commande SQL ROWCOUNT indique le nombre de lignes ajout\u00e9es.\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">Voici la syntaxe de base :\u00a0<\/span><\/p><pre style=\"padding-left: 40px;\"><b>INSERT INTO table\u00a0<\/b>\n\n<b>VALUES ('valeur 1', 'valeur 2', ...)<\/b>\n\n<b>SELECT @@ROWCOUNT<\/b><\/pre><p><span style=\"font-weight: 400;\">Il est aussi possible d\u2019ex\u00e9cuter des requ\u00eates par lot en ajoutant la commande GO.\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">Par exemple :\u00a0<\/span><\/p><pre style=\"padding-left: 40px;\"><b>INSERT INTO table\u00a0<\/b><br \/><br \/><b>VALUES ('valeur 1', 'valeur 2', 'valeur 3')<\/b><br \/><br \/><b>GO 10<\/b><br \/><br \/><b>SELECT @@ROWCOUNT<\/b><\/pre><p><span style=\"font-weight: 400;\">Lorsqu\u2019il y a plusieurs requ\u00eates simultan\u00e9es dans une m\u00eame op\u00e9ration, SQL ROWCOUNT ne prend en compte que la derni\u00e8re requ\u00eate. Dans cet exemple, m\u00eame si la requ\u00eate INSERT est r\u00e9p\u00e9t\u00e9e 10 fois, la commande ROWCOUNT ne fera appara\u00eetre que 3 modifications, puisque c\u2019est le nombre de valeurs modifi\u00e9es par la derni\u00e8re requ\u00eate.<\/span><\/p><p><span style=\"font-weight: 400;\">Cette r\u00e8gle vaut pour toutes les instructions qu\u2019il s\u2019agisse de INSERT. SELECT, UPDATE, DELETE, etc.\u00a0 <\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-0642db6 elementor-widget elementor-widget-heading\" data-id=\"0642db6\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h4 class=\"elementor-heading-title elementor-size-medium\">ROWCOUNT et IF<\/h4>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-457c85e elementor-widget elementor-widget-text-editor\" data-id=\"457c85e\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">SQL ROWCOUNT peut aussi \u00eatre utilis\u00e9 avec IF pour contr\u00f4ler le flux de l&rsquo;instruction. En fonction du nombre de lignes affect\u00e9es, il sera possible d\u2019ajouter un message sp\u00e9cifique.\u00a0<\/span><\/p><p><span style=\"font-weight: 400;\">Par exemple :\u00a0<\/span><\/p><pre style=\"padding-left: 40px;\"><b>SELECT TOP (100)<\/b><br \/><br \/><b>FROM [nom_de_table]<\/b><br \/><br \/><b>IF @@ROWCOUNT &gt; 10\u00a0<\/b><br \/><br \/><b>PRINT \u201cmessage_1\u201d<\/b><br \/><br \/><b>ELSE<\/b><br \/><br \/><b>PRINT \u201cmessage_2\u201d.\u00a0<\/b><\/pre><p><span style=\"font-weight: 400;\">Dans cet exemple, cela signifie : s\u00e9lectionnez le top 100 de [nom_de_table]. Si le nombre de lignes est sup\u00e9rieur \u00e0 10, \u00e9crivez le message_1, sinon, \u00e9crivez le message_2. En l\u2019occurrence, comme il s\u2019agit de s\u00e9lectionner un top 100, le nombre de lignes sera effectivement sup\u00e9rieur \u00e0 10. C\u2019est donc le message_1 qui appara\u00eetra.<\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-08faf43 e-flex e-con-boxed e-con\" data-id=\"08faf43\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t<div class=\"elementor-element elementor-element-3eed80f elementor-widget elementor-widget-heading\" data-id=\"3eed80f\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h3 class=\"elementor-heading-title elementor-size-default\">Rejoignez DataScientest pour ma\u00eetriser le langage SQL<\/h3>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-f1ba77b elementor-widget elementor-widget-text-editor\" data-id=\"f1ba77b\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t<p><span style=\"font-weight: 400;\">SQL ROWCOUNT n\u2019est qu\u2019une requ\u00eate parmi les nombreuses possibilit\u00e9s du <a href=\"https:\/\/datascientest.com\/sql-tout-savoir\">langage SQL<\/a>. Il y a aussi les mises \u00e0 jour, les suppressions, les ajouts, les conditions, les d\u00e9clencheurs\u2026<\/span><\/p><p><span style=\"font-weight: 400;\">Or, ma\u00eetriser ce langage figure parmi les comp\u00e9tences fondamentales de tout professionnel qui doit apprendre \u00e0 <strong>manipuler les bases de donn\u00e9es relationnelles avec fluidit\u00e9<\/strong>. Pour cela, il convient de m\u00ealer th\u00e9orie (pour conna\u00eetre toutes les requ\u00eates disponibles) et pratiques (pour les appliquer au cas par cas). C\u2019est justement ce que nous proposons chez DataScientest avec nos nombreuses formations autour de la donn\u00e9e. <strong>D\u00e9couvrez-les !<\/strong><\/span><\/p>\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-008d138 elementor-widget elementor-widget-image\" data-id=\"008d138\" data-element_type=\"widget\" data-widget_type=\"image.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<img decoding=\"async\" width=\"900\" height=\"500\" src=\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/10\/ROWCOUNT_SQL3.jpg\" class=\"attachment-full size-full wp-image-216719\" alt=\"\" loading=\"lazy\" srcset=\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/10\/ROWCOUNT_SQL3.jpg 900w, https:\/\/datascientest.com\/wp-content\/uploads\/2023\/10\/ROWCOUNT_SQL3-300x167.jpg 300w, https:\/\/datascientest.com\/wp-content\/uploads\/2023\/10\/ROWCOUNT_SQL3-768x427.jpg 768w\" sizes=\"(max-width: 900px) 100vw, 900px\" \/>\t\t\t\t\t\t\t\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-4952023 elementor-align-center button-principale elementor-widget elementor-widget-button\" data-id=\"4952023\" data-element_type=\"widget\" data-widget_type=\"button.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t<div class=\"elementor-button-wrapper\">\n\t\t\t<a class=\"elementor-button elementor-button-link elementor-size-sm elementor-animation-grow\" href=\"https:\/\/datascientest.com\/formation-sql\">\n\t\t\t\t\t\t<span class=\"elementor-button-content-wrapper\">\n\t\t\t\t\t\t<span class=\"elementor-button-text\">D\u00e9couvrir notre formation SQL <\/span>\n\t\t<\/span>\n\t\t\t\t\t<\/a>\n\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t<div class=\"elementor-element elementor-element-282403a e-flex e-con-boxed e-con\" data-id=\"282403a\" data-element_type=\"container\" data-settings=\"{&quot;content_width&quot;:&quot;boxed&quot;}\">\n\t\t\t\t\t<div class=\"e-con-inner\">\n\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>Les bases de donn\u00e9es SQL comptent g\u00e9n\u00e9ralement plusieurs centaines, voire plusieurs milliers de lignes. Mais bien souvent, les modifications, s\u00e9lections, mises \u00e0 jour et autres instructions ne concernent que quelques lignes. Pour savoir pr\u00e9cis\u00e9ment combien de lignes ont \u00e9t\u00e9 affect\u00e9es par vos diff\u00e9rentes op\u00e9rations, il est possible d\u2019utiliser SQL ROWCOUNT. D\u00e9cryptage. SQL ROWCOUNT pour compter [&hellip;]<\/p>\n","protected":false},"author":77,"featured_media":216673,"comment_status":"open","ping_status":"open","sticky":false,"template":"elementor_theme","format":"standard","meta":{"content-type":"","inline_featured_image":false},"categories":[2497],"tags":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.7 (Yoast SEO v21.7) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>SQL ROWCOUNT : Tout savoir sur les formules SQL<\/title>\n<meta name=\"description\" content=\"SQL ROWCOUNT permet de compter les lignes affect\u00e9es par vos diff\u00e9rentes requ\u00eates. Mode d\u2019emploi.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/datascientest.com\/sql-rowcount-tout-savoir\" \/>\n<meta property=\"og:locale\" content=\"fr_FR\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQL ROWCOUNT : Tout savoir sur les formules SQL\" \/>\n<meta property=\"og:url\" content=\"https:\/\/datascientest.com\/sql-rowcount-tout-savoir\" \/>\n<meta property=\"og:site_name\" content=\"Formation Data Science | DataScientest.com\" \/>\n<meta property=\"article:published_time\" content=\"2023-11-08T06:30:00+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-11-09T13:40:31+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/10\/Illu_BLOG__ROWCOUNT_SQL.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1024\" \/>\n\t<meta property=\"og:image:height\" content=\"563\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Raphael Kassel\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u00c9crit par\" \/>\n\t<meta name=\"twitter:data1\" content=\"Raphael Kassel\" \/>\n\t<meta name=\"twitter:label2\" content=\"Dur\u00e9e de lecture estim\u00e9e\" \/>\n\t<meta name=\"twitter:data2\" content=\"5 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/datascientest.com\/sql-rowcount-tout-savoir\",\"url\":\"https:\/\/datascientest.com\/sql-rowcount-tout-savoir\",\"name\":\"SQL ROWCOUNT : Tout savoir sur les formules SQL\",\"isPartOf\":{\"@id\":\"https:\/\/datascientest.com\/#website\"},\"datePublished\":\"2023-11-08T06:30:00+00:00\",\"dateModified\":\"2023-11-09T13:40:31+00:00\",\"author\":{\"@id\":\"https:\/\/datascientest.com\/#\/schema\/person\/6eca16f63daaafcbc96e15549b9d4ee1\"},\"description\":\"SQL ROWCOUNT permet de compter les lignes affect\u00e9es par vos diff\u00e9rentes requ\u00eates. Mode d\u2019emploi.\",\"inLanguage\":\"fr-FR\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/datascientest.com\/sql-rowcount-tout-savoir\"]}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/datascientest.com\/#website\",\"url\":\"https:\/\/datascientest.com\/\",\"name\":\"Formation Data Science | DataScientest.com\",\"description\":\"Leader de la formation en Data Science\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/datascientest.com\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"fr-FR\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/datascientest.com\/#\/schema\/person\/6eca16f63daaafcbc96e15549b9d4ee1\",\"name\":\"Raphael Kassel\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"fr-FR\",\"@id\":\"https:\/\/datascientest.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/raph.jpeg\",\"contentUrl\":\"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/raph.jpeg\",\"caption\":\"Raphael Kassel\"},\"description\":\"Raphael Kassel est le Head of Data Programs chez DataScientest. Il supervise une \u00e9quipe Data, impl\u00e9mente de nouveaux parcours comme \\\"Chef de projet IA\\\" et \\\"Data Product Manager\\\", et contribue \u00e0 la modernisation des op\u00e9rations du groupe. En collaboration \u00e9troite avec l'\u00e9quipe de d\u00e9veloppement, il adapte l'accompagnement acad\u00e9mique aux \u00e9volutions de l'\u00e9quipe data et \u00e0 l'internationalisation.\",\"sameAs\":[\"https:\/\/www.linkedin.com\/in\/raphaelkassel\/\",\"Data Science\"],\"url\":\"https:\/\/datascientest.com\/author\/raphaelkassel\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"SQL ROWCOUNT : Tout savoir sur les formules SQL","description":"SQL ROWCOUNT permet de compter les lignes affect\u00e9es par vos diff\u00e9rentes requ\u00eates. Mode d\u2019emploi.","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:\/\/datascientest.com\/sql-rowcount-tout-savoir","og_locale":"fr_FR","og_type":"article","og_title":"SQL ROWCOUNT : Tout savoir sur les formules SQL","og_url":"https:\/\/datascientest.com\/sql-rowcount-tout-savoir","og_site_name":"Formation Data Science | DataScientest.com","article_published_time":"2023-11-08T06:30:00+00:00","article_modified_time":"2023-11-09T13:40:31+00:00","og_image":[{"width":1024,"height":563,"url":"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/10\/Illu_BLOG__ROWCOUNT_SQL.png","type":"image\/png"}],"author":"Raphael Kassel","twitter_card":"summary_large_image","twitter_misc":{"\u00c9crit par":"Raphael Kassel","Dur\u00e9e de lecture estim\u00e9e":"5 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/datascientest.com\/sql-rowcount-tout-savoir","url":"https:\/\/datascientest.com\/sql-rowcount-tout-savoir","name":"SQL ROWCOUNT : Tout savoir sur les formules SQL","isPartOf":{"@id":"https:\/\/datascientest.com\/#website"},"datePublished":"2023-11-08T06:30:00+00:00","dateModified":"2023-11-09T13:40:31+00:00","author":{"@id":"https:\/\/datascientest.com\/#\/schema\/person\/6eca16f63daaafcbc96e15549b9d4ee1"},"description":"SQL ROWCOUNT permet de compter les lignes affect\u00e9es par vos diff\u00e9rentes requ\u00eates. Mode d\u2019emploi.","inLanguage":"fr-FR","potentialAction":[{"@type":"ReadAction","target":["https:\/\/datascientest.com\/sql-rowcount-tout-savoir"]}]},{"@type":"WebSite","@id":"https:\/\/datascientest.com\/#website","url":"https:\/\/datascientest.com\/","name":"Formation Data Science | DataScientest.com","description":"Leader de la formation en Data Science","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/datascientest.com\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"fr-FR"},{"@type":"Person","@id":"https:\/\/datascientest.com\/#\/schema\/person\/6eca16f63daaafcbc96e15549b9d4ee1","name":"Raphael Kassel","image":{"@type":"ImageObject","inLanguage":"fr-FR","@id":"https:\/\/datascientest.com\/#\/schema\/person\/image\/","url":"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/raph.jpeg","contentUrl":"https:\/\/datascientest.com\/wp-content\/uploads\/2023\/11\/raph.jpeg","caption":"Raphael Kassel"},"description":"Raphael Kassel est le Head of Data Programs chez DataScientest. Il supervise une \u00e9quipe Data, impl\u00e9mente de nouveaux parcours comme \"Chef de projet IA\" et \"Data Product Manager\", et contribue \u00e0 la modernisation des op\u00e9rations du groupe. En collaboration \u00e9troite avec l'\u00e9quipe de d\u00e9veloppement, il adapte l'accompagnement acad\u00e9mique aux \u00e9volutions de l'\u00e9quipe data et \u00e0 l'internationalisation.","sameAs":["https:\/\/www.linkedin.com\/in\/raphaelkassel\/","Data Science"],"url":"https:\/\/datascientest.com\/author\/raphaelkassel"}]}},"_links":{"self":[{"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/posts\/216670"}],"collection":[{"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/users\/77"}],"replies":[{"embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/comments?post=216670"}],"version-history":[{"count":0,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/posts\/216670\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/media\/216673"}],"wp:attachment":[{"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/media?parent=216670"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/categories?post=216670"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/datascientest.com\/wp-json\/wp\/v2\/tags?post=216670"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}