procedure [dbo].[Update_ForgotPassword]
(
@Userid varchar(300),
@Status varchar(50) output,
@uniqueCode varchar(100)
)
as
begin
declare @count int
select @count=COUNT(*) from Table_where Email=@Userid
if(@count>0)
begin
update Table_set UniqueCode=@uniqueCode where Email=@Userid
set @Status ='Success'
end
else
begin
set @Status ='email Id is not registered with us'
end
end