T-SQL

How to override Table Value Constructor limit of maximum 1000 rows in direct INSERT statement