MS SQL update column

Vote count:

0

In table A have data Type Varchar and column name consits of:

MatricNo Email Name Remarks

If 1 MatricNo can have multiple Email.

How can i update only one of the email if one MatricNo have more than one email? If i using below sql statment 'No row effected' In table A have data Type Varchar and column name consits of:

MatricNo Email Name Remarks

If 1 MatricNo can have multiple Email.

How can i update only one of the email if one MatricNo have more than one email? If i using below sql statment 'No row effected'

UPDATE A  
SET  Email =@usermail   --abc@gmail.com(to be update)
    ,Name = @full_name  --abc
    ,Remarks = @remarks --test`

WHERE MatricNo = @MatricNo --123456
      AND (Email = @Email) --abc123@

edited 4 secs ago

asked 1 min ago

Boom

4

MS SQL update column