I have an sql script that has over 100,000 individual insert statements. The sql is correct as I it will run if I choose small portions of the statements but it will not run if I run the entire script. It throws an error but does not give a reason like it typically does. I have opened the script in management studio to see if their may be something wrong with one of the statements but it all looks correct. I have run scripts in the past and it will usually insert up to a point and then give me an error. It will not even insert the first row, but if I select just that row and execute it inserts no issue.
Could their be a limit to the number of inserts allowed? Here is a small sample of the insert statements. They are all basically the same just a lot more.
Insert into test (Article_ID, Product_ID, Name, Description, Type, Category, Color, Price, Commission, Currency, URL_Product, URL_Picture__big_ ) values ( 101661638, 1005344977, 'In Russ We Trust', 'Exclusive to Morel Tees - Show your support for one of the NBA''s "premier" point guards - Oklahoma City Thunder''s Russell Westbrook. Design depicts the Oklahoma City skyline, the #0 and the faith that Oklahoma City Thunder fan''s have for their star point guard. Limited Time Only Online Only', 'Men''s Premium T-Shirt', 'T-Shirts', 'royal blue', 25, 9.6, 'USD', 'http://ift.tt/1NHxgYY', 'http://ift.tt/20rKQRB' );
Insert into test (Article_ID, Product_ID, Name, Description, Type, Category, Color, Price, Commission, Currency, URL_Product, URL_Picture__big_ ) values ( 16746212, 1001526574, 'Team Trash Talk - Crossover', 'Exclusive to Morel Tees - Team Trash Talk ankle breaking crossover. A must have for those that lack trash talk game.', 'Men''s T-Shirt', 'T-Shirts', 'white', 20, 2, 'USD', 'http://ift.tt/1NHxdwj', 'http://ift.tt/20rL4YK' );
Insert into test (Article_ID, Product_ID, Name, Description, Type, Category, Color, Price, Commission, Currency, URL_Product, URL_Picture__big_ ) values ( 16746194, 1001526704, 'Team Trash Talk - Crossover', 'Exclusive to Morel Tees - Team Trash Talk ankle breaking crossover. A must have for those that lack trash talk game.', 'Men''s T-Shirt', 'T-Shirts', 'black', 20, 2, 'USD', 'http://ift.tt/1NHxhfA', 'http://ift.tt/20rLtdM' );
Insert into test (Article_ID, Product_ID, Name, Description, Type, Category, Color, Price, Commission, Currency, URL_Product, URL_Picture__big_ ) values ( 16211582, 1001098367, 'Team Trash Talk - Jumpshot', 'Exclusive to Morel Tees - Team Trash Talk deadly jump shot This is a must have for all those that spend their time in pick up games. Let everyone else know that the court is now yours.', 'Men''s T-Shirt', 'T-Shirts', 'white', 20, 2, 'USD', 'http://ift.tt/1NHxfEr', 'http://ift.tt/20rLCOn' );
Actual error is - Query completed with errors
Aucun commentaire:
Enregistrer un commentaire