• The article was nice. I hopoe the code is right. But when I tried to run the code I am getting error in the Insert statement.

    BEGIN

    INSERT INTO CaseDetail VALUES(200,300,1)

    SET @count = @count -1

    END

    I am not having time to check the error but do we require to write the column names in the syntax. I may done some silly mistakes also.