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
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