删除: if NOT Exists(select deptid from 表 WHERE FARdEPTID = @DEPTID) DELETE 表 where deptid = @DEPTID 更新:如果不更新ID就无所谓更新难度了。更新ID时: Declare UpdateTable Cursor for (select deptid from 表 WHERE FARdEPTID = @DEPTID_Old) OPEN UpdateTable FETCH NEXT FROM UpdateTable INTO @Temp WHILE @@FETCH_STATUS = 0 BEGIN update 表 set farDeptID = @DEPTID_New Where farDeptID =@DEPTID_Old and DeptId = @Temp FETCH NEXT FROM OneEquipInfo INTO @Temp ENDCLOSE OneEquipInfo DEALLOCATE OneEquipInfo update 表 set DeptID = @DEPTID_New Where DeptID = @DEPTID_Old
if NOT Exists(select deptid from 表 WHERE FARdEPTID = @DEPTID)
DELETE 表 where deptid = @DEPTID
更新:如果不更新ID就无所谓更新难度了。更新ID时:
Declare UpdateTable Cursor for (select deptid from 表 WHERE FARdEPTID = @DEPTID_Old) OPEN UpdateTable FETCH NEXT FROM UpdateTable
INTO @Temp
WHILE @@FETCH_STATUS = 0
BEGIN
update 表 set farDeptID = @DEPTID_New Where farDeptID =@DEPTID_Old and DeptId = @Temp
FETCH NEXT FROM OneEquipInfo
INTO @Temp
ENDCLOSE OneEquipInfo
DEALLOCATE OneEquipInfo
update 表 set DeptID = @DEPTID_New Where DeptID = @DEPTID_Old
信息处
办公室
公安局
刑侦处
办公室我要得到每一级的全称,如:公安局刑侦处办公室