update VendorSettings set Value='/changepassword/changepassword/index.html?resettoken={0}&username={1}' where Value='/changepassword/changepassword/index.html?resettoken={0}'


update vs
set value='https://www.essencesmartcare.com/essence-smartcare-license-agreement-and-terms-conditions/'
from VendorSettings vs
	join VendorSettingsTypes t on t.Id=vs.SettingTypeId and t.RowId='28793E9E-D041-4EA8-9087-823CD63EE665'