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.
| Author |
Topic |
|
velliraj
Yak Posting Veteran
59 Posts |
 Posted - 2008-04-28 : 15:45:49
|
| Please someone help to get out this situationHow to perform bulk insertion in a table for different records |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-04-28 : 15:47:25
|
| Your problem is not clear. What do you mean by different records? Have you looked up BULK INSERT in SQL Server Books Online?Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
 |
|
|
velliraj
Yak Posting Veteran
59 Posts |
Posted - 2008-04-28 : 15:59:00
|
| Insert records in a table up to 600 records with the same existing data btu with additional field added i.e A record already exists with data like id, dateNow the same A record has to be inserted with id, date, phoneno.so A record has two datas with addtional field added. |
|
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2008-04-28 : 16:00:37
|
| I don't see a problem with that.Tara KizerMicrosoft MVP for Windows Server System - SQL Serverhttp://weblogs.sqlteam.com/tarad/ |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2008-04-29 : 00:21:32
|
quote:
Originally posted by velliraj
Insert records in a table up to 600 records with the same existing data btu with additional field added i.e A record already exists with data like id, dateNow the same A record has to be inserted with id, date, phoneno.so A record has two datas with addtional field added.
DIdnt understand the difficulty in this. Cant you use INSERT SELECT statement for this? |
|
|
|
|
|
|
Insertion