please helppmee

Question

CREATE PROC ContactCreateOrUpdate
@ContactID int,
@DeezNutz varchar(50),
@TVT varchar(50),
@Address varchar(50),
@EmailID varchar(50),
AS
BEGIN
IF(@ContactID=0)
INSERT INTO Contact(Name,Mobile,Address,[Email ID])
VALUES(@DeezNutz ,@TVT ,@Address,@EmailID)

END
ELSE
BEGIN
UPDATE Contact
SET
Name = @DeezNutz ,
Mobile = @TVT ,
Address = @Address
EmailID = @EmailID

	  WHERE ContactID= @ContactID  

END
END

Msg 156, Level 15, State 1, Procedure ContactCreateOrUpdate, Line 8
Incorrect syntax near the keyword 'AS'.
Msg 156, Level 15, State 1, Procedure ContactCreateOrUpdate, Line 15
Incorrect syntax near the keyword 'ELSE'.
Msg 102, Level 15, State 1, Procedure ContactCreateOrUpdate, Line 22
Incorrect syntax near 'EmailID'.

Answer 1

Please try the following.

SQL

CREATE PROC ContactCreateOrUpdate
    @ContactID INT,
    @Name VARCHAR(50),
    @Mobile VARCHAR(50),
    @Address VARCHAR(50),
    @EmailID VARCHAR(50)
AS
BEGIN
    IF (@ContactID = 0)
    BEGIN
        INSERT INTO Contact
        (
            Name,
            Mobile,
            Address,
            [Email ID]
        )
        VALUES
        (@Name, @Mobile, @Address, @EmailID);
    END;
    ELSE
    BEGIN
        UPDATE Contact
        SET Name = @Name,
            Mobile = @Mobile,
            Address = @Address,
            EmailID = @EmailID
        WHERE ContactID = @ContactID;
    END;
END;

Answer 2

There are two issues in your stored procedure. The first one is that in the last parameter @EmailID varchar(50) you do not need to put a comma (,). The second issue is that there are two BEGIN statements and three END statements. You can add the BEGIN statement in the IF statement:

IF (@ContactID=0) 
BEGIN
    INSERT INTO Contact(Name,Mobile,Address,[Email ID])
    VALUES(@Name,@Mobile,@Address,@EmailID)
END

or remove the END statement in the IF statement:

IF (@ContactID=0) 
        INSERT INTO Contact(Name,Mobile,Address,[Email ID])
        VALUES(@Name,@Mobile,@Address,@EmailID)