EXISTS in SQL Server

SQL Server - Data Types

Main categories of SQL Server Data Types,
1.      Numeric 
a.      Exact Numeric 
b.      Approximate Numeric 
2.      Date and Time 
3.      Character String 
a.      Non-Unicode Character String 
b.      Unicode Character String 
4.      Binary 
5.      Others

The following detail as given below,

DATA TYPES
SYNTAX
DESC
Integer           
INTEGER         
It is integer data type and used to specify an integer value.
Smallint
SMALLINT
It is small lint data type and used to specify small integer value.
Numeric
NUMERIC(X, Y)
It is numeric data type. Here X is a precision value and Y is scale values.
Real
REAL
It is a real integer and used to specify a single precision floating point number.
Decimal
DECIMAL(X, Y)
It is decimal data type. Here X is a precision value and Y is scale values.
Double
DOUBLE
It is a double precision and used for floating point number.
Float
FLOAT(X)
It is a floating point values like (2.3, 1.5 etc.) and X is precision value.
Character varying
VARCHAR2(X)

Character
CHAR(X)

varchar(max)
VARCHAR(MAX)

Bit varying
BIT VARYING(X)

Bit
BIT(X)

Date
DATE

text
TEXT

Time
TIME

DateTime
DATETIME

Timestamp
Timestamp

smalldatetime
SMALLDATETIME





ANIL SINGH

Hey! I'm Anil Singh. I author this blog. I'm Active Blogger, Programmer. I love learning new technologies, programming, blogging and participating the forum discussions more...
My Blogs - http://www.code-sample.com and http://www.code-sample.xyz
My Books - Google Amazon and Flipkart Book Store!

You Might Also Like
Post a Comment
www.code-sample.com/. Powered by Blogger.
ASK Questions
SQL Server NodeJs TypeScript JavaScript Angular SQL Server My Book