SQL Server Create Database and Table (INSERT UPDATE DELETE TRUNCATE)

Codevlogs Started the tutorial series for Microsoft Sql Server .

in this videos shows how to create a database , create a table , perform insert update delete truncate operations in Microsoft Sql Server 2012

INSERT - INSERT VALUE THROUGH QUERY , INSERT DIRECTLY TO TABLE "INSERT INTO (Column1,Column2,Column3) VALUES(''Value1",2,"Value3")

DELETE - DELETE A ROW FROM TABLE

"DELETE FROM Table1 Where Column1=2"

UPDATE - UPDATE CERTAIN VALUES OF THE TABLE

"UPDATE Table1 Set Column2=Value1 Where Column1=2"

TRUNCATE- CLEAR ALL ROWS THE TABLE AND CREATE INDEX

"TRUNCATE TABLE Table1;

Please Share and Support