\n| DECIMAL(size,d)<\/td>\n | A DOUBLE stored as a string , allowing for a fixed decimal point. The maximum number of digits may be specified in the size parameter. The maximum number of digits to the right of the decimal point is specified in the d parameter<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n *The integer types have an extra option called UNSIGNED<\/strong>. Normally, the integer goes from an negative to positive value. Adding the UNSIGNED attribute will move that range up so it starts at zero instead of a negative number.<\/p>\n\n- Date data types:<\/strong><\/li>\n<\/ul>\n
\n\n\nData type<\/strong><\/td>\nDescription<\/strong><\/td>\n<\/tr>\n\n| DATE()<\/td>\n | A date. Format: YYYY-MM-DD<\/p>\n Note:<\/strong>\u00a0The supported range is from ‘1000-01-01’ to ‘9999-12-31’<\/td>\n<\/tr>\n\n| DATETIME()<\/td>\n | *A date and time combination. Format: YYYY-MM-DD HH:MI:SS<\/p>\n Note:<\/strong>\u00a0The supported range is from ‘1000-01-01 00:00:00’ to ‘9999-12-31 23:59:59’<\/td>\n<\/tr>\n\n| TIMESTAMP()<\/td>\n | *A timestamp. TIMESTAMP values are stored as the number of seconds since the Unix epoch (‘1970-01-01 00:00:00’ UTC). Format: YYYY-MM-DD HH:MI:SS<\/p>\n Note:<\/strong>\u00a0The supported range is from ‘1970-01-01 00:00:01’ UTC to ‘2038-01-09 03:14:07’ UTC<\/td>\n<\/tr>\n\n| TIME()<\/td>\n | A time. Format: HH:MI:SS<\/p>\n Note:<\/strong>\u00a0The supported range is from ‘-838:59:59’ to ‘838:59:59’<\/td>\n<\/tr>\n\n| YEAR()<\/td>\n | A year in two-digit or four-digit format.<\/p>\n Note:<\/strong>\u00a0Values allowed in four-digit format: 1901 to 2155. Values allowed in two-digit format: 70 to 69, representing years from 1970 to 2069<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n*Even if DATETIME and TIMESTAMP return the same format, they work very differently. In an INSERT or UPDATE query, the TIMESTAMP automatically set itself to the current date and time. TIMESTAMP also accepts various formats, like YYYYMMDDHHMISS, YYMMDDHHMISS, YYYYMMDD, or YYMMDD.<\/p>\n Ki\u1ec3u d\u1eef li\u1ec7u trong SQL Server:<\/strong><\/p>\n\n- String data types:<\/strong><\/li>\n<\/ul>\n
\n\n\nData type<\/strong><\/td>\nDescription<\/strong><\/td>\nMax size<\/strong><\/td>\nStorage<\/strong><\/td>\n<\/tr>\n\n| char(n)<\/td>\n | Fixed width character string<\/td>\n | 8,000 characters<\/td>\n | Defined width<\/td>\n<\/tr>\n | \n| varchar(n)<\/td>\n | Variable width character string<\/td>\n | 8,000 characters<\/td>\n | 2 bytes + number of chars<\/td>\n<\/tr>\n | \n| varchar(max)<\/td>\n | Variable width character string<\/td>\n | 1,073,741,824 characters<\/td>\n | 2 bytes + number of chars<\/td>\n<\/tr>\n | \n| text<\/td>\n | Variable width character string<\/td>\n | 2GB of text data<\/td>\n | 4 bytes + number of chars<\/td>\n<\/tr>\n | \n| nchar<\/td>\n | Fixed width Unicode string<\/td>\n | 4,000 characters<\/td>\n | Defined width x 2<\/td>\n<\/tr>\n | \n| nvarchar<\/td>\n | Variable width Unicode string<\/td>\n | 4,000 characters<\/td>\n | <\/td>\n<\/tr>\n | \n| nvarchar(max)<\/td>\n | Variable width Unicode string<\/td>\n | 536,870,912 characters<\/td>\n | <\/td>\n<\/tr>\n | \n| ntext<\/td>\n | Variable width Unicode string<\/td>\n | 2GB of text data<\/td>\n | <\/td>\n<\/tr>\n | \n| binary(n)<\/td>\n | Fixed width binary string<\/td>\n | 8,000 bytes<\/td>\n | <\/td>\n<\/tr>\n | \n| varbinary<\/td>\n | Variable width binary string<\/td>\n | 8,000 bytes<\/td>\n | <\/td>\n<\/tr>\n | \n| varbinary(max)<\/td>\n | Variable width binary string<\/td>\n | 2GB<\/td>\n | <\/td>\n<\/tr>\n | \n| image<\/td>\n | Variable width binary string<\/td>\n | 2GB<\/td>\n | <\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n\n- Number data type:<\/strong><\/li>\n<\/ul>\n
\n\n\n| Data type<\/td>\n | Description<\/td>\n | Storage<\/td>\n<\/tr>\n | \n| bit<\/td>\n | Integer that can be 0, 1, or NULL<\/td>\n | <\/td>\n<\/tr>\n | \n| tinyint<\/td>\n | Allows whole numbers from 0 to 255<\/td>\n | 1 byte<\/td>\n<\/tr>\n | \n| smallint<\/td>\n | Allows whole numbers between -32,768 and 32,767<\/td>\n | 2 bytes<\/td>\n<\/tr>\n | \n| int<\/td>\n | Allows whole numbers between -2,147,483,648 and 2,147,483,647<\/td>\n | 4 bytes<\/td>\n<\/tr>\n | \n| bigint<\/td>\n | Allows whole numbers between -9,223,372,036,854,775,808 and 9,223,372,036,854,775,807<\/td>\n | 8 bytes<\/td>\n<\/tr>\n | \n| decimal(p,s)<\/td>\n | Fixed precision and scale numbers.<\/p>\n Allows numbers from -10^38 +1 to 10^38 \u20131.<\/p>\n The p parameter indicates the maximum total number of digits that can be stored (both to the left and to the right of the decimal point). p must be a value from 1 to 38. Default is 18.<\/p>\n The s parameter indicates the maximum number of digits stored to the right of the decimal point. s must be a value from 0 to p. Default value is 0<\/td>\n | 5-17 bytes<\/td>\n<\/tr>\n | \n| numeric(p,s)<\/td>\n | Fixed precision and scale numbers.<\/p>\n Allows numbers from -10^38 +1 to 10^38 \u20131.<\/p>\n The p parameter indicates the maximum total number of digits that can be stored (both to the left and to the right of the decimal point). p must be a value from 1 to 38. Default is 18.<\/p>\n The s parameter indicates the maximum number of digits stored to the right of the decimal point. s must be a value from 0 to p. Default value is 0<\/td>\n | 5-17 bytes<\/td>\n<\/tr>\n | \n| smallmoney<\/td>\n | Monetary data from -214,748.3648 to 214,748.3647<\/td>\n | 4 bytes<\/td>\n<\/tr>\n | \n| money<\/td>\n | Monetary data from -922,337,203,685,477.5808 to 922,337,203,685,477.5807<\/td>\n | 8 bytes<\/td>\n<\/tr>\n | \n| float(n)<\/td>\n | Floating precision number data from -1.79E + 308 to 1.79E + 308.<\/p>\n The n parameter indicates whether the field should hold 4 or 8 bytes. float(24) holds a 4-byte field and float(53) holds an 8-byte field. Default value of n is 53.<\/td>\n | 4 or 8 bytes<\/td>\n<\/tr>\n | \n| real<\/td>\n | Floating precision number data from -3.40E + 38 to 3.40E + 38<\/td>\n | 4 bytes<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n\n- Date data types:<\/strong><\/li>\n<\/ul>\n
\n\n\n| Data type<\/td>\n | Description<\/td>\n | Storage<\/td>\n<\/tr>\n | \n| datetime<\/td>\n | From January 1, 1753 to December 31, 9999 with an accuracy of 3.33 milliseconds<\/td>\n | 8 bytes<\/td>\n<\/tr>\n | \n| datetime2<\/td>\n | From January 1, 0001 to December 31, 9999 with an accuracy of 100 nanoseconds<\/td>\n | 6-8 bytes<\/td>\n<\/tr>\n | \n| smalldatetime<\/td>\n | From January 1, 1900 to June 6, 2079 with an accuracy of 1 minute<\/td>\n | 4 bytes<\/td>\n<\/tr>\n | \n| date<\/td>\n | Store a date only. From January 1, 0001 to December 31, 9999<\/td>\n | 3 bytes<\/td>\n<\/tr>\n | \n| time<\/td>\n | Store a time only to an accuracy of 100 nanoseconds<\/td>\n | 3-5 bytes<\/td>\n<\/tr>\n | \n| datetimeoffset<\/td>\n | The same as datetime2 with the addition of a time zone offset<\/td>\n | 8-10 bytes<\/td>\n<\/tr>\n | \n| timestamp<\/td>\n | Stores a unique number that gets updated every time a row gets created or modified. The timestamp value is based upon an internal clock and does not correspond to real time. Each table may have only one timestamp variable<\/td>\n | <\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n\n- C\u00e1c ki\u1ec3u d\u1eef li\u1ec7u kh\u00e1c:<\/strong><\/li>\n<\/ul>\n
\n\n\n| Data type<\/td>\n | Description<\/td>\n<\/tr>\n | \n| sql_variant<\/td>\n | Stores up to 8,000 bytes of data of various data types, except text, ntext, and timestamp<\/td>\n<\/tr>\n | \n| uniqueidentifier<\/td>\n | Stores a globally unique identifier (GUID)<\/td>\n<\/tr>\n | \n| xml<\/td>\n | Stores XML formatted data. Maximum 2GB<\/td>\n<\/tr>\n | \n| cursor<\/td>\n | Stores a reference to a cursor used for database operations<\/td>\n<\/tr>\n | \n| table<\/td>\n | Stores a result-set for later processing<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n Microsoft Access Data Types:<\/strong><\/p>\n\n\n\n| Data type<\/td>\n | Description<\/td>\n | Storage<\/td>\n<\/tr>\n | \n| Text<\/td>\n | Use for text or combinations of text and numbers. 255 characters maximum<\/td>\n | <\/td>\n<\/tr>\n | \n| Memo<\/td>\n | Memo is used for larger amounts of text. Stores up to 65,536 characters.\u00a0Note:\u00a0You cannot sort a memo field. However, they are searchable<\/td>\n | <\/td>\n<\/tr>\n | \n| Byte<\/td>\n | Allows whole numbers from 0 to 255<\/td>\n | 1 byte<\/td>\n<\/tr>\n | \n| Integer<\/td>\n | Allows whole numbers between -32,768 and 32,767<\/td>\n | 2 bytes<\/td>\n<\/tr>\n | \n| Long<\/td>\n | Allows whole numbers between -2,147,483,648 and 2,147,483,647<\/td>\n | 4 bytes<\/td>\n<\/tr>\n | \n| Single<\/td>\n | Single precision floating-point. Will handle most decimals<\/td>\n | 4 bytes<\/td>\n<\/tr>\n | \n| Double<\/td>\n | Double precision floating-point. Will handle most decimals<\/td>\n | 8 bytes<\/td>\n<\/tr>\n | \n| Currency<\/td>\n | Use for currency. Holds up to 15 digits of whole dollars, plus 4 decimal places.\u00a0Tip:\u00a0You can choose which country’s currency to use<\/td>\n | 8 bytes<\/td>\n<\/tr>\n | \n| AutoNumber<\/td>\n | AutoNumber fields automatically give each record its own number, usually starting at 1<\/td>\n | 4 bytes<\/td>\n<\/tr>\n | \n| Date\/Time<\/td>\n | Use for dates and times<\/td>\n | 8 bytes<\/td>\n<\/tr>\n | \n| Yes\/No<\/td>\n | A logical field can be displayed as Yes\/No, True\/False, or On\/Off. In code, use the constants True and False (equivalent to -1 and 0).\u00a0Note:\u00a0Null values are not allowed in Yes\/No fields<\/td>\n | 1 bit<\/td>\n<\/tr>\n | \n| Ole Object<\/td>\n | Can store pictures, audio, video, or other BLOBs (Binary Large OBjects)<\/td>\n | up to 1GB<\/td>\n<\/tr>\n | \n| Hyperlink<\/td>\n | Contain links to other files, including web pages<\/td>\n | <\/td>\n<\/tr>\n | \n| Lookup Wizard<\/td>\n | Let you type a list of options, which can then be chosen from a drop-down list<\/td>\n | 4 bytes<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n","protected":false},"excerpt":{"rendered":" Trong b\u00e0i vi\u1ebft tr\u01b0\u1edbc, ch\u00fang ta \u0111\u00e3 t\u00ecm hi\u1ec3u c\u00e1c kh\u00e1i ni\u1ec7m v\u1ec1 SQL, Database… trong \u0111\u00f3 c\u00f3 \u0111\u1ec1 c\u1eadp \u0111\u1ebfn Ki\u1ec3u d\u1eef li\u1ec7u (Data Type), trong b\u00e0i n\u00e0y ch\u00fang ta s\u1ebd \u0111i t\u00ecm hi\u1ec3u v\u1ec1 c\u00e1c ki\u1ec3u d\u1eef li\u1ec7u trong SQL. Ki\u1ec3u d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c khai b\u00e1o khi b\u1ea1n t\u1ea1o b\u1ea3ng cho c\u01a1 s\u1edf d\u1eef li\u1ec7u. C\u00e1c c\u1ed9t d\u1eef li\u1ec7u c\u1ee7a b\u1ea3ng s\u1ebd ph\u1ea3i \u0111\u01b0\u1ee3c \u0111\u1ecbnh ngh\u0129a c\u00e1c ki\u1ec3u d\u1eef li\u1ec7u t\u01b0\u01a1ng \u1ee9ng m\u00e0 n\u00f3 c\u00f3 th\u1ec3 ch\u1ee9a. N\u00f3i m\u1ed9t c\u00e1ch kh\u00e1c, m\u1ed7i c\u1ed9t d\u1eef li\u1ec7u s\u1ebd ch\u01b0a m\u1ed9t…<\/p>\n","protected":false},"author":2,"featured_media":3559,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_exactmetrics_skip_tracking":false,"footnotes":""},"categories":[22,7],"tags":[],"class_list":["post-3574","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-database","category-kien-thuc"],"yoast_head":"\n C\u00e1c ki\u1ec3u d\u1eef li\u1ec7u trong SQL - EngISV<\/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.engisv.info\/?p=3574\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"C\u00e1c ki\u1ec3u d\u1eef li\u1ec7u trong SQL - EngISV\" \/>\n<meta property=\"og:description\" content=\"Trong b\u00e0i vi\u1ebft tr\u01b0\u1edbc, ch\u00fang ta \u0111\u00e3 t\u00ecm hi\u1ec3u c\u00e1c kh\u00e1i ni\u1ec7m v\u1ec1 SQL, Database… trong \u0111\u00f3 c\u00f3 \u0111\u1ec1 c\u1eadp \u0111\u1ebfn Ki\u1ec3u d\u1eef li\u1ec7u (Data Type), trong b\u00e0i n\u00e0y ch\u00fang ta s\u1ebd \u0111i t\u00ecm hi\u1ec3u v\u1ec1 c\u00e1c ki\u1ec3u d\u1eef li\u1ec7u trong SQL. Ki\u1ec3u d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c khai b\u00e1o khi b\u1ea1n t\u1ea1o b\u1ea3ng cho c\u01a1 s\u1edf d\u1eef li\u1ec7u. C\u00e1c c\u1ed9t d\u1eef li\u1ec7u c\u1ee7a b\u1ea3ng s\u1ebd ph\u1ea3i \u0111\u01b0\u1ee3c \u0111\u1ecbnh ngh\u0129a c\u00e1c ki\u1ec3u d\u1eef li\u1ec7u t\u01b0\u01a1ng \u1ee9ng m\u00e0 n\u00f3 c\u00f3 th\u1ec3 ch\u1ee9a. N\u00f3i m\u1ed9t c\u00e1ch kh\u00e1c, m\u1ed7i c\u1ed9t d\u1eef li\u1ec7u s\u1ebd ch\u01b0a m\u1ed9t…\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.engisv.info\/?p=3574\" \/>\n<meta property=\"og:site_name\" content=\"EngISV\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/engisv\" \/>\n<meta property=\"article:published_time\" content=\"2018-08-21T01:34:53+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.engisv.info\/wp-content\/uploads\/2018\/07\/sql-1.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"639\" \/>\n\t<meta property=\"og:image:height\" content=\"542\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"hoanghiepktv\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"hoanghiepktv\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"8 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.engisv.info\\\/?p=3574#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.engisv.info\\\/?p=3574\"},\"author\":{\"name\":\"hoanghiepktv\",\"@id\":\"https:\\\/\\\/www.engisv.info\\\/#\\\/schema\\\/person\\\/dcbab2ddc35f4c71f45c7e13f36367bf\"},\"headline\":\"C\u00e1c ki\u1ec3u d\u1eef li\u1ec7u trong SQL\",\"datePublished\":\"2018-08-21T01:34:53+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.engisv.info\\\/?p=3574\"},\"wordCount\":1641,\"publisher\":{\"@id\":\"https:\\\/\\\/www.engisv.info\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.engisv.info\\\/?p=3574#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.engisv.info\\\/wp-content\\\/uploads\\\/2018\\\/07\\\/sql-1.jpg\",\"articleSection\":[\"Database\",\"Ki\u1ebfn th\u1ee9c\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.engisv.info\\\/?p=3574\",\"url\":\"https:\\\/\\\/www.engisv.info\\\/?p=3574\",\"name\":\"C\u00e1c ki\u1ec3u d\u1eef li\u1ec7u trong SQL - EngISV\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.engisv.info\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.engisv.info\\\/?p=3574#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.engisv.info\\\/?p=3574#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.engisv.info\\\/wp-content\\\/uploads\\\/2018\\\/07\\\/sql-1.jpg\",\"datePublished\":\"2018-08-21T01:34:53+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.engisv.info\\\/?p=3574#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.engisv.info\\\/?p=3574\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.engisv.info\\\/?p=3574#primaryimage\",\"url\":\"https:\\\/\\\/www.engisv.info\\\/wp-content\\\/uploads\\\/2018\\\/07\\\/sql-1.jpg\",\"contentUrl\":\"https:\\\/\\\/www.engisv.info\\\/wp-content\\\/uploads\\\/2018\\\/07\\\/sql-1.jpg\",\"width\":639,\"height\":542},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.engisv.info\\\/?p=3574#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.engisv.info\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"C\u00e1c ki\u1ec3u d\u1eef li\u1ec7u trong SQL\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.engisv.info\\\/#website\",\"url\":\"https:\\\/\\\/www.engisv.info\\\/\",\"name\":\"EngISV\",\"description\":\"H\u00e3y b\u1eaft \u0111\u1ea7u t\u1eeb nh\u1eefng vi\u1ec7c nh\u1ecf!\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.engisv.info\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.engisv.info\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.engisv.info\\\/#organization\",\"name\":\"EngISV\",\"url\":\"https:\\\/\\\/www.engisv.info\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.engisv.info\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.engisv.info\\\/wp-content\\\/uploads\\\/2018\\\/06\\\/logo2-3-1-1.png\",\"contentUrl\":\"https:\\\/\\\/www.engisv.info\\\/wp-content\\\/uploads\\\/2018\\\/06\\\/logo2-3-1-1.png\",\"width\":200,\"height\":76,\"caption\":\"EngISV\"},\"image\":{\"@id\":\"https:\\\/\\\/www.engisv.info\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/engisv\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.engisv.info\\\/#\\\/schema\\\/person\\\/dcbab2ddc35f4c71f45c7e13f36367bf\",\"name\":\"hoanghiepktv\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/645a174195a58b43e64a66af9255c62adc3c73faba32dda89a76c2778e9b3172?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/645a174195a58b43e64a66af9255c62adc3c73faba32dda89a76c2778e9b3172?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/645a174195a58b43e64a66af9255c62adc3c73faba32dda89a76c2778e9b3172?s=96&d=mm&r=g\",\"caption\":\"hoanghiepktv\"},\"url\":\"https:\\\/\\\/www.engisv.info\\\/?author=2\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"C\u00e1c ki\u1ec3u d\u1eef li\u1ec7u trong SQL - EngISV","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.engisv.info\/?p=3574","og_locale":"en_US","og_type":"article","og_title":"C\u00e1c ki\u1ec3u d\u1eef li\u1ec7u trong SQL - EngISV","og_description":"Trong b\u00e0i vi\u1ebft tr\u01b0\u1edbc, ch\u00fang ta \u0111\u00e3 t\u00ecm hi\u1ec3u c\u00e1c kh\u00e1i ni\u1ec7m v\u1ec1 SQL, Database… trong \u0111\u00f3 c\u00f3 \u0111\u1ec1 c\u1eadp \u0111\u1ebfn Ki\u1ec3u d\u1eef li\u1ec7u (Data Type), trong b\u00e0i n\u00e0y ch\u00fang ta s\u1ebd \u0111i t\u00ecm hi\u1ec3u v\u1ec1 c\u00e1c ki\u1ec3u d\u1eef li\u1ec7u trong SQL. Ki\u1ec3u d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c khai b\u00e1o khi b\u1ea1n t\u1ea1o b\u1ea3ng cho c\u01a1 s\u1edf d\u1eef li\u1ec7u. C\u00e1c c\u1ed9t d\u1eef li\u1ec7u c\u1ee7a b\u1ea3ng s\u1ebd ph\u1ea3i \u0111\u01b0\u1ee3c \u0111\u1ecbnh ngh\u0129a c\u00e1c ki\u1ec3u d\u1eef li\u1ec7u t\u01b0\u01a1ng \u1ee9ng m\u00e0 n\u00f3 c\u00f3 th\u1ec3 ch\u1ee9a. N\u00f3i m\u1ed9t c\u00e1ch kh\u00e1c, m\u1ed7i c\u1ed9t d\u1eef li\u1ec7u s\u1ebd ch\u01b0a m\u1ed9t…","og_url":"https:\/\/www.engisv.info\/?p=3574","og_site_name":"EngISV","article_publisher":"https:\/\/www.facebook.com\/engisv","article_published_time":"2018-08-21T01:34:53+00:00","og_image":[{"width":639,"height":542,"url":"https:\/\/www.engisv.info\/wp-content\/uploads\/2018\/07\/sql-1.jpg","type":"image\/jpeg"}],"author":"hoanghiepktv","twitter_card":"summary_large_image","twitter_misc":{"Written by":"hoanghiepktv","Est. reading time":"8 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.engisv.info\/?p=3574#article","isPartOf":{"@id":"https:\/\/www.engisv.info\/?p=3574"},"author":{"name":"hoanghiepktv","@id":"https:\/\/www.engisv.info\/#\/schema\/person\/dcbab2ddc35f4c71f45c7e13f36367bf"},"headline":"C\u00e1c ki\u1ec3u d\u1eef li\u1ec7u trong SQL","datePublished":"2018-08-21T01:34:53+00:00","mainEntityOfPage":{"@id":"https:\/\/www.engisv.info\/?p=3574"},"wordCount":1641,"publisher":{"@id":"https:\/\/www.engisv.info\/#organization"},"image":{"@id":"https:\/\/www.engisv.info\/?p=3574#primaryimage"},"thumbnailUrl":"https:\/\/www.engisv.info\/wp-content\/uploads\/2018\/07\/sql-1.jpg","articleSection":["Database","Ki\u1ebfn th\u1ee9c"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.engisv.info\/?p=3574","url":"https:\/\/www.engisv.info\/?p=3574","name":"C\u00e1c ki\u1ec3u d\u1eef li\u1ec7u trong SQL - EngISV","isPartOf":{"@id":"https:\/\/www.engisv.info\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.engisv.info\/?p=3574#primaryimage"},"image":{"@id":"https:\/\/www.engisv.info\/?p=3574#primaryimage"},"thumbnailUrl":"https:\/\/www.engisv.info\/wp-content\/uploads\/2018\/07\/sql-1.jpg","datePublished":"2018-08-21T01:34:53+00:00","breadcrumb":{"@id":"https:\/\/www.engisv.info\/?p=3574#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.engisv.info\/?p=3574"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.engisv.info\/?p=3574#primaryimage","url":"https:\/\/www.engisv.info\/wp-content\/uploads\/2018\/07\/sql-1.jpg","contentUrl":"https:\/\/www.engisv.info\/wp-content\/uploads\/2018\/07\/sql-1.jpg","width":639,"height":542},{"@type":"BreadcrumbList","@id":"https:\/\/www.engisv.info\/?p=3574#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.engisv.info\/"},{"@type":"ListItem","position":2,"name":"C\u00e1c ki\u1ec3u d\u1eef li\u1ec7u trong SQL"}]},{"@type":"WebSite","@id":"https:\/\/www.engisv.info\/#website","url":"https:\/\/www.engisv.info\/","name":"EngISV","description":"H\u00e3y b\u1eaft \u0111\u1ea7u t\u1eeb nh\u1eefng vi\u1ec7c nh\u1ecf!","publisher":{"@id":"https:\/\/www.engisv.info\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.engisv.info\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.engisv.info\/#organization","name":"EngISV","url":"https:\/\/www.engisv.info\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.engisv.info\/#\/schema\/logo\/image\/","url":"https:\/\/www.engisv.info\/wp-content\/uploads\/2018\/06\/logo2-3-1-1.png","contentUrl":"https:\/\/www.engisv.info\/wp-content\/uploads\/2018\/06\/logo2-3-1-1.png","width":200,"height":76,"caption":"EngISV"},"image":{"@id":"https:\/\/www.engisv.info\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/engisv"]},{"@type":"Person","@id":"https:\/\/www.engisv.info\/#\/schema\/person\/dcbab2ddc35f4c71f45c7e13f36367bf","name":"hoanghiepktv","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/645a174195a58b43e64a66af9255c62adc3c73faba32dda89a76c2778e9b3172?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/645a174195a58b43e64a66af9255c62adc3c73faba32dda89a76c2778e9b3172?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/645a174195a58b43e64a66af9255c62adc3c73faba32dda89a76c2778e9b3172?s=96&d=mm&r=g","caption":"hoanghiepktv"},"url":"https:\/\/www.engisv.info\/?author=2"}]}},"_links":{"self":[{"href":"https:\/\/www.engisv.info\/index.php?rest_route=\/wp\/v2\/posts\/3574","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.engisv.info\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.engisv.info\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.engisv.info\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.engisv.info\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=3574"}],"version-history":[{"count":3,"href":"https:\/\/www.engisv.info\/index.php?rest_route=\/wp\/v2\/posts\/3574\/revisions"}],"predecessor-version":[{"id":3780,"href":"https:\/\/www.engisv.info\/index.php?rest_route=\/wp\/v2\/posts\/3574\/revisions\/3780"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.engisv.info\/index.php?rest_route=\/wp\/v2\/media\/3559"}],"wp:attachment":[{"href":"https:\/\/www.engisv.info\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=3574"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.engisv.info\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=3574"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.engisv.info\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=3574"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}} | | | | | | | | | | | | | | | | |