删(根据ID删除员工主表数据,根据员工ID删除员工和部门关系表数据)
create proc myDelData
(
@EmployeeID int
)
as
begin
begin tran myTran
delete from TDepartment where
ID=@EmployeeID--删除员工表数据
delete from Mapping_Employee_Department where employeeID=@EmployeeID
--根据员工ID从员工表和部门关系对应关系表中删除部门信息
delete from Mapping_Employee_Department where employeeID=@EmployeeID
--根据员工ID从员工表和部门关系对应关系表中删除部门信息
if(@@ERROR<>0)
rollback tran myTran--回滚事务
else
commit tran myTran--提交事务
else
commit tran myTran--提交事务
end