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

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 developer. How can I insert multiple values in table using… Continue Reading...

Source: SQL SERVER – Insert Multiple Records Using One Insert Statement – Use of UNION ALL | Journey to SQL Authority with Pinal Dave