{"id":11260,"date":"2019-04-02T10:49:55","date_gmt":"2019-04-02T10:49:55","guid":{"rendered":"https:\/\/dbtut.com\/?p=11260"},"modified":"2019-04-02T10:49:55","modified_gmt":"2019-04-02T10:49:55","slug":"arithmetic-overflow-error-converting-expression-to-data-type-int-error-when-using-sum-function","status":"publish","type":"post","link":"https:\/\/dbtut.com\/index.php\/2019\/04\/02\/arithmetic-overflow-error-converting-expression-to-data-type-int-error-when-using-sum-function\/","title":{"rendered":"&#8220;Arithmetic overflow error converting expression to data type int.&#8221; Error When Using SUM Function"},"content":{"rendered":"<p>You can receive this error when you want to get a total result by using the SUM function. In order to avoid this error, you must convert the column in the SUM function to bigint type using CAST. Let&#8217;s clarify the subject by making an example.<\/p>\n<p>Let&#8217;s create a table that has Name and Count columns and add a few records as follows. As you can see in the Script, the values we add to the Count column force the limits of the int data type.<\/p>\n<pre class=\"lang:default decode:true\">CREATE TABLE [dbo].[ConvertExample](\r\n\t[Name] [varchar](250) NULL,\r\n\t[Count] [int] NULL\r\n) ON [PRIMARY]\r\nINSERT INTO [dbo].[ConvertExample]  ([Name] ,[Count])   VALUES ('Nurullah CAKIR',2050512989)\r\nINSERT INTO [dbo].[ConvertExample]  ([Name] ,[Count])   VALUES ('Hakan GURBASLAR',2050512988)\r\nINSERT INTO [dbo].[ConvertExample]  ([Name] ,[Count])   VALUES ('Faruk ERDEM',2050512987)\r\nINSERT INTO [dbo].[ConvertExample]  ([Name] ,[Count])   VALUES ('Dilara AYDIN',2050512987)\r\n<\/pre>\n<p>When we sum count column with a query such as the following by using the SUM function, we will receive the error that is subject to our article because the total value will exceed the limit of the int type.<\/p>\n<pre class=\"lang:default decode:true \">SELECT SUM(Count) FROM [dbo].[ConvertExample]<\/pre>\n<p id=\"jXgXIMi\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-11262  aligncenter\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/04\/img_5ca33bcebd4b6.png\" alt=\"\" width=\"599\" height=\"161\" \/><\/p>\n<p>When we change the query as follows, you will see that we can get the sum we want without error.<\/p>\n<pre class=\"lang:default decode:true \">SELECT SUM(CAST(Count AS BIGINT)) AS COUNT_Column_Bigint FROM [dbo].[ConvertExample]<\/pre>\n<p id=\"JwBXhUY\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-11264  aligncenter\" src=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/04\/img_5ca33bf167aa8.png\" alt=\"\" width=\"712\" height=\"156\" \/><\/p>\n\n<p>&nbsp;<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_11260\" class=\"pvc_stats all  \" data-element-id=\"11260\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"excerpt":{"rendered":"<p>You can receive this error when you want to get a total result by using the SUM function. In order to avoid this error, you must convert the column in the SUM function to bigint type using CAST. Let&#8217;s clarify the subject by making an example. Let&#8217;s create a table that has Name and Count &hellip;<\/p>\n<div class=\"pvc_clear\"><\/div>\n<p id=\"pvc_stats_11260\" class=\"pvc_stats all  \" data-element-id=\"11260\" style=\"\"><i class=\"pvc-stats-icon medium\" aria-hidden=\"true\"><svg aria-hidden=\"true\" focusable=\"false\" data-prefix=\"far\" data-icon=\"chart-bar\" role=\"img\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" viewBox=\"0 0 512 512\" class=\"svg-inline--fa fa-chart-bar fa-w-16 fa-2x\"><path fill=\"currentColor\" d=\"M396.8 352h22.4c6.4 0 12.8-6.4 12.8-12.8V108.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v230.4c0 6.4 6.4 12.8 12.8 12.8zm-192 0h22.4c6.4 0 12.8-6.4 12.8-12.8V140.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v198.4c0 6.4 6.4 12.8 12.8 12.8zm96 0h22.4c6.4 0 12.8-6.4 12.8-12.8V204.8c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v134.4c0 6.4 6.4 12.8 12.8 12.8zM496 400H48V80c0-8.84-7.16-16-16-16H16C7.16 64 0 71.16 0 80v336c0 17.67 14.33 32 32 32h464c8.84 0 16-7.16 16-16v-16c0-8.84-7.16-16-16-16zm-387.2-48h22.4c6.4 0 12.8-6.4 12.8-12.8v-70.4c0-6.4-6.4-12.8-12.8-12.8h-22.4c-6.4 0-12.8 6.4-12.8 12.8v70.4c0 6.4 6.4 12.8 12.8 12.8z\" class=\"\"><\/path><\/svg><\/i> <img loading=\"lazy\" decoding=\"async\" width=\"16\" height=\"16\" alt=\"Loading\" src=\"https:\/\/dbtut.com\/wp-content\/plugins\/page-views-count\/ajax-loader-2x.gif\" border=0 \/><\/p>\n<div class=\"pvc_clear\"><\/div>\n","protected":false},"author":1,"featured_media":11265,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"om_disable_all_campaigns":false,"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"_uf_show_specific_survey":0,"_uf_disable_surveys":false,"footnotes":""},"categories":[3],"tags":[3031,3033,3027,3028,3030,3029,3032],"class_list":["post-11260","post","type-post","status-publish","format-standard","has-post-thumbnail","","category-mssql","tag-arithmetic-overflow-error-converting-expression-to-data-type-datetime","tag-arithmetic-overflow-error-converting-expression-to-data-type-float","tag-arithmetic-overflow-error-converting-expression-to-data-type-int","tag-arithmetic-overflow-error-converting-expression-to-data-type-int-count","tag-arithmetic-overflow-error-converting-expression-to-data-type-int-dateadd","tag-arithmetic-overflow-error-converting-expression-to-data-type-int-avg","tag-arithmetic-overflow-error-converting-expression-to-data-type-nvarchar"],"aioseo_notices":[],"a3_pvc":{"activated":true,"total_views":2541,"today_views":0},"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v24.9 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>&quot;Arithmetic overflow error converting expression to data type int.&quot; Error When Using SUM Function - Database Tutorials<\/title>\n<meta name=\"description\" content=\"&quot;Arithmetic overflow error converting expression to data type int.&quot; Error When Using SUM Function\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/dbtut.com\/index.php\/2019\/04\/02\/arithmetic-overflow-error-converting-expression-to-data-type-int-error-when-using-sum-function\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"&quot;Arithmetic overflow error converting expression to data type int.&quot; Error When Using SUM Function - Database Tutorials\" \/>\n<meta property=\"og:description\" content=\"&quot;Arithmetic overflow error converting expression to data type int.&quot; Error When Using SUM Function\" \/>\n<meta property=\"og:url\" content=\"https:\/\/dbtut.com\/index.php\/2019\/04\/02\/arithmetic-overflow-error-converting-expression-to-data-type-int-error-when-using-sum-function\/\" \/>\n<meta property=\"og:site_name\" content=\"Database Tutorials\" \/>\n<meta property=\"article:published_time\" content=\"2019-04-02T10:49:55+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/04\/Ads\u0131z-1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"541\" \/>\n\t<meta property=\"og:image:height\" content=\"345\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"dbtut\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"dbtut\" \/>\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:\/\/dbtut.com\/index.php\/2019\/04\/02\/arithmetic-overflow-error-converting-expression-to-data-type-int-error-when-using-sum-function\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/04\/02\/arithmetic-overflow-error-converting-expression-to-data-type-int-error-when-using-sum-function\/\"},\"author\":{\"name\":\"dbtut\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\"},\"headline\":\"&#8220;Arithmetic overflow error converting expression to data type int.&#8221; Error When Using SUM Function\",\"datePublished\":\"2019-04-02T10:49:55+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/04\/02\/arithmetic-overflow-error-converting-expression-to-data-type-int-error-when-using-sum-function\/\"},\"wordCount\":164,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/04\/02\/arithmetic-overflow-error-converting-expression-to-data-type-int-error-when-using-sum-function\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/04\/Ads\u0131z-1.png\",\"keywords\":[\"arithmetic overflow error converting expression to data type datetime\",\"arithmetic overflow error converting expression to data type float\",\"Arithmetic overflow error converting expression to data type int\",\"arithmetic overflow error converting expression to data type int count\",\"arithmetic overflow error converting expression to data type int dateadd\",\"arithmetic overflow error converting expression to data type int. avg\",\"arithmetic overflow error converting expression to data type nvarchar\"],\"articleSection\":[\"MSSQL\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/04\/02\/arithmetic-overflow-error-converting-expression-to-data-type-int-error-when-using-sum-function\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/04\/02\/arithmetic-overflow-error-converting-expression-to-data-type-int-error-when-using-sum-function\/\",\"url\":\"https:\/\/dbtut.com\/index.php\/2019\/04\/02\/arithmetic-overflow-error-converting-expression-to-data-type-int-error-when-using-sum-function\/\",\"name\":\"\\\"Arithmetic overflow error converting expression to data type int.\\\" Error When Using SUM Function - Database Tutorials\",\"isPartOf\":{\"@id\":\"https:\/\/dbtut.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/04\/02\/arithmetic-overflow-error-converting-expression-to-data-type-int-error-when-using-sum-function\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/04\/02\/arithmetic-overflow-error-converting-expression-to-data-type-int-error-when-using-sum-function\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/04\/Ads\u0131z-1.png\",\"datePublished\":\"2019-04-02T10:49:55+00:00\",\"description\":\"\\\"Arithmetic overflow error converting expression to data type int.\\\" Error When Using SUM Function\",\"breadcrumb\":{\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/04\/02\/arithmetic-overflow-error-converting-expression-to-data-type-int-error-when-using-sum-function\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/dbtut.com\/index.php\/2019\/04\/02\/arithmetic-overflow-error-converting-expression-to-data-type-int-error-when-using-sum-function\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/04\/02\/arithmetic-overflow-error-converting-expression-to-data-type-int-error-when-using-sum-function\/#primaryimage\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/04\/Ads\u0131z-1.png\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/04\/Ads\u0131z-1.png\",\"width\":541,\"height\":345},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/dbtut.com\/index.php\/2019\/04\/02\/arithmetic-overflow-error-converting-expression-to-data-type-int-error-when-using-sum-function\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/dbtut.com\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"&#8220;Arithmetic overflow error converting expression to data type int.&#8221; Error When Using SUM Function\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/dbtut.com\/#website\",\"url\":\"https:\/\/dbtut.com\/\",\"name\":\"Database Tutorials\",\"description\":\"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux\",\"publisher\":{\"@id\":\"https:\/\/dbtut.com\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/dbtut.com\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/dbtut.com\/#organization\",\"name\":\"dbtut\",\"url\":\"https:\/\/dbtut.com\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"contentUrl\":\"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg\",\"width\":223,\"height\":36,\"caption\":\"dbtut\"},\"image\":{\"@id\":\"https:\/\/dbtut.com\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408\",\"name\":\"dbtut\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/dbtut.com\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g\",\"caption\":\"dbtut\"},\"description\":\"We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.\",\"sameAs\":[\"http:\/\/NurullahCAKIR\"],\"url\":\"https:\/\/dbtut.com\/index.php\/author\/dbtut\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"\"Arithmetic overflow error converting expression to data type int.\" Error When Using SUM Function - Database Tutorials","description":"\"Arithmetic overflow error converting expression to data type int.\" Error When Using SUM Function","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:\/\/dbtut.com\/index.php\/2019\/04\/02\/arithmetic-overflow-error-converting-expression-to-data-type-int-error-when-using-sum-function\/","og_locale":"en_US","og_type":"article","og_title":"\"Arithmetic overflow error converting expression to data type int.\" Error When Using SUM Function - Database Tutorials","og_description":"\"Arithmetic overflow error converting expression to data type int.\" Error When Using SUM Function","og_url":"https:\/\/dbtut.com\/index.php\/2019\/04\/02\/arithmetic-overflow-error-converting-expression-to-data-type-int-error-when-using-sum-function\/","og_site_name":"Database Tutorials","article_published_time":"2019-04-02T10:49:55+00:00","og_image":[{"width":541,"height":345,"url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/04\/Ads\u0131z-1.png","type":"image\/png"}],"author":"dbtut","twitter_card":"summary_large_image","twitter_misc":{"Written by":"dbtut","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/dbtut.com\/index.php\/2019\/04\/02\/arithmetic-overflow-error-converting-expression-to-data-type-int-error-when-using-sum-function\/#article","isPartOf":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/04\/02\/arithmetic-overflow-error-converting-expression-to-data-type-int-error-when-using-sum-function\/"},"author":{"name":"dbtut","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408"},"headline":"&#8220;Arithmetic overflow error converting expression to data type int.&#8221; Error When Using SUM Function","datePublished":"2019-04-02T10:49:55+00:00","mainEntityOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/04\/02\/arithmetic-overflow-error-converting-expression-to-data-type-int-error-when-using-sum-function\/"},"wordCount":164,"commentCount":0,"publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/04\/02\/arithmetic-overflow-error-converting-expression-to-data-type-int-error-when-using-sum-function\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/04\/Ads\u0131z-1.png","keywords":["arithmetic overflow error converting expression to data type datetime","arithmetic overflow error converting expression to data type float","Arithmetic overflow error converting expression to data type int","arithmetic overflow error converting expression to data type int count","arithmetic overflow error converting expression to data type int dateadd","arithmetic overflow error converting expression to data type int. avg","arithmetic overflow error converting expression to data type nvarchar"],"articleSection":["MSSQL"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/dbtut.com\/index.php\/2019\/04\/02\/arithmetic-overflow-error-converting-expression-to-data-type-int-error-when-using-sum-function\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/dbtut.com\/index.php\/2019\/04\/02\/arithmetic-overflow-error-converting-expression-to-data-type-int-error-when-using-sum-function\/","url":"https:\/\/dbtut.com\/index.php\/2019\/04\/02\/arithmetic-overflow-error-converting-expression-to-data-type-int-error-when-using-sum-function\/","name":"\"Arithmetic overflow error converting expression to data type int.\" Error When Using SUM Function - Database Tutorials","isPartOf":{"@id":"https:\/\/dbtut.com\/#website"},"primaryImageOfPage":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/04\/02\/arithmetic-overflow-error-converting-expression-to-data-type-int-error-when-using-sum-function\/#primaryimage"},"image":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/04\/02\/arithmetic-overflow-error-converting-expression-to-data-type-int-error-when-using-sum-function\/#primaryimage"},"thumbnailUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/04\/Ads\u0131z-1.png","datePublished":"2019-04-02T10:49:55+00:00","description":"\"Arithmetic overflow error converting expression to data type int.\" Error When Using SUM Function","breadcrumb":{"@id":"https:\/\/dbtut.com\/index.php\/2019\/04\/02\/arithmetic-overflow-error-converting-expression-to-data-type-int-error-when-using-sum-function\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/dbtut.com\/index.php\/2019\/04\/02\/arithmetic-overflow-error-converting-expression-to-data-type-int-error-when-using-sum-function\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/index.php\/2019\/04\/02\/arithmetic-overflow-error-converting-expression-to-data-type-int-error-when-using-sum-function\/#primaryimage","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/04\/Ads\u0131z-1.png","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2019\/04\/Ads\u0131z-1.png","width":541,"height":345},{"@type":"BreadcrumbList","@id":"https:\/\/dbtut.com\/index.php\/2019\/04\/02\/arithmetic-overflow-error-converting-expression-to-data-type-int-error-when-using-sum-function\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/dbtut.com\/"},{"@type":"ListItem","position":2,"name":"&#8220;Arithmetic overflow error converting expression to data type int.&#8221; Error When Using SUM Function"}]},{"@type":"WebSite","@id":"https:\/\/dbtut.com\/#website","url":"https:\/\/dbtut.com\/","name":"Database Tutorials","description":"MSSQL, Oracle, PostgreSQL, MySQL, MariaDB, DB2, Sybase, Teradata, Big Data, NOSQL, MongoDB, Couchbase, Cassandra, Windows, Linux","publisher":{"@id":"https:\/\/dbtut.com\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/dbtut.com\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/dbtut.com\/#organization","name":"dbtut","url":"https:\/\/dbtut.com\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/","url":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","contentUrl":"https:\/\/dbtut.com\/wp-content\/uploads\/2021\/02\/dbtutlogo.jpg","width":223,"height":36,"caption":"dbtut"},"image":{"@id":"https:\/\/dbtut.com\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/dbtut.com\/#\/schema\/person\/fc047c39e1e53dce28fc4253529ea408","name":"dbtut","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/dbtut.com\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c322c32021bf651d9e103b183963c479a9c9791ead0715f4348203496c39aa54?s=96&d=mm&r=g","caption":"dbtut"},"description":"We are a team with over 10 years of database management and BI experience. Our Expertises: Oracle, SQL Server, PostgreSQL, MySQL, MongoDB, Elasticsearch, Kibana, Grafana.","sameAs":["http:\/\/NurullahCAKIR"],"url":"https:\/\/dbtut.com\/index.php\/author\/dbtut\/"}]}},"amp_enabled":true,"_links":{"self":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/11260","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/comments?post=11260"}],"version-history":[{"count":0,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/posts\/11260\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media\/11265"}],"wp:attachment":[{"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/media?parent=11260"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/categories?post=11260"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/dbtut.com\/index.php\/wp-json\/wp\/v2\/tags?post=11260"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}