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     Licensing       EULA       Sitemap      
© Data & Object Factory, LLC.
Made with    in Austin, Texas.      Vsn 1.3.0