Insert Multiple Rows into Table in SQL Server

This article contains T SQL Script to insert multiple rows into table in single statement with different ways in SQL Server like by using UNOIN, UNION ALL. You can choose best way as per your wish. But If you have 1000 of records I would suggest you to go

www.morgantechspace.com