This is the Day 5 video of series learn Sql server.you will learn following points,
1.what is identity ? how to use it?
2.Difference between truncate and delete?
3.Temporary Tables : Purpose and Types.
4.what is data integrity?
5.what is constraints?
6.Type of constraint :
NOT NULL :
Ensures that a column cannot have a NULL value
CREATE TABLE Persons (
ID int NOT NULL,
LastName varchar(255) NOT NULL,
FirstName varchar(255) NOT NULL,
sql tutorials for beginners