Forum Stats

  • 3,769,955 Users
  • 2,253,036 Discussions
  • 7,875,251 Comments

Discussions

(users can explicitly insert values into the identity column)

hi~

What happens when you use IDENTITY column defined as “BY DEFAULT” (users can explicitly insert values into the identity column) for a primary key column, will an insert statement fail in the case when the sequence next value already exists in the identity column?