python ruby-programming-language Smalltalk Vue.js Knockoutjs TypeScript JavaScript, OOPs JavaScript Angular 8,7,6,5,4 and 2 Interview Questions and Answers Angular 8,7,6,5,4 and 2 Interview Questions and Answers Angular 4 Angular 2 AngularJs 1.x NodeJs Perl Programming R Programming RequireJs Rust Programming Backbonejs closure programming language go-programming-language kotlin-programming-language
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

Hi there! Welcome to my blog. My name is Anil Singh. I'm a author of this blog. For more detail about me, kindly refer to this link..
My Blogs - http://code-sample.com and http://code-sample.xyz
My Books - Interview Questions and Answers Books- Get Your Book in 15+ Digital Stores Worldwide..

You Might Also Like
www.code-sample.com/. Powered by Blogger.
ASK Questions