{"id":116,"date":"2014-05-01T12:30:00","date_gmt":"2014-05-01T11:30:00","guid":{"rendered":"https:\/\/debuggersspace.com\/index.php\/2014\/05\/01\/sql-data-types\/"},"modified":"2014-05-01T12:30:00","modified_gmt":"2014-05-01T11:30:00","slug":"sql-data-types","status":"publish","type":"post","link":"https:\/\/debuggersspace.com\/index.php\/2014\/05\/01\/sql-data-types\/","title":{"rendered":"SQL – Data Types?"},"content":{"rendered":"
\n
\n \t<\/i> Read Time:<\/span>1 Minute, 53 Second <\/div>\n\n <\/div>
\n
\nSQL Server offers six categories of data types for your use:<\/span><\/div>\n

\nExact Numeric Data Types:<\/span><\/h2>\n\n\n\n\n\n\n\n\n\n\n\n\n
DATA TYPE<\/span><\/th>\nFROM<\/span><\/th>\nTO<\/span><\/th>\n<\/tr>\n
bigint<\/span><\/td>\n-9,223,372,036,854,775,808<\/span><\/td>\n9,223,372,036,854,775,807<\/span><\/td>\n<\/tr>\n
int<\/span><\/td>\n-2,147,483,648<\/span><\/td>\n2,147,483,647<\/span><\/td>\n<\/tr>\n
smallint<\/span><\/td>\n-32,768<\/span><\/td>\n32,767<\/span><\/td>\n<\/tr>\n
tinyint<\/span><\/td>\n0<\/span><\/td>\n255<\/span><\/td>\n<\/tr>\n
bit<\/span><\/td>\n0<\/span><\/td>\n1<\/span><\/td>\n<\/tr>\n
decimal<\/span><\/td>\n-10^38 +1<\/span><\/td>\n10^38 -1<\/span><\/td>\n<\/tr>\n
numeric<\/span><\/td>\n-10^38 +1<\/span><\/td>\n10^38 -1<\/span><\/td>\n<\/tr>\n
money<\/span><\/td>\n-922,337,203,685,477.5808<\/span><\/td>\n+922,337,203,685,477.5807<\/span><\/td>\n<\/tr>\n
smallmoney<\/span><\/td>\n-214,748.3648<\/span><\/td>\n+214,748.3647<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\nApproximate Numeric Data Types:<\/span><\/h2>\n\n\n\n\n\n
DATA TYPE<\/span><\/th>\nFROM<\/span><\/th>\nTO<\/span><\/th>\n<\/tr>\n
float<\/span><\/td>\n-1.79E + 308<\/span><\/td>\n1.79E + 308<\/span><\/td>\n<\/tr>\n
real<\/span><\/td>\n-3.40E + 38<\/span><\/td>\n3.40E + 38<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\nDate and Time Data Types:<\/span><\/h2>\n\n\n\n\n\n\n\n
DATA TYPE<\/span><\/th>\nFROM<\/span><\/th>\nTO<\/span><\/th>\n<\/tr>\n
datetime<\/span><\/td>\nJan 1, 1753<\/span><\/td>\nDec 31, 9999<\/span><\/td>\n<\/tr>\n
smalldatetime<\/span><\/td>\nJan 1, 1900<\/span><\/td>\nJun 6, 2079<\/span><\/td>\n<\/tr>\n
date<\/span><\/td>\nStores a date like June 30, 1991<\/span><\/td>\n<\/tr>\n
time<\/span><\/td>\nStores a time of day like 12:30 P.M.<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n
\nNote:<\/b> Here, datetime has 3.33 milliseconds accuracy where as smalldatetime has 1 minute accuracy.<\/span><\/div>\n

\nCharacter Strings Data Types:<\/span><\/h2>\n\n\n\n\n\n\n\n
DATA TYPE<\/span><\/th>\nFROM<\/span><\/th>\nTO<\/span><\/th>\n<\/tr>\n
char<\/span><\/td>\nchar<\/span><\/td>\nMaximum length of 8,000 characters.( Fixed length non-Unicode characters)<\/span><\/td>\n<\/tr>\n
varchar<\/span><\/td>\nvarchar<\/span><\/td>\nMaximum of 8,000 characters.(Variable-length non-Unicode data).<\/span><\/td>\n<\/tr>\n
varchar(max)<\/span><\/td>\nvarchar(max)<\/span><\/td>\nMaximum length of 231characters, Variable-length non-Unicode data (SQL Server 2005 only).<\/span><\/td>\n<\/tr>\n
text<\/span><\/td>\ntext<\/span><\/td>\nVariable-length non-Unicode data with a maximum length of 2,147,483,647 characters.<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\nUnicode Character Strings Data Types:<\/span><\/h2>\n\n\n\n\n\n\n\n
DATA TYPE<\/span><\/th>\nDescription<\/span><\/th>\n<\/tr>\n
nchar<\/span><\/td>\nMaximum length of 4,000 characters.( Fixed length Unicode)<\/span><\/td>\n<\/tr>\n
nvarchar<\/span><\/td>\nMaximum length of 4,000 characters.(Variable length Unicode)<\/span><\/td>\n<\/tr>\n
nvarchar(max)<\/span><\/td>\nMaximum length of 231characters (SQL Server 2005 only).( Variable length Unicode)<\/span><\/td>\n<\/tr>\n
ntext<\/span><\/td>\nMaximum length of 1,073,741,823 characters. ( Variable length Unicode )<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\nBinary Data Types:<\/span><\/h2>\n\n\n\n\n\n\n\n
DATA TYPE<\/span><\/th>\nDescription<\/span><\/th>\n<\/tr>\n
binary<\/span><\/td>\nMaximum length of 8,000 bytes(Fixed-length binary data )<\/span><\/td>\n<\/tr>\n
varbinary<\/span><\/td>\nMaximum length of 8,000 bytes.(Variable length binary data)<\/span><\/td>\n<\/tr>\n
varbinary(max)<\/span><\/td>\nMaximum length of 231 bytes (SQL Server 2005 only). ( Variable length Binary data)<\/span><\/td>\n<\/tr>\n
image<\/span><\/td>\nMaximum length of 2,147,483,647 bytes. ( Variable length Binary Data)<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\nMisc Data Types:<\/span><\/h2>\n\n\n\n\n\n\n\n\n\n
DATA TYPE<\/span><\/th>\nDescription<\/span><\/th>\n<\/tr>\n
sql_variant<\/span><\/td>\nStores values of various SQL Server-supported data types, except text, ntext, and timestamp.<\/span><\/td>\n<\/tr>\n
timestamp<\/span><\/td>\nStores a database-wide unique number that gets updated every time a row gets updated<\/span><\/td>\n<\/tr>\n
uniqueidentifier<\/span><\/td>\nStores a globally unique identifier (GUID)<\/span><\/td>\n<\/tr>\n
xml<\/span><\/td>\nStores XML data. You can store xml instances in a column or a variable (SQL Server 2005 only).<\/span><\/td>\n<\/tr>\n
cursor<\/span><\/td>\nReference to a cursor object<\/span><\/td>\n<\/tr>\n
table<\/span><\/td>\nStores a result set for later processing<\/span><\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

SQL Server offers six categories of data types for your use: Exact Numeric Data Types: DATA TYPE FROM TO bigint -9,223,372,036,854,775,808 9,223,372,036,854,775,807 int -2,147,483,648 2,147,483,647 smallint -32,768 32,767 tinyint 0 255 bit 0 1 decimal -10^38 +1 10^38 -1 numeric -10^38 +1 10^38 -1 money -922,337,203,685,477.5808 +922,337,203,685,477.5807 smallmoney -214,748.3648 +214,748.3647 Approximate Numeric Data Types: DATA […]<\/p>\n","protected":false},"author":43,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_uag_custom_page_level_css":"","footnotes":""},"categories":[27],"tags":[],"class_list":["post-116","post","type-post","status-publish","format-standard","hentry","category-sql"],"uagb_featured_image_src":{"full":false,"thumbnail":false,"medium":false,"medium_large":false,"large":false,"1536x1536":false,"2048x2048":false},"uagb_author_info":{"display_name":"Himanshu Namdeo","author_link":"https:\/\/debuggersspace.com\/author\/admin\/"},"uagb_comment_info":0,"uagb_excerpt":"SQL Server offers six categories of data types for your use: Exact Numeric Data Types: DATA TYPE FROM TO bigint -9,223,372,036,854,775,808 9,223,372,036,854,775,807 int -2,147,483,648 2,147,483,647 smallint -32,768 32,767 tinyint 0 255 bit 0 1 decimal -10^38 +1 10^38 -1 numeric -10^38 +1 10^38 -1 money -922,337,203,685,477.5808 +922,337,203,685,477.5807 smallmoney -214,748.3648 +214,748.3647 Approximate Numeric Data Types: DATA…","_links":{"self":[{"href":"https:\/\/debuggersspace.com\/index.php\/wp-json\/wp\/v2\/posts\/116"}],"collection":[{"href":"https:\/\/debuggersspace.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/debuggersspace.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/debuggersspace.com\/index.php\/wp-json\/wp\/v2\/users\/43"}],"replies":[{"embeddable":true,"href":"https:\/\/debuggersspace.com\/index.php\/wp-json\/wp\/v2\/comments?post=116"}],"version-history":[{"count":0,"href":"https:\/\/debuggersspace.com\/index.php\/wp-json\/wp\/v2\/posts\/116\/revisions"}],"wp:attachment":[{"href":"https:\/\/debuggersspace.com\/index.php\/wp-json\/wp\/v2\/media?parent=116"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/debuggersspace.com\/index.php\/wp-json\/wp\/v2\/categories?post=116"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/debuggersspace.com\/index.php\/wp-json\/wp\/v2\/tags?post=116"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}