Home  /  Questions  /  Question



0   0
14 days ago


About Sql insert parent and child records best practice

Dear Jack:

At first,thanks for your sql databse framework production,i m really enjoy for this.
As title ,in your document refers to scope_identity to solve child record insert,
But in my job experience,output is more flexible ,please refer this article
https://stackoverflow.com/questions/42648/best-way-to-get-identity-of-inserted-row
I just wonder your document released after 2012 ,if scope_identity is still the best practice,please explain it.
If not,maybe you need to update document for this practice.
Finally,expect your excellence data model ,can not wait for it!
SQL
 1 comment
 
Nice --- David William  11 days ago