5 Replies Latest reply: Jan 21, 2013 11:26 AM by Purvesh K RSS

    How to return statement

    986182
      Hi Friends

      I want to insert values in a Table and I want one of the value as a return output, like this:

      INSERT INTO Employees (EmpID, Name, Designation)
      VALUES (111, 'Sam', 'Manager')
      RETURN EmpID

      When I execute the statement, one row should be inserted into Employee Table and should return EmpID of that particular row, i.e: 111. How to write a sql statement for this.