{"id":24866,"date":"2024-03-16T03:59:55","date_gmt":"2024-03-16T03:59:55","guid":{"rendered":"https:\/\/www.silicloud.com\/blog\/the-usage-of-rowcount-and-rowcount-in-sql-server\/"},"modified":"2024-03-22T04:47:06","modified_gmt":"2024-03-22T04:47:06","slug":"the-usage-of-rowcount-and-rowcount-in-sql-server","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/blog\/the-usage-of-rowcount-and-rowcount-in-sql-server\/","title":{"rendered":"The usage of Rowcount and @@Rowcount in SQL Server."},"content":{"rendered":"

In SQL Server, ROWCOUNT and @@ROWCOUNT are two different concepts and functions.<\/p>\n

    \n
  1. ROWCOUNT is a system variable in SQL Server that stores the number of rows affected by the last executed statement. It can be set using the SET ROWCOUNT statement or retrieved by querying the system variable. Here is an example of how ROWCOUNT is used:<\/li>\n
  2. Set the value of ROWCOUNT to 10: SET ROWCOUNT 10; – Set ROWCOUNT as 10.<\/li>\n
  3. Check the value of ROWCOUNT: SELECT @@ROWCOUNT; – Retrieve the number of rows affected by the last executed statement.<\/li>\n
  4. ROWCOUNT is mainly used to restrict or control the number of rows returned in a query. By setting the value of ROWCOUNT, only the specified number of rows will be returned when executing the query.<\/li>\n
  5. @@ROWCOUNT is a system function that returns the number of rows affected by the last executed statement. It is mainly used to determine the number of rows affected after executing a SQL statement. Here is an example of how to use @@ROWCOUNT:<\/li>\n
  6. Retrieve the value of @@ROWCOUNT: SELECT @@ROWCOUNT; – Obtain the number of rows affected by the last executed statement.<\/li>\n
  7. @@ROWCOUNT can be used to determine the number of rows affected after the execution of the previous SQL statement, and based on the returned number of rows, appropriate processing logic can be applied.<\/li>\n<\/ol>\n

    It’s important to note that there is a difference between the values of ROWCOUNT and @@ROWCOUNT. ROWCOUNT is a variable that stores the number of rows affected by the last executed statement, while @@ROWCOUNT is a function that returns the number of rows affected by the last executed statement.<\/p>\n","protected":false},"excerpt":{"rendered":"

    In SQL Server, ROWCOUNT and @@ROWCOUNT are two different concepts and functions. ROWCOUNT is a system variable in SQL Server that stores the number of rows affected by the last executed statement. It can be set using the SET ROWCOUNT statement or retrieved by querying the system variable. Here is an example of how ROWCOUNT […]<\/p>\n","protected":false},"author":13,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_import_markdown_pro_load_document_selector":0,"_import_markdown_pro_submit_text_textarea":"","footnotes":""},"categories":[1],"tags":[],"class_list":["post-24866","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"yoast_head":"\nThe usage of Rowcount and @@Rowcount in SQL Server. - Blog - Silicon Cloud<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.silicloud.com\/blog\/the-usage-of-rowcount-and-rowcount-in-sql-server\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"The usage of Rowcount and @@Rowcount in SQL Server.\" \/>\n<meta property=\"og:description\" content=\"In SQL Server, ROWCOUNT and @@ROWCOUNT are two different concepts and functions. ROWCOUNT is a system variable in SQL Server that stores the number of rows affected by the last executed statement. It can be set using the SET ROWCOUNT statement or retrieved by querying the system variable. Here is an example of how ROWCOUNT […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/blog\/the-usage-of-rowcount-and-rowcount-in-sql-server\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog - Silicon Cloud\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/SiliCloudGlobal\/\" \/>\n<meta property=\"article:published_time\" content=\"2024-03-16T03:59:55+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-22T04:47:06+00:00\" \/>\n<meta name=\"author\" content=\"Isabella Edwards\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SiliCloudGlobal\" \/>\n<meta name=\"twitter:site\" content=\"@SiliCloudGlobal\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Isabella Edwards\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/the-usage-of-rowcount-and-rowcount-in-sql-server\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/the-usage-of-rowcount-and-rowcount-in-sql-server\/\"},\"author\":{\"name\":\"Isabella Edwards\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/5579144e23c225c8188167f3e3f888dd\"},\"headline\":\"The usage of Rowcount and @@Rowcount in SQL Server.\",\"datePublished\":\"2024-03-16T03:59:55+00:00\",\"dateModified\":\"2024-03-22T04:47:06+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/the-usage-of-rowcount-and-rowcount-in-sql-server\/\"},\"wordCount\":276,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/the-usage-of-rowcount-and-rowcount-in-sql-server\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/the-usage-of-rowcount-and-rowcount-in-sql-server\/\",\"name\":\"The usage of Rowcount and @@Rowcount in SQL Server. - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\"},\"datePublished\":\"2024-03-16T03:59:55+00:00\",\"dateModified\":\"2024-03-22T04:47:06+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/the-usage-of-rowcount-and-rowcount-in-sql-server\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/blog\/the-usage-of-rowcount-and-rowcount-in-sql-server\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/the-usage-of-rowcount-and-rowcount-in-sql-server\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.silicloud.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"The usage of Rowcount and @@Rowcount in SQL Server.\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\",\"url\":\"https:\/\/www.silicloud.com\/blog\/\",\"name\":\"Silicon Cloud Blog\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\",\"name\":\"Silicon Cloud Blog\",\"url\":\"https:\/\/www.silicloud.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png\",\"contentUrl\":\"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png\",\"width\":1024,\"height\":1024,\"caption\":\"Silicon Cloud Blog\"},\"image\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/SiliCloudGlobal\/\",\"https:\/\/twitter.com\/SiliCloudGlobal\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/5579144e23c225c8188167f3e3f888dd\",\"name\":\"Isabella Edwards\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/d4d4dec47f553ac7961d9fa4cc9bdcdcf5b7ce5106594330b6d25c5694fdbaec?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/d4d4dec47f553ac7961d9fa4cc9bdcdcf5b7ce5106594330b6d25c5694fdbaec?s=96&d=mm&r=g\",\"caption\":\"Isabella Edwards\"},\"url\":\"https:\/\/www.silicloud.com\/blog\/author\/isabellaedwards\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"The usage of Rowcount and @@Rowcount in SQL Server. - Blog - Silicon Cloud","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:\/\/www.silicloud.com\/blog\/the-usage-of-rowcount-and-rowcount-in-sql-server\/","og_locale":"en_US","og_type":"article","og_title":"The usage of Rowcount and @@Rowcount in SQL Server.","og_description":"In SQL Server, ROWCOUNT and @@ROWCOUNT are two different concepts and functions. ROWCOUNT is a system variable in SQL Server that stores the number of rows affected by the last executed statement. It can be set using the SET ROWCOUNT statement or retrieved by querying the system variable. Here is an example of how ROWCOUNT […]","og_url":"https:\/\/www.silicloud.com\/blog\/the-usage-of-rowcount-and-rowcount-in-sql-server\/","og_site_name":"Blog - Silicon Cloud","article_publisher":"https:\/\/www.facebook.com\/SiliCloudGlobal\/","article_published_time":"2024-03-16T03:59:55+00:00","article_modified_time":"2024-03-22T04:47:06+00:00","author":"Isabella Edwards","twitter_card":"summary_large_image","twitter_creator":"@SiliCloudGlobal","twitter_site":"@SiliCloudGlobal","twitter_misc":{"Written by":"Isabella Edwards","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.silicloud.com\/blog\/the-usage-of-rowcount-and-rowcount-in-sql-server\/#article","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/the-usage-of-rowcount-and-rowcount-in-sql-server\/"},"author":{"name":"Isabella Edwards","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/5579144e23c225c8188167f3e3f888dd"},"headline":"The usage of Rowcount and @@Rowcount in SQL Server.","datePublished":"2024-03-16T03:59:55+00:00","dateModified":"2024-03-22T04:47:06+00:00","mainEntityOfPage":{"@id":"https:\/\/www.silicloud.com\/blog\/the-usage-of-rowcount-and-rowcount-in-sql-server\/"},"wordCount":276,"commentCount":0,"publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/blog\/the-usage-of-rowcount-and-rowcount-in-sql-server\/","url":"https:\/\/www.silicloud.com\/blog\/the-usage-of-rowcount-and-rowcount-in-sql-server\/","name":"The usage of Rowcount and @@Rowcount in SQL Server. - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/#website"},"datePublished":"2024-03-16T03:59:55+00:00","dateModified":"2024-03-22T04:47:06+00:00","breadcrumb":{"@id":"https:\/\/www.silicloud.com\/blog\/the-usage-of-rowcount-and-rowcount-in-sql-server\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/blog\/the-usage-of-rowcount-and-rowcount-in-sql-server\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/blog\/the-usage-of-rowcount-and-rowcount-in-sql-server\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.silicloud.com\/blog\/"},{"@type":"ListItem","position":2,"name":"The usage of Rowcount and @@Rowcount in SQL Server."}]},{"@type":"WebSite","@id":"https:\/\/www.silicloud.com\/blog\/#website","url":"https:\/\/www.silicloud.com\/blog\/","name":"Silicon Cloud Blog","description":"","publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.silicloud.com\/blog\/#organization","name":"Silicon Cloud Blog","url":"https:\/\/www.silicloud.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png","contentUrl":"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png","width":1024,"height":1024,"caption":"Silicon Cloud Blog"},"image":{"@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/SiliCloudGlobal\/","https:\/\/twitter.com\/SiliCloudGlobal"]},{"@type":"Person","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/5579144e23c225c8188167f3e3f888dd","name":"Isabella Edwards","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/d4d4dec47f553ac7961d9fa4cc9bdcdcf5b7ce5106594330b6d25c5694fdbaec?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/d4d4dec47f553ac7961d9fa4cc9bdcdcf5b7ce5106594330b6d25c5694fdbaec?s=96&d=mm&r=g","caption":"Isabella Edwards"},"url":"https:\/\/www.silicloud.com\/blog\/author\/isabellaedwards\/"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/24866","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/users\/13"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/comments?post=24866"}],"version-history":[{"count":1,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/24866\/revisions"}],"predecessor-version":[{"id":58927,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/24866\/revisions\/58927"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/media?parent=24866"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/categories?post=24866"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/tags?post=24866"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}