USE [qappdotnet]
GO
/****** Object:  StoredProcedure [dbo].[webhook]    Script Date: 10/23/2018 18:11:46 ******/
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
ALTER PROCEDURE [dbo].[webhook]
 @Email varchar (500),
  @Saldo varchar(8),
  @Coins varchar(2000)
AS BEGIN SET NOCOUNT ON

 Declare @Confirma varchar(500)
 SELECT DISTINCT @Confirma =  COUNT (*) from Usuarios where Email=@Email

if(@Confirma <> 1)

 begin

UPDATE qappdotnet.dbo.Usuarios
SET Saldo=@Saldo,Coins = @Coins
WHERE Email=@Email;

Select @Confirma as Respuesta
 end


 if(@Confirma = 1)
 begin
 Select @Confirma as Respuesta
 end


END