Data types in SQL Server
VARCHAR(n) Character string of variable length with maximum length n
VARCHAR(MAX) Character string of variable length with maximum length can exceed 8000 byes
NCHAR(n) Fixed-length Unicode string data where n defines the string length and must be a value from 1 through 4,000
NVARCHAR(n) Variable length Unicode string data where n defines the string length and must be a value from 1 through 4,000
NVARCHAR(MAX) Variable length Unicode string data where MAX indicates that the maximum storage size is 2^31-1 bytes (2 GB)
BINARY(n) Binary string of fixed length n
BOOLEAN It stores TRUE or FALSE values
VARBINARY(n) Binary string of variable length with maximum length n
NTEXT Variable-length Unicode data with a maximum string length of 2^30 – 1 (1,073,741,823) bytes
TEXT Variable-length non-Unicode data in the code page of the server and with a maximum string length of 2^31-1 (2,147,483,647)
IMAGE Variable-length binary data from 0 through 2^31-1 (2,147,483,647) bytes.
INTEGER Or Int A 32-bit signed integer value having range of INTEGER is -2147483648 to 2147483647
SMALLINT A 16-bit signed integer value having range of SMALLINT is -32768 to 32767.
BIGINT A 64-bit signed integer value having range of BIGINT is -9223372036854775808 to 9223372036854775807
DECIMAL(p,s) Exact numerical, precision p, scale s. For Example, Decimal(5,3) means 22.212
NUMERIC(p,s) Exact numerical, precision p, scale s. (Same as DECIMAL)
REAL Approximate numerical, mantissa precision 7
FLOAT Approximate numerical, mantissa precision 16
DOUBLE Approximate numerical, mantissa precision 16
DATE It stores year/month/day values
TIME It stores hour/minute/second values
TIMESTAMP It stores year/month/day/hour/minute/second values
XML It stores XML data
Pingback: กำถั่ว
Pingback: 바카라사이트
Pingback: game changer
Pingback: Creative Agency Graphiste à Montreux
Pingback: How to watch Rugby World Cup 2019 live stream online instantly
Pingback: didi promo code
Pingback: แทงบอลออนไลน์
Pingback: click here to visit Bhojpuri film for free
Pingback: bitcoin
Pingback: Gangnam clinic
Pingback: https://drywallrepaircontractors.info/usa/drywall-repair/mt
Pingback: http://amhurt.pl/nadzieja-2188.php
Pingback: tiketqq
Pingback: ฝากถอนโอนไว
Pingback: شركات التنظيف بالرياض
Pingback: บริษัท ออล ครีเอตี้ แลนด์ จำกัด
Pingback: https://biznesblog.biz.pl/co-zrobic-gdy-klient-nie-placi-faktur/
Pingback: dang ky bong88
Pingback: nha cai w88
Pingback: Dream Market
Pingback: w88 play
Pingback: market survey for new business
Pingback: cá độ online
Pingback: pokermas99
Pingback: www.nuguru.info
Pingback: artikel kesehatan
Pingback: granice
Pingback: www.1lapakqq.site
Pingback: ltc qr code generator
Pingback: www.rajaqqtop.com
Pingback: qiuqiu99
Pingback: Walmart