5 Replies Latest reply on Jan 21, 2013 5:26 PM by Purvesh K

    How to return statement

      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.