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 |
|
chandralvsrr
Starting Member
7 Posts |
 Posted - 2011-08-08 : 08:30:07
|
| Hi,I am trying to upload CSV file into SQL Server using Bulk Insert.But how to insert unique identifier(newid() which needs to be created while inserting record into table). Can you please assist.Thanks and Regards,RaviLVSR Ravichandra |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
|
|
radjiv1
Starting Member
3 Posts |
Posted - 2011-08-24 : 11:43:27
|
| You have to declare one column as "int identity(1,1)" in the destination MS SQL table. This allows you to implement sequence of autoincrement values.Radjiv |
 |
|
|
|
|
|
Bulk Insert