Products

Data Converter Cleaner TUC - Unit Converter Import Export Survey Manager Tweet Controller

Developer

Article Blog Forum Interview Beginner News Startup Quiz

Users

Career

Apply Job Internship

Pricing

Login Sign Up Get a Quote

How to Create A Stored Procedure for Insert and Update Data ?

Anonymous User 1482 31 Jul 2018

Anonymous User

A_Philosopher

I am a content writter !

1 Answers

Anonymous User 31 Jul 2018

//---------Create a procedure for Add new record--------//

CREATE Proc ContactCreateOrUpdate

@ContactID int,

@Name varchar(50),

@Mobile varchar(50),

@Address varchar(50)



AS

    BEGIN

       IF(@ContactID=0)

     Begin

         insert into Contact(Name,Mobile,Address) values(@Name, @Mobile, @Address)

     END



     Else

         Begin

         update Contact Set Name=@Name, Mobile=@Mobile, Address=@Address

      where  ContactID=@ContactID

     END

   END

advertising