27,579
社区成员
发帖
与我相关
我的任务
分享
CREATE TRIGGER t_GROUPUSER ON dbo.GROUPUSER
FOR INSERT
AS
if (SELECT COUNT(*)
FROM GROUPUSER,inserted
WHERE (GROUPUSER.GROUPUSERID=inserted.GROUPUSERID)
AND (GROUPUSER.GROUPID=inserted.GROUPID)
AND (GROUPUSER.USERID=inserted.USERID)
AND (GROUPUSER.GROUPUSERNAME = inserted.GROUPUSERNAME) )>1
begin
print '记录已存在!'
rollback transaction
end
GO
insert into [GROUPUSER](USERID,GROUPID)
select [USER].USERID , [GROUP].GROUPID from [USER],[GROUP]
where
NO EXISTS(SELECT 1 FROM USER.USEID=GROUPUSER.USEID AND GROUP.GROUPID=GROUOPUSER.GROUPID) AND
GROUPNAME='" + ddlGroup.SelectedValue + "' and USERNAME='" + lblName.Text + "'";