Data types in SQL Server
Below are the data types (data types) in SQL Server, including character strings, numbers and times / dates.
Character string data type in SQL Server
Below are the types of character string data in SQL Server (Transact-SQL).
Data type syntax Maximum size Explanation CHAR (kich_thuoc) Maximum of 8000 characters.- kich_thuoc is the number of characters stored.
- Fixed length.
- Add a space to the right to offset the space for enough characters.
- Does not contain Unicode characters.
- kich_thuoc is the number of characters stored.
- Custom length.
- If specified as toi_da, the maximum is 2GB.
- Does not contain Unicode characters.
- Custom length.
- Does not contain Unicode characters.
- Fixed length.
- Unicode character.
- kich_thuoc is the number of characters stored.
- Custom length.
- If the number toi_da is specified, the maximum number of characters is 2GB.
- Unicode character.
- Custom length.
- Unicode character.
- kich_thuoc is the number of characters stored.
- Fixed length.
- Add a space to compensate the space for enough characters.
- Binary data.
- kich_thuoc is the number of characters stored.
- Custom length.
- If specified as toi_da, the maximum is 2GB.
- Binary data.
- Custom length.
- Binary data.
Data type in SQL
Digital data type in SQL Server
Below is a list of numeric data types in SQL Server (Transact-SQL).
Syntax of data type Maximum size Explain BIT integers 0, 1 or NULL TINYINT from 0 to 255 SMALLINT from -32768 to 32767 INT -2,147,483,648 to 2,147,483,647 BIGINT from -9,223,372,036,854,775,808 to 9,223,372,036,808,80,807 DECIMAL (m, d)- The default m is 18 if not specified.
- d default is 0 if not specified.
- The default m is 18 if not specified.
- d default is 0 if not specified.
m is the total number of numbers and d is the number of numbers after the comma.
Synonym with DECIMAL data type.
NUMERIC (m, d)- The default m is 18 if not specified.
- d default is 0 if not specified.
m is the total number of numbers and d is the number of numbers after the comma.
Synonym with DECIMAL data type.
FLOAT (n) number of commas n is defaulted to 53 if not specified. n is the number of bits stored in a chemical symbol. REAL is equivalent to FLOAT (24) SMALLMONEY from - 214,748.3648 to 214,748.3647 MONEY from -922,337,203,685,477,5808 to 922,337,203,685,477,5807Date / time data type in SQL Server
Below is a list of date / time data types in SQL Server (Transact-SQL).
Syntax of data type Maximum size Explain DATE value from '0001-01-01' to '9999-12-31. displayed as 'YYYY-MM-DD' DATETIME- Date taken from '1753-01-01 00:00:00' to '9999-12-31 23:59:59'.
- Hours are taken from '00: 00: 00' to '23: 59: 59: 997'
- value taken from '0001-01-01' to '9999-12-31'.
- Time taken from '00: 00: 00 'to' 23: 59: 59: 9999999 '.
- The value is from '1900-01-01' to '2079-06-06'.
- Time taken from '00: 00: 00 'to' 23: 59: 59 '.
- The value is from '00: 00: 00.0000000 'to' 23: 59: 59.9999999 '.
- Date taken from '0001-01-01' to '9999-12-31'.
- time value taken from '00: 00: 00 'to' 23: 59: 59: 9999999 '.
- Time zone taken from -14: 00 to +14: 00.
Previous article: PIVOT clause in SQL Server
The following article: CREATE TABLE command in SQL Server
4.5 ★ | 2 Vote
You should read it
May be interested
- HOW TO INSTALL ISA SERVER ENTERPRISE 2000 - Part IIone of the most important parts on isa server systems is to understand exactly what services are running on isa server, how these services work together, and with what types of isa clients. a simple diagram can be sketched as follows about the main services running on the isa server.
- Encryption in SQL Server 2005encryption is an important method of data security. sensitive data such as cmt numbers, credit card numbers, passwords ... need to be protected against numerous current threats. in sql server 2000 you can create your own functions or use external dlls to encrypt data. in sql server 2005, functions and methods
- SQL Server 2005 - Next generation data analysis and management softwaretoday, organizations are always faced with data difficulties: the development of data and systems in business operations; it is necessary to provide employees, customers and partners with access to data in a timely manner
- What is the future of server virtualization?server virtualization can help combat poor server performance, make better use of computing capabilities, limit energy consumption and improve data center flexibility.
- How to create a copy of data in MS SQL Serverthis is the guide to create backup for database in ms sql server.
- Create VPN Server on Windows 8no need to install any additional applications, you can easily 'turn' your computer into a vpn server if you're using windows 8. in this way, you can share data from the computer. as a simple lan system in the form of remote access. & a
- C ++ exercises have solutions (sample code) for variables, data types, and operatorsin the previous c ++ exercises, tipsmake.com introduced, you were acquainted with many types of lessons, from simple to complex. in this c ++ exercise, we will become familiar with c ++ exercises on variables and data types in c ++.
- What types of data are for sale on the dark web?what are the most popular types of data for sale on the dark web?
- The difference between web server and app serveryou have probably seen that the terms web server and app server are often used interchangeably as if they are related to the same thing and also facilitate the website to function properly. but in reality, they are not the same.
- How to set up your own email server on Windows PCtoday, almost all popular web-mail providers, including gmail, yahoo and outlook, regularly scan users' email, which is big data. so should lovers and privacy promotion surrender to the power of big data companies?