我有一个角色分配用户的查询
MAcmd.CommandText = "INSERT INTO ROLES (UserId,GroupId) SELECT UserId,GroupId FROM Users, Groups WHERE username= '" + TextBox1.Text + "' AND rolename='" + TextBox2.Text + "'";
我想实现计数SQL查询，使记录不repeately保存在
但我不知道该怎么做，在C＃中。
e.g我发现一个存储过程...
e.g SELECT @Count = Count(UserID) FROM UserRoles WHERE
RoleID = @RoleID AND UserID = @UserID
IF @Count = 0
INSERT INTO UserRoles(UserID, RoleID)
VALUES(@UserID, @RoleID)