Jochem Klingeler comments

Repositories
Issues
Comments

Results 2 comments of


                                            Jochem Klingeler

Invalid last inserted id when the table has a trigger with insert statements in SQLSrvConnection

EDIT: Do not use this IdentityGenerator hack, IDENT_CURRENT is not safe to use in scenario's where records are inserted in parallel. We considered using this hack with `SCOPE_IDENT()` instead, but...

Invalid last inserted id when the table has a trigger with insert statements in SQLSrvConnection

> [@JochemKlingeler](https://github.com/JochemKlingeler) how does that `SELECT` work under high concurrency scenarios? Safe to use? It is not, it's very much a hack and it's use should be discouraged. See edit.