SQL Server - Sql Bulk Insert with foreign key relation
Asked By kughan j on 09-Oct-13 09:04 AM
I have two tables header and child with foreign key relation.
I need to insert in to two tables like header will have one row and in child many rows will be inserted.
How to achieve this in single stored procedure? I have a datatable to insert into child for multiple rows.