23 Dec 2013 by OriginalGriff
You can't use a WHERE clause with INSERT.INSERT always create a new record, it can't change existing ones.Probably you want an UPDATE command instead:UPDATE UserProfile SET Rented=@Rented WHERE [UserName]=@UserBut, I wouldn't do it like that - I'd have a separate table for rented, which...