DELETE Bse_U_R_Rel
FROM Bse_U_R_Rel AS A
INNER JOIN [dbo].[StringSplitToTable](@DelRoleIds,',') AS B ON B.Id=A.Role_Id
WHERE [User_Id]=@User_Id
INSERT INTO Bse_U_R_Rel([User_Id],Role_Id)
SELECT @User_Id,B.Id
FROM [dbo].[StringSplitToTable](@AddRoleIds,',') AS B
WHERE
NOT EXISTS(SELECT * FROM Bse_U_R_Rel WHERE Role_Id=B.Id AND [User_Id]=@User_Id)
此内容由惯性聚合(RSS阅读器)自动聚合整理，仅供阅读参考。 原文来自 — 版权归原作者所有。