Basics of DML in SQL

use Master
/*
Basics of Data Manupulation Languages
*/
Create Database DemoByBurakSeyhan
go
use DemoByBurakSeyhan
go
Create Table Customer
(
   Id int primary key identity(1,1),
   InsertedTime datetime default getdate(),
   DeletedTime datetime null,
   FirstName nvarchar(25) not null,
   MiddleName nvarchar(25) null,
   LastName nvarchar(25) not null,
   Age int not null,
   Gender nvarchar(2) not null,
   BirthDate datetime not null
)
go
   /*
   DML (Data Manupulation Language) Statement
   Insert , Update , Delete , Select
   */
   -- First One is Insert
   Insert Into Customer(FirstName,MiddleName,LastName,Age,Gender,BirthDate) Values('Burak','-','Seyhan',24,'M','1996-07-19 00:00:00.000')
   --Default is insert you dont need a into keyword
   Insert Customer(FirstName,MiddleName,LastName,Age,Gender,BirthDate) Values('Burak','-','Seyhan',24,'M','1996-07-19 00:00:00.000')
go
      -- Select all customers
      Select * from Customer
go
   -- Second one ise Update
   Update Customer set FirstName ='Bob', MiddleName='Jack' , LastName='Smith' Where Id = 4
   --then show new data
   Select * from Customer
go
   -- Third one is Delete
   Delete from Customer -- This code is a dangerous casue you didn't use Where keyword.
   -- I Think the best security is
   Delete from Customer Where Id = 4
   --then show all data from database
   Select * from Customer