Data types in MS SQL Server

A data type is an attribute that specifies the type of data that the object can hold

Data types in MS SQL Server
Data types, Sql Server, Data Type, thetechfoyer,

This Articles helps you to understand different Data types in MS SQL Server

1. What is the difference between varchar and nvarchar types?
Ans: Varchar and nvarchar are same but the only difference is that nvarhcar can be used to store Unicode characters for multiple languages and it also takes more space when compared with varchar.

2. What are the possible values of a BOOLEAN data field?
Ans: In PostgreSQL, the BOOLEAN data type exists explicitly and takes values TRUE, FALSE, or NULL. In Microsoft SQL Server, the BIT datatype is used to store Boolean values as integers 1 (true) or 0 (false).

3. What do mean by XML Datatype?
Ans: XML data type is used to store XML documents in the SQL Server database. Columns and variables are created and store XML instances in the database.

Exact Numeric Data Types