In this part we use the Insert update and delete statement. Generally, insert statement use for insert data into table it maybe one or more row at a time insert into table. Update statement responsible for update data which is already present into table then we can modify the data. Delete statement is responsible for remove recode from table. Now given bellow the example code and explain the code:
/*select Table*/ select * from [dbo].[TestSelectInto] /*Insert into row*/ insert into [dbo].[TestSelectInto](Name,Email) values('Farhan Sakib','email@example.com') /*Update into row*/ Update [dbo].[TestSelectInto] set Name= 'Farhan' where Emailfirstname.lastname@example.org' /*Delete into row*/ Delete [dbo].[TestSelectInto] where Email='Samanzer'
Now we can see the three query for insert, Update, and Delete the recode from the specific table.