Difference between question of sql server

Most frequently asked Difference Between Question for SQL. (Click on each to see the Details)


1. Difference between Varchar and NVarchar Datatype in Sql Server

2. Difference between Char and varchar Datatype in Sql Server

3. Difference between Primary Key and Unique Key Datatype in Sql Server

Difference between Table and View

Below list is major difference between Table and View in SQL Server;

Table	View
Table contains Data.	View doesn’t contains data.
Table is physically existence.	View doesn’t physically existence. It’s like virtual table.
You can perform insert, update, delete and Select for it.