Get Scope_Identity after error check

• Chris Lane-152984

  Mr or Mrs. 500

  Points: 576

  More actions

  March 31, 2008 at 6:59 pm

  #74662

  Hi,

  I was wondering if the following code will work after an Insert statement.

  -- Check For Errors

  SELECT @myERROR = @@ERROR, @myRowCount = @@ROWCOUNT

  IF @myERROR != 0 GOTO HANDLE_ERROR

  RETURN 0

  SET @OrderId = SCOPE_IDENTITY()

  Will the SET @OrderId = SCOPE_IDENTITY() still give the id that was created if it comes after the error check?

• Sergiy

  SSC Guru

  Points: 110192

  More actions

  March 31, 2008 at 7:31 pm

  #796247

  Yes.

  But you can exclude any doubts by doing this in one go:

  SELECT @myERROR = @@ERROR,

  @myRowCount = @@ROWCOUNT,

  @OrderId = SCOPE_IDENTITY()

  IF @myERROR != 0 GOTO HANDLE_ERROR

  RETURN 0

  _____________
  Code for TallyGenerator

• Chris Lane-152984

  Mr or Mrs. 500

  Points: 576

  More actions

  March 31, 2008 at 9:48 pm

  #796279

  Cool, thank you for your answer and suggestion it is much appreciated!