SQL SERVER – Insert Multiple Records Using One Insert Statement – Use of UNION ALL | Journey to SQL

Update: For SQL Server 2008 there is even better method of Row Construction, please read it here : SQL SERVER - 2008 - Insert Multiple Records Using One Insert Statement - Use of Row Constructor This is very interesting question I have received from new .

blog.sqlauthority.com