解决用友U8删除用户时提示“用户已启用”不能删除的问题

USE UFSystem
go

DECLARE @cUser_Id NVARCHAR(20)
SET @cUser_Id='用户的登录名'

DELETE l FROM dbo.UA_TaskLog l INNER JOIN dbo.ua_Task t ON t.cTaskId = l.cTaskId WHERE t.cUser_Id=@cUser_Id
DELETE FROM dbo.ua_Task WHERE cUser_Id=@cUser_Id

  

posted @ 2019-02-14 09:38  网事  阅读(2091)  评论(0编辑  收藏  举报