Update MEMBER SET UserName=@UserName,
Password=@Password,
Name=@Name,
Telephone=@Telephone,
Email=isnull(@Email,Email),
Address=isnull(@Address,Address),
--case when @Email<>"" then Email=@Email, --case when @Address<>"" then Address=@Address Where MemberID=@MemberID
Password=@Password,
Name=@Name,
Telephone=@Telephone,
Email=isnull(@Email,Email),
Address=isnull(@Address,Address),
--case when @Email<>"" then Email=@Email, --case when @Address<>"" then Address=@Address Where MemberID=@MemberID
Password=@Password,
Name=@Name,
Telephone=@Telephone,
Email=@Email,
Address=@Address,
Email=case when @Email<>"" then @Email else Email end,
Address=case when @Address<>"" then @Address else Address end Where MemberID=@MemberID
Address=case when @Address<>"" then @Address else Address end
而是""
改称:
Email=case when @Email<>'' then @Email else Email end,
Address=case when @Address<>'' then @Address else Address end