Tech
Forums
Jobs
Books
Events
Live
Interviews Prep
More
Learn
Training
Career
Members
Videos
News
Blogs
Login
Sign Up
Ask Question
2
Reply
SQLBULKCOPY function in .NET
Murugavel S
Mar 21 2017 2:48 AM
248
Reply
Hi,
I am doing sqlbulkcopy from one table to another table.
There are so many tables to do that.
I am copying data with for loop for each tables.
But, i am facing with an issue, whenever i copy data from source table to destination table than identity column value is getting changed.
Suppoose there is value like this in identity column of a source table
301
305
605
but when i copy data than it will imported in destination table like that
1
2
3
1) I have tried,
set identity_insert [tablename] ON
//COPY Data from source to destination
set identity_insert [tablename] OFF
Upload Source Code
Select only zip and rar file.
Post
Reset
Cancel
Answers (
2
)
Next Recommended Forum
Create multiple installer c# executables, wpf and AppServer
Step by step manual for PickSingleFileAndContinue?