如果对该Id的引用被删除，我如何使经理Id 0？ [英] How can i make manager Id 0 if reference to that Id Gets deleted?

问题描述

Hii，



我有一张名为Employee的桌子。其中我有列员工ID和经理ID ..（经理ID只是员工）



一名员工可以设置为许多员工的经理。 。



我想编写一个程序，如果有任何员工被删除，那么员工被设置为经理，那些员工经理ID变为0 ..请建议我SP为

Hii,

I have a table called Employee. In which i have columns Employee Id and manager Id.. (Manager Id is nothing but Employees only)

One Employee can be set to As a manager for many Employees ..

I want to write one procedure in which if Any Employee deleted , Whwere that Employee is set as Manager , those Employees Manager Id changes to 0 .. Please suggest me SP for that

推荐答案

UPDATE Employee
SET EmployeesManagerID = 0
WHERE EmployeeID = @EmployeeID

DELETE FROM Employee WHERE EmployeeID = @EmployeeID

然后将其包装在一个事务中并检查错误和结果她的提交或回滚。

Then just wrap it in a transaction and check for error and either commit or rollback.

这篇关于如果对该Id的引用被删除，我如何使经理Id 0？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！