Limit to number of INSERT statements or VALUES clauses

below style has limitation of 1000

Insert into Table (Column) values ('value1'), ('value2'), ('value3'), ('value4'), ('value5')



two work around, you can use

Insert into Table (Column) values ('value1')

Insert into Table (Column) values ('value2')

Insert into Table (Column) values ('value3')

---

Balmukund Lakhani | Please mark solved if I've answered your question, vote for it as helpful to help other users find a solution quicker

--------------------------------------------------------------------------------

This posting is provided "AS IS" with no warranties, and confers no rights.

--------------------------------------------------------------------------------

My Blog | Team Blog | @Twitter

Author: SQL Server 2012 AlwaysOn - Paperback, Kindle