DotNetNuke - T-SQL manually update to clear password for known user name

DotNetNuke - T-SQL manually update to clear password for known user name

declare @password as varchar(100)
declare @username as varchar(100)
set @password = 'xxxxx'
set @username = 'yyyyy'
begin tran
update aspnet_Membership set
[Password] = @password,
PasswordFormat = 0
where UserId in
(select top 1 UserId from aspnet_Users where UserName = @username)
commit