{"id":15133,"date":"2026-02-11T13:05:40","date_gmt":"2026-02-11T13:05:40","guid":{"rendered":"https:\/\/www.bodhost.com\/kb\/?p=15133"},"modified":"2026-02-26T14:02:05","modified_gmt":"2026-02-26T14:02:05","slug":"ms-sql-server-data-types","status":"publish","type":"post","link":"https:\/\/www.bodhost.com\/kb\/ms-sql-server-data-types\/","title":{"rendered":"MS SQL Server Data Types: A Helpful Guide for Developers"},"content":{"rendered":"<p>Once you know how data is actually stored, working with databases becomes a lot easier. Understanding data types is one of the most important concepts that any SQL developer should have. Data types in MS SQL Server define which types of data, including text, numbers, dates, and binary values, can be stored in a column. By choosing the right data type, you may prevent needless storage problems, maintain data accuracy, and speed up database operations.<\/p>\n<h3><strong>What Are MS SQL Data Types?<\/strong><\/h3>\n<p>The format and range of values allowed in a table column are specified by MS SQL data types. They support SQL Server&#8217;s effective data storage and accurate query processing. You may need to store dates, text, numeric values, or even raw binary data, depending on your use case.<\/p>\n<p>For example, numbers, ranging from simple whole values to exact decimal figures, are stored using numeric data types like INT, DECIMAL, and FLOAT. Character types that handle both fixed and variable-length strings, including Unicode characters, such as CHAR, VARCHAR, and NVARCHAR, are used to store text data.<\/p>\n<p>SQL Server has types like DATE, TIME, and DATETIME to manage varying degrees of time precision when working with date and time values. Files, pictures, and other byte-based data can be stored in binary data formats. In addition to increasing performance, selecting the right data type also facilitates database maintenance and scalability.<\/p>\n<h3><strong>Categories of MS SQL Server Data Types<\/strong><\/h3>\n<p>MS SQL Server groups its data types into several categories. Here\u2019s a simple explanation of each:<\/p>\n<h4><strong>1. Numeric Data Types<\/strong><\/h4>\n<div>\n<table>\n<tbody>\n<tr>\n<th><span style=\"color: #333333;\"><strong>Data Type<\/strong><\/span><\/th>\n<th><span style=\"color: #333333;\"><strong>Category<\/strong><\/span><\/th>\n<th><span style=\"color: #333333;\"><strong>Description<\/strong><\/span><\/th>\n<th><span style=\"color: #333333;\"><strong>Example<\/strong><\/span><\/th>\n<\/tr>\n<tr>\n<th scope=\"row\"><span style=\"color: #333333;\"><strong>tinyint<\/strong><\/span><\/th>\n<td>Exact numeric<\/td>\n<td>8\u2011bit integer<\/td>\n<td>127<\/td>\n<\/tr>\n<tr>\n<th scope=\"row\"><span style=\"color: #333333;\"><strong>smallint<\/strong><\/span><\/th>\n<td>Exact numeric<\/td>\n<td>16\u2011bit integer<\/td>\n<td>32767<\/td>\n<\/tr>\n<tr>\n<th scope=\"row\"><span style=\"color: #333333;\"><strong>int<\/strong><\/span><\/th>\n<td>Exact numeric<\/td>\n<td>32\u2011bit integer<\/td>\n<td>2147483647<\/td>\n<\/tr>\n<tr>\n<th scope=\"row\"><span style=\"color: #333333;\"><strong>bigint<\/strong><\/span><\/th>\n<td>Exact numeric<\/td>\n<td>64\u2011bit integer<\/td>\n<td>9223372036854775807<\/td>\n<\/tr>\n<tr>\n<th scope=\"row\"><span style=\"color: #333333;\"><strong>decimal(p, s)<\/strong><\/span><\/th>\n<td>Exact numeric<\/td>\n<td>Fixed\u2011precision decimal<\/td>\n<td>123.45<\/td>\n<\/tr>\n<tr>\n<th scope=\"row\"><span style=\"color: #333333;\"><strong>numeric(p, s)<\/strong><\/span><\/th>\n<td>Exact numeric<\/td>\n<td>Fixed\u2011precision decimal<\/td>\n<td>123.45<\/td>\n<\/tr>\n<tr>\n<th scope=\"row\"><span style=\"color: #333333;\"><strong>float<\/strong><\/span><\/th>\n<td>Approximate numeric<\/td>\n<td>Floating\u2011point number<\/td>\n<td>123.45678<\/td>\n<\/tr>\n<tr>\n<th scope=\"row\"><span style=\"color: #333333;\"><strong>real<\/strong><\/span><\/th>\n<td>Approximate numeric<\/td>\n<td>Floating\u2011point number<\/td>\n<td>123.45<\/td>\n<\/tr>\n<tr>\n<th scope=\"row\"><span style=\"color: #333333;\"><strong>money<\/strong><\/span><\/th>\n<td>Exact numeric<\/td>\n<td>Monetary value<\/td>\n<td>$123.45<\/td>\n<\/tr>\n<tr>\n<th scope=\"row\"><span style=\"color: #333333;\"><strong>smallmoney<\/strong><\/span><\/th>\n<td>Exact numeric<\/td>\n<td>Monetary value<\/td>\n<td>$123.45<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h4><strong>2. String (Character) Data Types<\/strong><\/h4>\n<div>\n<table>\n<tbody>\n<tr>\n<th><span style=\"color: #333333;\"><strong>Data Type<\/strong><\/span><\/th>\n<th><span style=\"color: #333333;\"><strong>Category<\/strong><\/span><\/th>\n<th><span style=\"color: #333333;\"><strong>Description<\/strong><\/span><\/th>\n<th><span style=\"color: #333333;\"><strong>Example<\/strong><\/span><\/th>\n<\/tr>\n<tr>\n<th scope=\"row\"><span style=\"color: #333333;\"><strong>char(n)<\/strong><\/span><\/th>\n<td>Fixed-length<\/td>\n<td>Fixed-size character string<\/td>\n<td><code>'ABC'<\/code><\/td>\n<\/tr>\n<tr>\n<th scope=\"row\"><span style=\"color: #333333;\"><strong>varchar(n)<\/strong><\/span><\/th>\n<td>Variable-length<\/td>\n<td>Flexible-length character string<\/td>\n<td><code>'Hello'<\/code><\/td>\n<\/tr>\n<tr>\n<th scope=\"row\"><span style=\"color: #333333;\"><strong>varchar(max)<\/strong><\/span><\/th>\n<td>Variable-length<\/td>\n<td>Large text storage<\/td>\n<td>Long descriptions<\/td>\n<\/tr>\n<tr>\n<th scope=\"row\"><span style=\"color: #333333;\"><strong>nchar(n)<\/strong><\/span><\/th>\n<td>Fixed-length Unicode<\/td>\n<td>Fixed-size Unicode text<\/td>\n<td><code>'\u4f60\u597d'<\/code><\/td>\n<\/tr>\n<tr>\n<th scope=\"row\"><span style=\"color: #333333;\"><strong>nvarchar(n)<\/strong><\/span><\/th>\n<td>Variable-length Unicode<\/td>\n<td>Flexible Unicode text<\/td>\n<td><code>'\u3053\u3093\u306b\u3061\u306f'<\/code><\/td>\n<\/tr>\n<tr>\n<th scope=\"row\"><span style=\"color: #333333;\"><strong>nvarchar(max)<\/strong><\/span><\/th>\n<td>Variable-length Unicode<\/td>\n<td>Large Unicode text<\/td>\n<td>Full paragraph text<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h4><strong>3. Date and Time Data Types<\/strong><\/h4>\n<div>\n<table>\n<tbody>\n<tr>\n<th><span style=\"color: #333333;\"><strong>Data Type<\/strong><\/span><\/th>\n<th><span style=\"color: #333333;\"><strong>Category<\/strong><\/span><\/th>\n<th><span style=\"color: #333333;\"><strong>Description<\/strong><\/span><\/th>\n<th><span style=\"color: #333333;\"><strong>Example<\/strong><\/span><\/th>\n<\/tr>\n<tr>\n<th scope=\"row\"><span style=\"color: #333333;\"><strong>date<\/strong><\/span><\/th>\n<td>Date type<\/td>\n<td>Stores date only<\/td>\n<td>2026\u201102\u201111<\/td>\n<\/tr>\n<tr>\n<th scope=\"row\"><span style=\"color: #333333;\"><strong>time<\/strong><\/span><\/th>\n<td>Time type<\/td>\n<td>Stores time only<\/td>\n<td>14:45:00<\/td>\n<\/tr>\n<tr>\n<th scope=\"row\"><span style=\"color: #333333;\"><strong>datetime<\/strong><\/span><\/th>\n<td>Date &amp; time<\/td>\n<td>Full date + time<\/td>\n<td>2026\u201102\u201111 14:45:00<\/td>\n<\/tr>\n<tr>\n<th scope=\"row\"><span style=\"color: #333333;\"><strong>datetime2<\/strong><\/span><\/th>\n<td>Date &amp; time<\/td>\n<td>Higher precision datetime<\/td>\n<td>2026\u201102\u201111 14:45:00.1234567<\/td>\n<\/tr>\n<tr>\n<th scope=\"row\"><span style=\"color: #333333;\"><strong>smalldatetime<\/strong><\/span><\/th>\n<td>Date &amp; time<\/td>\n<td>Lower precision, smaller size<\/td>\n<td>2026\u201102\u201111 14:45<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h4><strong>4. Binary Data Types<\/strong><\/h4>\n<div>\n<table>\n<tbody>\n<tr>\n<th><span style=\"color: #333333;\"><strong>Data Type<\/strong><\/span><\/th>\n<th><span style=\"color: #333333;\"><strong>Category<\/strong><\/span><\/th>\n<th><span style=\"color: #333333;\"><strong>Description<\/strong><\/span><\/th>\n<th><span style=\"color: #333333;\"><strong>Example<\/strong><\/span><\/th>\n<\/tr>\n<tr>\n<th scope=\"row\"><span style=\"color: #333333;\"><strong>binary(n)<\/strong><\/span><\/th>\n<td>Fixed binary<\/td>\n<td>Fixed-size binary data<\/td>\n<td><code>0x4F2A<\/code><\/td>\n<\/tr>\n<tr>\n<th scope=\"row\"><span style=\"color: #333333;\"><strong>varbinary(n)<\/strong><\/span><\/th>\n<td>Variable binary<\/td>\n<td>Variable-size binary data<\/td>\n<td><code>0x4F2A7B9D<\/code><\/td>\n<\/tr>\n<tr>\n<th scope=\"row\"><span style=\"color: #333333;\"><strong>varbinary(max)<\/strong><\/span><\/th>\n<td>Variable binary<\/td>\n<td>Large binary objects<\/td>\n<td>Image, file bytes<\/td>\n<\/tr>\n<tr>\n<th scope=\"row\"><span style=\"color: #333333;\"><strong>image<\/strong> (deprecated)<\/span><\/th>\n<td>Large binary<\/td>\n<td>Older type for big binary data<\/td>\n<td>Image\/document<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<h4><strong>Conclusion<\/strong><\/h4>\n<div>\n<p>Data types form the foundation of every SQL Server table. When you choose the right type, your database becomes faster, safer, and easier to manage. Whether you&#8217;re storing numbers, text, dates, or binary files. MS SQL Server offers a clear set of data types for flexible, optimized data storage. Understanding how these types work gives you better control over performance and storage. Overall database quality is an essential skill for every developer.<\/p>\n<p>Learn <a href=\"https:\/\/www.bodhost.com\/kb\/how-to-define-the-custom-port-for-ms-sql-remote-access\/\" target=\"_blank\" rel=\"noopener\"><em>how to set a custom port for MS SQL Server remote access<\/em><\/a> to improve security and ensure stable database connections.<\/p>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>Once you know how data is actually stored, working with databases becomes a lot easier. Understanding data types is one of the most important concepts that any SQL developer should&hellip;<\/p>\n<p><a href=\"https:\/\/www.bodhost.com\/kb\/ms-sql-server-data-types\/\" class=\"more-link\">Read More<\/a><\/p>\n","protected":false},"author":5,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[857],"tags":[1694],"class_list":["post-15133","post","type-post","status-publish","format-standard","hentry","category-sql","tag-ms-sql-server-data-types"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v27.8 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>MS SQL Server Data Types Every Developer Should Know<\/title>\n<meta name=\"description\" content=\"Learn the most important MS SQL Server data types every developer should know for efficient database design and better performance.\" \/>\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.bodhost.com\/kb\/ms-sql-server-data-types\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"MS SQL Server Data Types Every Developer Should Know\" \/>\n<meta property=\"og:description\" content=\"Learn the most important MS SQL Server data types every developer should know for efficient database design and better performance.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.bodhost.com\/kb\/ms-sql-server-data-types\/\" \/>\n<meta property=\"og:site_name\" content=\"Knowledge Base - bodHOST\" \/>\n<meta property=\"article:published_time\" content=\"2026-02-11T13:05:40+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2026-02-26T14:02:05+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.bodhost.com\/kb\/wp-content\/uploads\/2026\/02\/MS-SQL-Servers.png\" \/>\n\t<meta property=\"og:image:width\" content=\"1300\" \/>\n\t<meta property=\"og:image:height\" content=\"628\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"Paul Lopez\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:image\" content=\"https:\/\/www.bodhost.com\/kb\/wp-content\/uploads\/2026\/02\/MS-SQL-Servers.png\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Paul Lopez\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\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:\\\/\\\/www.bodhost.com\\\/kb\\\/ms-sql-server-data-types\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/ms-sql-server-data-types\\\/\"},\"author\":{\"name\":\"Paul Lopez\",\"@id\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/#\\\/schema\\\/person\\\/566ccff9a2fae4af852be8097b179813\"},\"headline\":\"MS SQL Server Data Types: A Helpful Guide for Developers\",\"datePublished\":\"2026-02-11T13:05:40+00:00\",\"dateModified\":\"2026-02-26T14:02:05+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/ms-sql-server-data-types\\\/\"},\"wordCount\":565,\"publisher\":{\"@id\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/#organization\"},\"keywords\":[\"MS SQL Server Data Types\"],\"articleSection\":[\"SQL\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/ms-sql-server-data-types\\\/\",\"url\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/ms-sql-server-data-types\\\/\",\"name\":\"MS SQL Server Data Types Every Developer Should Know\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/#website\"},\"datePublished\":\"2026-02-11T13:05:40+00:00\",\"dateModified\":\"2026-02-26T14:02:05+00:00\",\"description\":\"Learn the most important MS SQL Server data types every developer should know for efficient database design and better performance.\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/ms-sql-server-data-types\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/ms-sql-server-data-types\\\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/ms-sql-server-data-types\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"SQL\",\"item\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/category\\\/sql\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"MS SQL Server Data Types: A Helpful Guide for Developers\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/#website\",\"url\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/\",\"name\":\"Web Hosting Knowledge Base | bodHOST Hosting FAQ\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/#organization\"},\"alternateName\":\"Web Hosting Knowledge Base | bodHOST Hosting FAQ\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/#organization\",\"name\":\"Web Hosting Knowledge Base | bodHOST Hosting FAQ\",\"url\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/wp-content\\\/uploads\\\/2025\\\/10\\\/Profile-Pic.png\",\"contentUrl\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/wp-content\\\/uploads\\\/2025\\\/10\\\/Profile-Pic.png\",\"width\":240,\"height\":240,\"caption\":\"Web Hosting Knowledge Base | bodHOST Hosting FAQ\"},\"image\":{\"@id\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/#\\\/schema\\\/logo\\\/image\\\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/#\\\/schema\\\/person\\\/566ccff9a2fae4af852be8097b179813\",\"name\":\"Paul Lopez\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/c63d9f5400cd5ef87b481a24b2c1a4fb89f1674b6391325326cf13f1e735dff8?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/c63d9f5400cd5ef87b481a24b2c1a4fb89f1674b6391325326cf13f1e735dff8?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/c63d9f5400cd5ef87b481a24b2c1a4fb89f1674b6391325326cf13f1e735dff8?s=96&d=mm&r=g\",\"caption\":\"Paul Lopez\"},\"url\":\"https:\\\/\\\/www.bodhost.com\\\/kb\\\/author\\\/paullopez\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"MS SQL Server Data Types Every Developer Should Know","description":"Learn the most important MS SQL Server data types every developer should know for efficient database design and better performance.","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.bodhost.com\/kb\/ms-sql-server-data-types\/","og_locale":"en_US","og_type":"article","og_title":"MS SQL Server Data Types Every Developer Should Know","og_description":"Learn the most important MS SQL Server data types every developer should know for efficient database design and better performance.","og_url":"https:\/\/www.bodhost.com\/kb\/ms-sql-server-data-types\/","og_site_name":"Knowledge Base - bodHOST","article_published_time":"2026-02-11T13:05:40+00:00","article_modified_time":"2026-02-26T14:02:05+00:00","og_image":[{"width":1300,"height":628,"url":"https:\/\/www.bodhost.com\/kb\/wp-content\/uploads\/2026\/02\/MS-SQL-Servers.png","type":"image\/png"}],"author":"Paul Lopez","twitter_card":"summary_large_image","twitter_image":"https:\/\/www.bodhost.com\/kb\/wp-content\/uploads\/2026\/02\/MS-SQL-Servers.png","twitter_misc":{"Written by":"Paul Lopez","Est. reading time":"3 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.bodhost.com\/kb\/ms-sql-server-data-types\/#article","isPartOf":{"@id":"https:\/\/www.bodhost.com\/kb\/ms-sql-server-data-types\/"},"author":{"name":"Paul Lopez","@id":"https:\/\/www.bodhost.com\/kb\/#\/schema\/person\/566ccff9a2fae4af852be8097b179813"},"headline":"MS SQL Server Data Types: A Helpful Guide for Developers","datePublished":"2026-02-11T13:05:40+00:00","dateModified":"2026-02-26T14:02:05+00:00","mainEntityOfPage":{"@id":"https:\/\/www.bodhost.com\/kb\/ms-sql-server-data-types\/"},"wordCount":565,"publisher":{"@id":"https:\/\/www.bodhost.com\/kb\/#organization"},"keywords":["MS SQL Server Data Types"],"articleSection":["SQL"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.bodhost.com\/kb\/ms-sql-server-data-types\/","url":"https:\/\/www.bodhost.com\/kb\/ms-sql-server-data-types\/","name":"MS SQL Server Data Types Every Developer Should Know","isPartOf":{"@id":"https:\/\/www.bodhost.com\/kb\/#website"},"datePublished":"2026-02-11T13:05:40+00:00","dateModified":"2026-02-26T14:02:05+00:00","description":"Learn the most important MS SQL Server data types every developer should know for efficient database design and better performance.","breadcrumb":{"@id":"https:\/\/www.bodhost.com\/kb\/ms-sql-server-data-types\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.bodhost.com\/kb\/ms-sql-server-data-types\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.bodhost.com\/kb\/ms-sql-server-data-types\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"SQL","item":"https:\/\/www.bodhost.com\/kb\/category\/sql\/"},{"@type":"ListItem","position":2,"name":"MS SQL Server Data Types: A Helpful Guide for Developers"}]},{"@type":"WebSite","@id":"https:\/\/www.bodhost.com\/kb\/#website","url":"https:\/\/www.bodhost.com\/kb\/","name":"Web Hosting Knowledge Base | bodHOST Hosting FAQ","description":"","publisher":{"@id":"https:\/\/www.bodhost.com\/kb\/#organization"},"alternateName":"Web Hosting Knowledge Base | bodHOST Hosting FAQ","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.bodhost.com\/kb\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.bodhost.com\/kb\/#organization","name":"Web Hosting Knowledge Base | bodHOST Hosting FAQ","url":"https:\/\/www.bodhost.com\/kb\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.bodhost.com\/kb\/#\/schema\/logo\/image\/","url":"https:\/\/www.bodhost.com\/kb\/wp-content\/uploads\/2025\/10\/Profile-Pic.png","contentUrl":"https:\/\/www.bodhost.com\/kb\/wp-content\/uploads\/2025\/10\/Profile-Pic.png","width":240,"height":240,"caption":"Web Hosting Knowledge Base | bodHOST Hosting FAQ"},"image":{"@id":"https:\/\/www.bodhost.com\/kb\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/www.bodhost.com\/kb\/#\/schema\/person\/566ccff9a2fae4af852be8097b179813","name":"Paul Lopez","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/c63d9f5400cd5ef87b481a24b2c1a4fb89f1674b6391325326cf13f1e735dff8?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/c63d9f5400cd5ef87b481a24b2c1a4fb89f1674b6391325326cf13f1e735dff8?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c63d9f5400cd5ef87b481a24b2c1a4fb89f1674b6391325326cf13f1e735dff8?s=96&d=mm&r=g","caption":"Paul Lopez"},"url":"https:\/\/www.bodhost.com\/kb\/author\/paullopez\/"}]}},"_links":{"self":[{"href":"https:\/\/www.bodhost.com\/kb\/wp-json\/wp\/v2\/posts\/15133","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.bodhost.com\/kb\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.bodhost.com\/kb\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.bodhost.com\/kb\/wp-json\/wp\/v2\/users\/5"}],"replies":[{"embeddable":true,"href":"https:\/\/www.bodhost.com\/kb\/wp-json\/wp\/v2\/comments?post=15133"}],"version-history":[{"count":9,"href":"https:\/\/www.bodhost.com\/kb\/wp-json\/wp\/v2\/posts\/15133\/revisions"}],"predecessor-version":[{"id":15142,"href":"https:\/\/www.bodhost.com\/kb\/wp-json\/wp\/v2\/posts\/15133\/revisions\/15142"}],"wp:attachment":[{"href":"https:\/\/www.bodhost.com\/kb\/wp-json\/wp\/v2\/media?parent=15133"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.bodhost.com\/kb\/wp-json\/wp\/v2\/categories?post=15133"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.bodhost.com\/kb\/wp-json\/wp\/v2\/tags?post=15133"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}