Easily find issues by searching: #<Issue ID>
Example: #1832
Easily find members by searching in: <username>, <first name> and <last name>.
Example: Search smith, will return results smith and adamsmith
Aqua Data Studio / nhilam |
Follow
824
|
Data Type Name | Raw Type | Length (Range) |
Precision (Range) |
Scale (Range) |
Description |
NUMERIC DATA TYPES | |||||
BIT | BIT | X | X | X | bit - Integer data with either a 1 or 0 value. |
DECIMAL | NUMERIC | X | 15 | 5 | binary - Fixed-length binary data with a maximum length of 8,000 bytes. decimal - Fixed precision and scale numeric data from -10^38 +1 through 10^38 1. |
FLOAT | NUMERIC | X | X | X | float - Floating precision number data from -1.79E + 308 through 1.79E + 308. |
INT | NUMERIC | -2,147,483,648 through 2,147,483,647 | X | X | int - Integer (whole number) data from -2^31 (-2,147,483,648) through 2^31 - 1 (2,147,483,647). |
MONEY | NUMERIC | X | X | X | money - Monetary data values from -2^63 (-922,337,203,685,477.5808) through 2^63 - 1 (+922,337,203,685,477.5807), with accuracy to a ten-thousandth of a monetary unit. |
NUMERIC | NUMERIC | X | 15 | 5 | numeric - Functionally equivalent to decimal. |
REAL | NUMERIC | -3.4E+38 to 3.4E+38 | X | X | real - Floating precision number data from -3.40E + 38 through 3.40E + 38. |
SMALLINT | NUMERIC | -32,768 through 32,767 | X | X | smallint - Integer data from 2^15 (-32,768) through 2^15 - 1 (32,767). |
SMALLMONEY | NUMERIC | X | X | X | smallmoney - Monetary data values from -214,748.3648 through +214,748.3647, with accuracy to a ten-thousandth of a monetary unit. |
TINYINT | NUMERIC | 0 through 255 | X | X | tinyint - Integer data from 0 through 255. |
UNIQUEIDENTIFIER | CHARACTER | X | X | X | uniqueidentifier - A globally unique identifier (GUID). |
CHARACTER DATA TYPES | |||||
CHAR | CHARACTER | X | X | char - Fixed-length non-Unicode character data with a maximum length of 8,000 characters. | |
NCHAR | CHARACTER | X | X | nchar - Fixed-length Unicode data with a maximum length of 4,000 characters | |
NTEXT | CHARACTER | X | X | ntext - Variable-length Unicode data with a maximum length of 2^30 - 1 (1,073,741,823) characters. | |
NVARCHAR | CHARACTER | X | X | nvarchar - Variable-length Unicode data with a maximum length of 4,000 characters. sysname is a system-supplied user-defined data type that is functionally equivalent to nvarchar(128) and is used to reference database object names. | |
TEXT | CHARACTER | 2^31 - 1 bytes max | X | X | text - Variable-length non-Unicode data with a maximum length of 2^31 - 1 (2,147,483,647) characters. |
VARCHAR | CHARACTER | 8000 bytes max | X | X | varchar - Variable-length non-Unicode data with a maximum of 8,000 characters. |
DATE & TIME DATA TYPES | |||||
DATETIME | TIMESTAMP | X | X | X | datetime - Date and time data from January 1, 1753, through December 31, 9999, with an accuracy of three-hundredths of a second, or 3.33 milliseconds. |
SMALLDATETIME | DATETIME | X | X | X | smalldatetime - Date and time data from January 1, 1900, through June 6, 2079, with an accuracy of one minute. |
TIMESTAMP | CHARACTER | X | X | X | timestamp - A database-wide unique number that gets updated every time a row gets updated. |
BINARY & LARGE OBJECT DATA TYPES | |||||
BINARY | BINARY | 1 through 8,000 | X | X | |
IMAGE | BLOB | X | X | X | image - Variable-length binary data with a maximum length of 2^31 - 1 (2,147,483,647) bytes. |
VARBINARY | BINARY | 1 through 8,000 | X | X | varbinary - Variable-length binary data with a maximum length of 8,000 bytes. |
About AquaClusters Privacy Policy Support Version - 19.0.2-4 AquaFold, Inc Copyright © 2007-2017