Insert bulk data
Database
1
Posts
1
Posters
0
Views
1
Watching
-
Microsoft SQL 2005 --------------------- I created a table name items. which has to be updated with multiple rows at once, only the ID is Unique. (more details) SO when i updated a record there would be six rows with the same items but with different ID. GIVEN BELOW IS A SAMPLE (6 times) --------------------------------- ID | Name | Model| Price --------------------------------- 0001 MotorCar Mazda 62000.00 0002 MotorCar Mazda 62000.00 0003 MotorCar Mazda 62000.00 0004 MotorCar Mazda 62000.00 0005 MotorCar Mazda 62000.00 0006 MotorCar Mazda 62000.00 I guess a range(eg.1 to 15) is required to validate the number of time You may required to update a record. Any suggestion on this would be great indeed. thanks.
so much of happy ending...