DaniWeb IT Discussion Community - View Single Post

Re: Add or Update stored procedure

Dec 3rd, 2008

Well on that case you need to have an else statement

 Help with Code Tags 
 sql Syntax (Toggle Plain Text) 
IF @rc IS NULL
   BEGIN
  --SET @rc = 0
    INSERT INTO Method VALUES (@Method, @Mdescript)
         SELECT @@IDENTITY
    END
    ELSE
       UPDATE YOUR RECORD
       SELECT @RC
IF @rc IS NULL
   BEGIN
  --SET @rc = 0
    INSERT INTO Method VALUES (@Method, @Mdescript)
         SELECT @@IDENTITY
    END
    ELSE
       UPDATE YOUR RECORD
       SELECT @RC

Some people get so rich they lose all respect for humanity. That's how rich I want to be.