Friday, January 3, 2014

row by row insertion vs bulk insertion

As obvious from the words itself. row by row inserting means it will process insert operation one row at a time for ex in case of cursor, while loop etc.


In case of bulk insertion the operation would process the entire dataset in a set based manner in one go. ex: BULK INSERT statement, INSERT...SELECT, bcp etc)




Please Mark This As Answer if it helps to solve the issue Visakh ---------------------------- http://visakhm.blogspot.com/ https://www.facebook.com/VmBlogs


No comments:

Post a Comment