Dofactory.com
Dofactory.com
 Back to list
Views:   2K
Replies:  0
Archived

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!
Pei-Geng Hung, Aug 06, 2017
Stay Inspired!
Join other developers and designers who have already signed up for our mailing list.
Terms     Privacy     Cookies       Do Not Sell       Licensing      
Made with    in Austin, Texas.  - vsn 44.0.0
© Data & Object Factory, LLC.