Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2005 Forums
 Transact-SQL (2005)
 Insert Bulk Data

Author  Topic 

gaurav.five
Starting Member

2 Posts

Posted - 2008-12-17 : 01:13:31
Hello Friends,

This is Gaurav,I am havin an small problem I have to in sert bulk data into 2 tables one is USER and another is Records table
1. USER table having fields as
UserId
Password
RecordId foreign key

2. RECORDS table having fields as
RecordId Auto generated number abd Primary key
AttributeId
RecordValue

I have to insert data into these table in bulk at the same time
my problem is that how i will get th RecorID to insert into User table



Gaurav

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2008-12-17 : 01:15:54
whats the source? from where you want records to be inserted?
Go to Top of Page
   

- Advertisement -