Learn Sql Server in 60 Days – Day 5

Video is ready, Click Here to View ×


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.
1.Local
2.Global

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,
Age int
);
UNIQUE
PRIMARY KEY

CHECK
DEFAULT

sql tutorials for beginners

coder

Leave a Reply

Your email address will not be published. Required fields are marked *