Wednesday 9 October 2013

07.Delete all the records from the Employee table in the AdventureWorks database where the department ID is 5.

select * from HumanResources.EmployeeDepartmentHistory
delete from HumanResources.EmployeeDepartmentHistory
where DepartmentID=3

No comments:

Post a Comment