How do I insert a record into a Sql Server table that has an identity column?
In trying to use Datagrip instead of Sql Server Management Studio, I have come across a major blocker.
I have a Sql Azure table with a primary key "Id" field that is sent as an Identity(1,1). In Datagrip it shows the column as Id INT (auto increment).
I clicked on the table and opened the table editor. I then added a new record but left the Id column blank. However, when I go to commit my changes it says that it cannot insert explicit values for identity column.
Is it not possible to add new records in Datagrip with an identity column?
请先登录再写评论。
Hello Matthew,
I've created the https://youtrack.jetbrains.com/issue/DBE-2922 issue for it. Please follow for updates.