Master/Detail insert using BCP?

Posted by Joseph on Stack Overflow See other posts from Stack Overflow or by Joseph
Published on 2010-04-13T10:16:35Z Indexed on 2010/04/13 10:23 UTC
Read the original article Hit count: 665

Filed under:

bcp

|

masterdetail

I've a master table with identity on for the primary key and I've some child tables. When I insert a record to the master table using BCP, how can I use the newly created ID from the master table to insert in the related child tables (May be BCP again)? Will it be possible? I may be able to set identity off, but, will it work?

Thanks Joseph

© Stack Overflow or respective owner

Related posts about bcp

Minimum install of SQL Server 2008 required to able to run bcp

as seen on Server Fault - Search for 'Server Fault'
I need to run bcp.exe on a client machine which has no SQL Server 2008 installed. Does anyone know the minimum install options I need to select to get the bcp tool? I tried 'Client Tools Connectivity' but that didn't include it. Thanks, Jon >>> More
Master/Detail insert using BCP?

as seen on Stack Overflow - Search for 'Stack Overflow'
I've a master table with identity on for the primary key and I've some child tables. When I insert a record to the master table using BCP, how can I use the newly created ID from the master table to insert in the related child tables (May be BCP again)? Will it be possible? I may be able to set identity… >>> More
BCP task hangs while executing

as seen on Stack Overflow - Search for 'Stack Overflow'
Hey guys, We have a HPC node that runs some of our tasks in it. I have a task in my .net project that kicks the bcp utility on the HPC node and the output of the query that I have runs into 9 Mb. When the HPC node runs this task the output of the query is dumped into a file and then after it dumps… >>> More
Run a shell command with arguments from powershell script

as seen on Stack Overflow - Search for 'Stack Overflow'
Hello, I need to extract and save a some tables from a remote SQL database using bcp. I would like to write a powershell script to invoke bcp for each table and save the data. So far I have this script that creates the necessary args for bcp. However I can not figure out how to pass the args to bcp… >>> More
Can Sql Server BULK INSERT read from a named pipe/fifo?

as seen on Stack Overflow - Search for 'Stack Overflow'
Is it possible for BULK INSERT/bcp to read from a named pipe, fifo-style? That is, rather than reading from a real text file, can BULK INSERT/bcp be made to read from a named pipe which is on the write end of another process? For example: create named pipe unzip file to named pipe read from named… >>> More

Related posts about masterdetail

Master/Detail insert using BCP?

as seen on Stack Overflow - Search for 'Stack Overflow'
I've a master table with identity on for the primary key and I've some child tables. When I insert a record to the master table using BCP, how can I use the newly created ID from the master table to insert in the related child tables (May be BCP again)? Will it be possible? I may be able to set identity… >>> More
JSF library for Master - Details screen

as seen on Stack Overflow - Search for 'Stack Overflow'
I have a JSF - Spring - iBatis Technical stack I need to create Master Details relationship screen with two level of Master _Details captured in single screen Which JSF library gives support for such requirements ??? Exact Need : Have to create at least 5-6 screens with Header- Line - LineItemDetails… >>> More
How to create master/detail view in Microsoft dynamic CRM 4.0?

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi Can anybody please show me step by step how to create Master/Detail(Parent/Child) view in Microsoft Dynamic CRM 4.0? Thanks >>> More
Metro: Creating a Master/Detail View with a WinJS ListView Control

as seen on Stephen Walter - Search for 'Stephen Walter'
The goal of this blog entry is to explain how you can create a simple master/detail view by using the WinJS ListView and Template controls. In particular, I explain how you can use a ListView control to display a list of movies and how you can use a Template control to display the details of the selected… >>> More
Metro: Creating a Master/Detail View with a WinJS ListView Control

as seen on Stephen Walter - Search for 'Stephen Walter'
The goal of this blog entry is to explain how you can create a simple master/detail view by using the WinJS ListView and Template controls. In particular, I explain how you can use a ListView control to display a list of movies and how you can use a Template control to display the details of the selected… >>> More