Monday, December 3, 2007

What are the different data type available in MS SQL Server

What are the different data type available in MS SQL Server

There are 2 news datatypes available in MSSQL server 2000 which are bigint and sql_variant.

Other data types available in MSSQL.

Binary

Bigint

bit

Char

datetime

Decimal

Float

image

Int

Money

Nchar

Ntext

nvarchar

Numeric

Real

Smalldatetime

smallint

smallmoney

sql_variant

sysname

Text

timestamp

tinyint

varbinary

varchar

Uniqueidentifier

No comments: