Skip to content

dwarakalakshmi/FAISQL_Exersie_DML

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

2 Commits
 
 
 
 

Repository files navigation

SQL Server Exercise 2

Insert, Update & Delete Statement

In this exercise you have to perform DML operations by using Insert, Update, Delete & Truncate Statements.

  1. Write a query to insert a record in Customer table.
CustomerID CustomerName Email Age Phone
1 Peter Peter@gmail.com 28 234-364-2879
  1. Write an insert query to insert multiple records in Customer table.
CustomerID CustomerName Email Age Phone
2 James James@gmail.com 25 346-238-2737
3 Steve Steve@gmail.com 30 384-238-1278
  1. Write a query to update Age to 28 and Email to James@hotmail.com in Customer table for CustomerID=2.
  2. Write a query to delete a record from Customer table where CustomerID is 3.
  3. Write a query to delete all records from Customer table and make sure it cannot be rolled back.

About

No description, website, or topics provided.

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published