SQL

5. Updating/Deleting Data - SQL Code(open)

◀ ▷ ▶ ♤ ♠ ♡ ♥ ♧ ♣ ⊙e 2022. 11. 17. 13:03
반응형
Code

	--update date
select*
from[SQL Tutorial].dbo.EmployeeDemographics

update[SQL Tutorial].dbo.EmployeeDemographics
setEmployeeID =1012, age=31, Gender='female'
whereFirstName='Stanley'and LastName ='Hudson'


	--delete data
select*from[SQL Tutorial].dbo.EmployeeDemographics
whereEmployeeID =1003--지워질 data 지우기전에 확인차 select - excute 1차
deletefrom[SQL Tutorial].dbo.EmployeeDemographics
whereEmployeeID =1003--execute 2차 때 지워진다.