Table of Contents

sql data types

Comment

# Numeric Types BIT TINYINT SMALLINT INT BIGINT DECIMAL NUMERIC FLOAT REAL # Date & Time Types DATE TIME DATETIME TIMESTAMP YEAR # Char & String Types (N) Denotes Unicode Versions CHAR VARCHAR TEXT NCHAR NVARCHAR NTEXT # Binary Data Types BINARY VARBINARY IMAGE # Misc CLOB BLOB XML JSON

Popularity
10/10 Helpfulness
4/10
Language
sql

Source: www.journaldev.com

Tags: sql
types

Link to this answer

Share

Kaotik

Contributed on Mar 02 2020

Kaotik

0 Answers Avg Quality 2/10

Closely Related Answers

column data type in sql

Comment

SELECT DATA_TYPE FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = ‘yourSchemaName’ AND TABLE_NAME = ‘yourTableName’ AND COLUMN_NAME = ‘yourColumnName’

Popularity
9/10 Helpfulness
5/10
Language
sql

Source: WorldLinkAnswers

Tags: find

Link to this answer

Share

Avenger

Contributed on Dec 02 2022

Avenger

0 Answers Avg Quality 2/10

data types sql server

Comment

/*<br />
INT: used to store integers (whole numbers) in the range of<br />
-2^31 (-2,147,483,648) to 2^31 – 1 (2,147,483,647). It is commonly used to<br />
store primary keys, identity columns, and other types of integer-based data.</p>
<p>BIGINT: used to store integers in the range of -2^63 (-9,223,372,036,854,775,808)<br />
to 2^63 – 1 (9,223,372,036,854,775,807) . It is useful for storing large numbers<br />
that cannot fit in the INT range.</p>
<p>SMALLINT: used to store integers in the range of -32,768 to 32,767.</p>
<p>TINYINT: used to store integers in the range of 0 to 255. It is commonly used<br />
to store small numerical data, such as a “status” or “flag” column that can only<br />
have a few different possible values.</p>
<p>FLOAT: used to store floating-point numbers, which are numbers that have a<br />
decimal point. It can store very large or very small numbers, with a large<br />
number of digits to the right of the decimal point. It is more efficient in<br />
terms of storage space and speed of calculations, but less precise than DECIMAL<br />
or NUMERIC.</p>
<p>DECIMAL and NUMERIC: used to store fixed-point numbers, which are numbers that<br />
have a fixed number of digits to the right of the decimal point. They are more<br />
precise than float, but the storage size and speed of calculations are relatively<br />
larger. They are recommended to be used for financial calculations where<br />
precision is key.</p>
<p>DATE, DATETIME, DATETIME2 : used to store date and time values. DATE stores only<br />
the date part, DATETIME stores both the date and time parts, and DATETIME2<br />
stores both the date and time parts, with a higher precision.</p>
<p>CHAR, VARCHAR, NVARCHAR: used to store character-based data. CHAR stores<br />
fixed-length strings and VARCHAR stores variable-length strings. NVARCHAR is<br />
used to store Unicode characters and is useful when you want to store multiple<br />
languages.</p>
<p>BINARY, VARBINARY: used to store binary data, such as images or files. BINARY<br />
stores fixed-length binary data and VARBINARY stores variable-length binary data.</p>
<p>BIT: used to store Boolean values (true/false or 1/0).<br />
*/

Popularity
8/10 Helpfulness
4/10
Language
sql

Source: WorldLinkAnswers

Tags: sql
sql-server
sql-serv

Link to this answer

Share

ekkamrit

Contributed on Jan 11 2023

ekkamrit

0 Answers Avg Quality 2/10

data types in sql

Comment

• number(num) – whole numbers up to num digits • number(num,num2) – num whole numbers up to num2 decimals • char(num) – fixed length character/string • varchar2(num) – used for varying length data • date – full date • currency – used for prices

Popularity
10/10 Helpfulness
2/10
Language
sql

Source: WorldLinkAnswers

Tags: sql

Link to this answer

Share

Obedient Ocelot

Contributed on Jan 27 2021

Obedient Ocelot

0 Answers Avg Quality 2/10

sql data type of query

Comment

DECLARE @query nvarchar(max) = ‘select 12.1 / 10.1 AS [Column1]’; EXEC sp_describe_first_result_set @query, null, 0;

Popularity
10/10 Helpfulness
1/10
Language
sql

Source: stackoverflow.com

Tags: sql

Link to this answer

Share

dr4ft

Contributed on Mar 16 2022

dr4ft

0 Answers Avg Quality 2/10

wordlinkanswers

sql data types

Closely Related Answers

column data type in sql

data types sql server

data types in sql

sql data type of query

Leave a Comment Cancel reply