CREATE Procedure resetpwd
@USER varchar(50)
as
Begin
update tb_UserInfo
set Password = (select u.Password
from tb_Account a
inner join tb_UserInfo u
on a.Guid = u.UserGuid
where a.ID = 'root')
from tb_Account ab
inner join tb_UserInfo ub
on ab.Guid = ub.UserGuid
where ab.ID = @USER

End